Excel 2016 Level 1 (Download)

Quickly Get a Solid Foundation on Excel Basics   

During this Microsoft Excel Level 1 – Beginner course you will gain a solid foundation on which you will build the rest of your Excel experience on. Enroll now and I'll guide you step-by-step, through the basics of working with formulas, functions and databases. In very little time you will master the basics of Excel that'll provide a sure foundation for more advanced Excel techniques. 

At completion of this course you will have mastered the most popular Excel basic tools and have the foundational skills with a sureness to complete many daily Excel tasks with efficiency and ease.   Below are just a few of the topics that you will master:   

• Build a solid understanding on the basics of Microsoft Excel
• Writing formulas and performing calculations
• SUM, AVERAGE, MIN, MAX, COUNT, COUNTA functions
• Inserting headers and footers, and adjusting margins
• Print row and, or column page titles
• Color code data that meet certain criteria with Conditional Formatting
• Save time applying formatting to other cells with shortcuts
• Copy formulas about with accuracy applying Absolute and, or Mixed References
• Save time entering data using the AutoFill and FlashFill features
• Split Worksheet, Freeze Panes and add Multiple Views

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!

Learn this and much 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)