Excel 2016 Level 1 (Download)

(No reviews yet) Write a Review
On Sale
MSRP: $14.95
Now: $9.95
Was: $14.95
— You save $5.00

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

  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

  1. Basic Formulas A (8:56)
  2. Basic Formulas B (5:26)
  3. SUM & AVERAGE Functions (15:43)
  4. MAX & MIN Functions (6:08)
  5. COUNT & COUNTA Functions (3:58)
  6. Move, Copy, Cut & Paste Data (11:58)
  7. Absolute References (6:05)
  8. Mixed References (8:44)
  9. AutoFill (7:47)
  10. FlashFill (6:05)
  11. Text To Columns (4:43)

Editing Worksheets

  1. Editing Data (4:49)
  2. Editing Columns, Rows & Cells (5:07)
  3. Find & Replace (6:10)
  4. GoTo (3:56)
  5. Transpose Data (2:37)
  6. Adjust Columns & Rows (4:20)
  7. Spell Check (1:59)
  8. Smart Lookup & Thesaurus (2:54)

Formatting

  1. Formatting Text (3:51)
  2. Basic Number Formats (5:13)
  3. Basic Customer Number Formats (4:52)
  4. Borders & Colors (7:15)
  5. Formatting Shortcuts (3:13)
  6. Adding Background (1:19)
  7. Align, Merge & Wrap Cell Contents (6:05)
  8. Create & Manage Styles (5:33)
  9. AutoFormat (1:52)
  10. Applying Themes (8:17)
  11. Basic Conditional Formatting (3:25)
  12. Conditional Formatting Manager (2:15)

Printing

  1. Print Preview (2:55)
  2. Page Orientation (2:01)
  3. Print Row & Column Page Titles (7:19)
  4. Headers & Footers (9:26)
  5. Page Margins & Centering (4:19)
  6. Page Breaks (10:29)
  7. Print Range & Scaling (8:19)

Modifying Worksheet Appearance

  1. Managing Worksheets (9:18)
  2. Hide Worksheets & Workbooks (4:45)
  3. Split Worksheet (2:26)
  4. Freeze Panes (4:32)
  5. Multiple Worksheet & Workbook Views (2:45)
  6. Formula Options (2:45)
  7. Speak Cells (1:33)

 

Excel 2016 Level 1 Training Videos (Download)

Excel 2016 Level 1 Training Videos (Download) from Dream Force — training videos solutions.
Affordable Excel 2016 Level 1 Training Videos (Download)
.

View AllClose