Excel 2019 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 2019 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 the basics on formulas and functions. In very little time you will master the basics of Excel that'll provide a sure foundation for more intermediate to 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, TRANSPOSE 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 by applying Absolute and, or Mixed References
  • Save time entering data using the AutoFill and FlashFill features
  • Split Worksheet, Freeze Panes and add Multiple Views
  • New to Excel 2019! Sound Feedback, Check Accessibility one click fix, Translate and more

Excel 2019 Level 1 training videos download comes in MP4 (.mp4) file format, with follow along exercise files, instructor notes, quiz and answers!

Learn to do all this and much more by our Microsoft Certified Trainer training Excel 2019!

Excel 2019 Level 1 (6+ hrs):

Basics

  1. Excel 2019 Basics - First Look, Overview (16:07)
  2. Customize Excel Environment (14:20)
  3. Customize Quick Access Toolbar (5:21)
  4. Customize Ribbon (9:02)
  5. Navigating Excel (10:28)
  6. Creating A Basic Worksheet (5:53)
  7. Save & Save As (5:35)
  8. Convert To 2016 (3:43)
  9. Compatibility Checker (7:02)
  10. Excel 2016 Tell Me or Help (3:36)

Functions & Formulas

  1. Basic Formulas (13:20)
  2. SUM & AVERAGE Functions (14:38)
  3. MAX & MIN Functions (4:13)
  4. COUNT & COUNTA Functions (5:03)
  5. Move, Copy, Cut & Paste Data (14:07)
  6. Absolute References (5:56)
  7. Mixed References (5:51)
  8. AutoFill (8:33)
  9. FlashFill (5:59)
  10. Text to Columns (4:47)

Editing Worksheets

  1. Editing Data (7:36)
  2. Editing Columns, Rows & Cells (5:51)
  3. Find & Replace (9:29)
  4. GoTo (5:16)
  5. Transpose Data (4:51)
  6. Adjust Columns & Rows (7:09)
  7. Spell Check (3:32)
  8. Smart Lookup & Thesaurus (3:22)

Formatting

  1. Formatting Text (4:54)
  2. Basic Number Formats (6:11)
  3. Basic Customer Number Formats (6:39)
  4. Borders & Colors (8:04)
  5. Formatting Shortcuts (6:53)
  6. Adding Background (1:56)
  7. Align, Merge & Wrap Cell Contents (8:08)
  8. Create & Manage Styles (6:19)
  9. AutoFormat (2:19)
  10. Basic Conditional Formatting (5:27)
  11. Conditional Formatting Manager (3:40)

Printing

  1. Print Preview (5:36)
  2. Page Orientation (4:44)
  3. Print Row & Column Page Titles (8:18)
  4. Headers & Footers (10:45)
  5. Page Margins & Centering (7:10)
  6. Page Breaks (10:54)
  7. Print Range & Scaling (11:55)

Modifying Worksheet Appearance

  1. Managing Worksheets (12:17)
  2. Hide Worksheets & Workbooks (5:39)
  3. Split Worksheet (3:50)
  4. Freeze Panes (6:19)
  5. Multiple Worksheet & Workbook Views (3:23)
  6. Formula Options (3:22)
  7. Speak Cells (1:54)
  8. Sound Feedback (2:01)
  9. Check Accessibility (1:31)
  10. Translate (1:15)

 

Excel 2019 Level 1 Training Videos (Download)

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

View AllClose