Microsoft Excel 2013 Tutorials (Beginners Level)
12 views
Skip to first unread message
Khalid Douif
Jan 20, 2016, 10:30:58 AM1/20/16
to ade_e...@yahoogroupes.fr, aien...@googlegroups.com, aiensia...@googlegroups.com, aimaf-...@googlegroups.com, alba...@googlegroups.com, am...@yahoogroupes.fr, E_MBA_GRO...@yahoogroupes.fr, ecoapp...@yahoogroupes.fr, emplois...@googlegroups.com, ensais-l...@googlegroups.com, ensias_logi...@googlegroups.com, ge...@googlegroups.com, iir_em...@googlegroups.com, ingenieur...@googlegroups.com, ingen...@googlegroups.com, ingenieu...@gmail.com, Job_NTI...@yahoogroupes.fr, laurea...@yahoogroups.com, Maroc...@yahoogroupes.fr, maroc_we...@yahoogroupes.fr, maroc...@yahoogroupes.fr, mawa...@yahoogroupes.fr, mba4-...@yahoogroups.com, miage...@yahoogroupes.fr, optionlogi...@gmail.com, SAP_...@yahoogroupes.fr, telecom...@yahoogroupes.fr, tpc...@googlegroups.com
Microsoft Excel 2013 Tutorials (Beginners Level):
A complete introductory course on how to use Microsoft Excel 2013.
Part 1 is here: https://youtu.be/wUzR6HVJLVU
Part 2 is here: https://youtu.be/XeHr7roFphM
The videos contain the folowing items:
[Part 1]
01. Basic Graph
02. Copy, Cut, Paste (paste without formatting)
03. Order of Evaluation (Precedence)
04. Introduction to Formulas (and Inserting and Deleting Rows and Columns)
05.F1 Basic Tasks in Excel 2013: Part 1
06. Basic Tasks in Excel 2013: Part 2
07. Basic Formatting Part 1
08. Basic Formatting Part 2
09. Number Formatting
10. Personalizing the Environment Using the Backstage
11. Force Printing on One Page and Navigating the Worksheet
12. Auto Fill (linear and growth)
13. More Practice with Basic Formulas (and format currency)
14. Referencing Worksheets in Formulas (and change Tab Color)
15. Mail Merge (Ticket Numbers)
16. Basic Excel Word Mail Merge
17. Protecting Cells and Worksheets
18. How to add Password Protection
19. How to Hide and Unhide Columns
20. Named Ranges
21. Format as Table
22. Sparklines
23. Freeze Panes (freeze one or more columns)
24. Conditional Formatting (data bars,color scales,icon sets)
25. Comments and Hyperlinks
[Part 2]
26. Text to Columns
27. Flash Fill (new feature)
28. COUNTIF Formula
29. Pivot Tables
30. Absolute vs Relative Cell Referencing
31. VLOOKUP formula (with AutoFill)
32. COUNTA Formula
33. Financial Formula PMT Function (Calculate Loan Payments)
34. ScreenShots and Sreen Clipping
35. Image Editor
36. Clip Art, SmartArt, and Shapes
37. Cell Styles
38. Basic Macro
39. Quick Analysis (New Feature)
40. SUMIF function
41. AVERAGEIF Function
42. Concatenate Tutorial
43. LEFT RIGHT MID FIND Tutorial
44. Go To Feature
45. Order and Group Cells and Ranges
46. Gradebook Template for Teachers
47. multiple graphs on one chart
48. HLOOKUP
49. How to Save As Template
50. Open a Workbook Automatically when Excel starts
Assiya
Jan 20, 2016, 10:32:30 AM1/20/16
to tpc...@googlegroups.com
Merci Khalid pour le partage
--
Vous recevez ce message, car vous êtes abonné au groupe Google Groupes "tpcour".
Pour vous désabonner de ce groupe et ne plus recevoir d'e-mails le concernant, envoyez un e-mail à l'adresse tpcour+un...@googlegroups.com.
Pour envoyer un message à ce groupe, envoyez un e-mail à l'adresse tpc...@googlegroups.com.
Visitez ce groupe à l'adresse https://groups.google.com/group/tpcour.
Pour obtenir davantage d'options, consultez la page https://groups.google.com/d/optout.
Reply all
Reply to author
Forward
0 new messages