Video Training for Microsoft Excel 2013 1.5

ABOUT Video Training for Microsoft Excel 2013

Lecture 01. Basic Excel Word Mail Merge Lecture 02. Protecting Cells and Worksheets Lecture 03. Basic Graph Lecture 04. Copy, Cut, Paste (paste without formatting) Lecture 05. Order of Evaluation (Precedence) Lecture 06. Introduction to Formulas (and Inserting and Deleting Rows and Columns) Lecture 07. Basic Tasks in Excel 2013 - Part 1 Lecture 08. Basic Tasks in Excel 2013 - Part 2 Lecture 09. Basic Formatting Part 1 Lecture 10. Basic Formatting Part 2 Lecture 11. Number Formatting Lecture 12. Personalizing the Environment Using the Backstage Lecture 13. Force Printing on One Page and Navigating the Worksheet Lecture 14. Auto Fill (linear and growth) Lecture 15. More Practice with Basic Formulas (and format currency) Lecture 16. Referencing Worksheets in Formulas (and change Tab Color) Lecture 17. Mail Merge (Ticket Numbers) Lecture 18. How to add Password Protection Lecture 19. How to Hide and Unhide Columns Lecture 20. Named Ranges Lecture 21. Format as Table Lecture 22. Sparklines Lecture 23. Freeze Panes (freeze one or more columns) Lecture 24. Conditional Formatting (data bars,color scales,icon sets) Lecture 25. Comments and Hyperlinks Lecture 26. Text to Columns Lecture 27. Flash Fill (new feature) Lecture 28. COUNTIF Formula Lecture 29. Pivot Tables Lecture 30. Absolute vs Relative Cell Referencing Lecture 31. VLOOKUP formula (with AutoFill) Lecture 32. COUNTA Formula Lecture 33. Financial Formula PMT Function (Calculate Loan Payments) Lecture 34. ScreenShots and Sreen Clipping Lecture 35. Image Editor Lecture 36. Clip Art, SmartArt, and Shapes Lecture 37. Cell Styles Lecture 38. Basic Macro Lecture 39. Quick Analysis (New Feature) Lecture 40. Tutorial for SUMIF function Lecture 41. Tutorial for AVERAGEIF Function Lecture 42. Tutorial for Excel Concatenate Lecture 43. Excel Text Functions - LEFT RIGHT MID FIND Tutorial Lecture 44. Excel Go To Feature Lecture 45. Excel 2013 Tutorial MOS Practice 1.1 Lecture 46. MOS Excel 1.2 Lecture 47. MOS Excel 1.3a Lecture 48. MOS Excel 2013 Practice 1.3b Lecture 49. MOS Excel 2013 Practice 1.3c Lecture 50. MOS Excel 2013 Practice 1.3d Lecture 51. Excel 2013 Tutorial MOS Certification Practice 1.4a Lecture 52. Tutorial for Excel 2013 Tutorial MOS Practice 1.4b part 1 Lecture 53. Tutorial for Excel 2013 Tutorial MOS Practice 1.4b part 2 Lecture 54. Tutorial for MOS Excel 1.4c Certification Practice hiding worksheets Lecture 55. Tutorial for MOS Excel 2013 1.5a Certification Practice (77-882) Lecture 56. MOS Certification 1.5b Training Lecture 57. Inserting Data in Cells and Ranges (Certification Practice 2.1a) Lecture 58. Inserting Data in Cells and Ranges (Certification Practice 2.1b) Lecture 59. Rotating Roster Lecture 60. Tutorial for Certification Practice 2.2a Lecture 61. Tutorial for MOS Certification Practice 2.2b Lecture 62. Order and Group Cells and Ranges Lecture 63. Sparklines (2.3b Certification Practice) Lecture 64. Ordering and Grouping Cells and Ranges (Certification Training 2.3c) Lecture 65. MOS Certification Practice 2.3d Lecture 66. Manage Cells and Ranges - Certification Practice 2.3e Lecture 67. Tutorial for MOS Excel 2013 Tutorial: Certification Practice 3.1 Lecture 68. Tutorial for Excel 2013 Help - MOS Certification Training 3.2 Lecture 69. Tables (Certification Training 3.3) Lecture 70. Objective 4.1 Lecture 71. Counta, Sumifs, and more 4.2 (Functions) Lecture 72. SUMIF SUMIFS COUNTIF COUNTIFS 4.3a Lecture 73. Practice Excel functions: IF, COUNTIF, AND, NOT Lecture 74. Text Functions 4.4 Lecture 75. Create and Format Charts Part 1 Lecture 76. Create and Format Charts Part 2 Lecture 77. Gradebook Template for Teachers Lecture 78. Multiple graphs on one chart Lecture 79. 77-420 Certification Objective 5.3 MOS Excel 2013 Lecture 80. Exam 77-420 Information MOS Excel 2013 Lecture 81. Excel HLOOKUP Tutorial Lecture 82. How to Save As Template Lecture 83. Open a Workbook Automatically when Excel starts