Excel 2016 Level 1 (Download)

Excel 2016 Level 1 training videos download comes in MP4 (.mp4) file format, with follow along exercise files, instructor notes, quiz and answers! Our Excel 2016 Level 1, with Levels 2 & 3 training videos include all the training you need to pass the Excel 2016 Core (77-727) and Expert (77-728) Exams and become certified!

Excel 2016 training videos will explain first what a database is, and then the foundation of the database which are tables. After you'll want to learn how to quickly extract and enter your data in an organized format by using forms. Also, you'll be shown how fun and easy it is to create reports, a way to extract your data from your tables and into a printable format.

Learn to create relationships between tables including the most popularly misunderstood one-to-one relationship, and more by our Microsoft Certified Trainer training Excel 2016!

Excel 2016 Level 1 (5+ hrs):

Basics

1. Excel 2016 Overview (8:53)
2. Customize Excel Environment (12:39)
3. Customize Quick Access Toolbar (5:03)
4. Customize Ribbon (7:09)
5. Navigating Excel (5:05)
6. Creating A Basic Worksheet (5:26)
7. Save & Save As (7:38)
8. Convert To 2016 (3:44)
9. Compatibility Checker (6:05)
10. Excel 2016 Tell Me or Help (4:52)

Functions & Formulas

11. Basic Formulas A (8:56)
12. Basic Formulas B (5:26)
13. SUM & AVERAGE Functions (15:43)
14. MAX & MIN Functions (6:08)
15. COUNT & COUNTA Functions (3:58)
16. Move, Copy, Cut & Paste Data (11:58)
17. Absolute References (6:05)
18. Mixed References (8:44)
19. AutoFill (7:47)
20. FlashFill (6:05)
21. Text To Columns (4:43)

Editing Worksheets

22. Editing Data (4:49)
23. Editing Columns, Rows & Cells (5:07)
24. Find & Replace (6:10)
25. GoTo (3:56)
26. Transpose Data (2:37)
27. Adjust Columns & Rows (4:20)
28. Spell Check (1:59)
29. Smart Lookup & Thesaurus (2:54)

Formatting

30. Formatting Text (3:51)
31. Basic Number Formats (5:13)
32. Basic Customer Number Formats (4:52)
33. Borders & Colors (7:15)
34. Formatting Shortcuts (3:13)
35. Adding Background (1:19)
36. Align, Merge & Wrap Cell Contents (6:05)
37. Create & Manage Styles (5:33)
38. AutoFormat (1:52)
39. Applying Themes (8:17)
40. Basic Conditional Formatting (3:25)
41. Conditional Formatting Manager (2:15)

Printing

42. Print Preview (2:55)
43. Page Orientation (2:01)
44. Print Row & Column Page Titles (7:19)
45. Headers & Footers (9:26)
46. Page Margins & Centering (4:19)
47. Page Breaks (10:29)
48. Print Range & Scaling (8:19)

Modifying Worksheet Appearance

49. Managing Worksheets (9:18)
50. Hide Worksheets & Workbooks (4:45)
51. Split Worksheet (2:26)
52. Freeze Panes (4:32)
53. Multiple Worksheet & Workbook Views (2:45)
54. Formula Options (2:45)
55. Speak Cells (1:33)