Video Training for Microsoft Excel 20131.5 - App Store

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

Requires iOS 8.0 or later. Compatible with iPhone, iPad, and iPod touch.