What Will You Learn?

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...

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


What's Included In The Course?

  • Quizzes
  • Exercise files
  • Instructor's Notes
  • Certificate of Completion

Course Curriculum

  • 1

    Welcome to the course!

    • A message from the instructor
    • Before we begin...
    • How to use this course
    • Instructor Notes and Exercise Files!
  • 2

    Excel 2019 Basics

  • 3

    Functions & Formulas

    • 11. Basic Formulas FREE PREVIEW
    • 12. Introduction to Functions with SUM & AVERAGE Functions
    • 13. MIN & MAX
    • 14. COUNT & COUNTA
    • 15. Move, Copy, Cut, & Paste Data into Cells
    • 16. Absolute & Relative References
    • 17. Mixed References
    • 18. AutoFill
    • 19. FlashFill
    • 20. Converting Text into Columns
    • Quiz!
  • 4

    Editing Worksheets

    • 21. Editing Cell Data
    • 22. Insert & Delete Cells, Columns and Rows
    • 23. Find & Replace Data
    • 24. GoTo
    • 25. TRANSPOSE
    • 26. Change Height, Width and Hide Rows and Columns
    • 27. Check Worksheet or Workbook Spelling with Spell Check
    • 28. Smart Lookup & Thesaurus
    • Quiz!
  • 5

    Formatting

    • 29. Formatting Text
    • 30. Basic Number Formats
    • 31. Basic Custom Number Formats
    • 32. Borders and Colors
    • 33. Formatting Shortcuts
    • 34. Adding Background
    • 35. Align, Merge & Wrap Cell Data
    • 36. Cell Styles
    • 37. AutoFormat
    • 38. Basic Conditional Formatting
    • 39. Conditional Formatting Manager
    • Quiz!
  • 6

    Print

    • 40. Print Page Breaks, Grildines & Headlines
    • 41. Page Orientation
    • 42. Print Rows at the Top of Each Page - Repeat Column Headers
    • 43. Headers & Footers
    • 44. Editing Page Margins & Center on Page
    • 45. Page Breaks
    • 46. Setting Print Range & Scaling
    • Quiz!
  • 7

    Modifying Worksheet Appearance

    • 47. Name, Move, Copy, Color, Link Worksheets in Workbook
    • 48. Hide Worksheets & Workbooks
    • 49. Split Worksheet
    • 50. Freeze Panes
    • 51. New Windows - Multiple Workbook Views
    • 52. Customize Formula Options
    • 53. Speak Cells
    • 54. Sound Feedback (New to 2019!)
    • 55. Accessibility Checker - One Click Fix! (New to 2019!)
    • 56. Translate (New to 2019!)
    • Quiz!
  • 8

    Next steps

    • Congrats! Here's what's next...
    • Before you go...