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