Description
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
- Excel 2016 Overview (8:53)
- Customize Excel Environment (12:39)
- Customize Quick Access Toolbar (5:03)
- Customize Ribbon (7:09)
- Navigating Excel (5:05)
- Creating A Basic Worksheet (5:26)
- Save & Save As (7:38)
- Convert To 2016 (3:44)
- Compatibility Checker (6:05)
- Excel 2016 Tell Me or Help (4:52)
Functions & Formulas
- Basic Formulas A (8:56)
- Basic Formulas B (5:26)
- SUM & AVERAGE Functions (15:43)
- MAX & MIN Functions (6:08)
- COUNT & COUNTA Functions (3:58)
- Move, Copy, Cut & Paste Data (11:58)
- Absolute References (6:05)
- Mixed References (8:44)
- AutoFill (7:47)
- FlashFill (6:05)
- Text To Columns (4:43)
Editing Worksheets
- Editing Data (4:49)
- Editing Columns, Rows & Cells (5:07)
- Find & Replace (6:10)
- GoTo (3:56)
- Transpose Data (2:37)
- Adjust Columns & Rows (4:20)
- Spell Check (1:59)
- Smart Lookup & Thesaurus (2:54)
Formatting
- Formatting Text (3:51)
- Basic Number Formats (5:13)
- Basic Customer Number Formats (4:52)
- Borders & Colors (7:15)
- Formatting Shortcuts (3:13)
- Adding Background (1:19)
- Align, Merge & Wrap Cell Contents (6:05)
- Create & Manage Styles (5:33)
- AutoFormat (1:52)
- Applying Themes (8:17)
- Basic Conditional Formatting (3:25)
- Conditional Formatting Manager (2:15)
Printing
- Print Preview (2:55)
- Page Orientation (2:01)
- Print Row & Column Page Titles (7:19)
- Headers & Footers (9:26)
- Page Margins & Centering (4:19)
- Page Breaks (10:29)
- Print Range & Scaling (8:19)
Modifying Worksheet Appearance
- Managing Worksheets (9:18)
- Hide Worksheets & Workbooks (4:45)
- Split Worksheet (2:26)
- Freeze Panes (4:32)
- Multiple Worksheet & Workbook Views (2:45)
- Formula Options (2:45)
- Speak Cells (1:33)
Excel 2016 Level 1 Training Videos (Download) from Dream Force — training videos solutions.
Affordable Excel 2016 Level 1 Training Videos (Download).