Microsoft/Excel 2019 for users ( 1 Day)/55271-A/MO-200


Excel 2019 for users ( 1 Day) Certification Training Course Overview

During this Microsoft Excel – 2019 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. 

Use the full power of Excel 2019 for Users. Be more productive / help your teams become more productive. 

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!

Target Audience :

  • This Microsoft Excel 2019 Beginner Level 1 course is for anyone who is just starting out in Excel and also wants the latest, newest features available in Excel 2019 and Office 365 Excel skills
  • For those who’ve used Excel, but want to find out some little-known tips, tricks and shortcuts and become more efficient

 

 

This course prepares you for Exam MO-200. Test your current knowledge Qubits42

Excel 2019 for users ( 1 Day) (8 Hours) Download Course Contents

Live Virtual Classroom
Group Training 450

21 Jun
09:00 AM - 05:00 PM CST
(8 Hours/Day)

05 Jul
09:00 AM - 05:00 PM CST
(8 Hours/Day)

02 Aug
09:00 AM - 05:00 PM CST
(8 Hours/Day)

GTR=Guaranteed to Run
1-on-1 Training (GTR) 500
4 Hours
8 Hours
Week Days
Week End


Start Time : At any time

12 AM
12 PM

Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request

Special Solutions for Corporate Clients! Click here

Hire Our Trainers! Click here

Course Modules

  • Chapter 1: Set up a workbook
  • Chapter 2: Work with data and Excel tables
  • Chapter 3: Perform calculations on data
  • Chapter 4: Change workbook appearance
  • Chapter 5: Manage worksheet data
  • Chapter 6: Reorder and summarize data
  • Chapter 7: Create charts and graphics
  • Chapter 8: Use PivotTables and PivotCharts

Request More Information

Course Prerequisites
  • Basic Computer Knowledge.

What you will learn :

  • Build a solid foundation on the Basics of Microsoft Excel
  • Create a Basic Worksheet from scratch
  • Write simple Formulas and performing Calculations
  • Use Relative, Absolute and Mixed References
  • Learn how to do basic and setup your own custom number formats
  • More tips, tricks and shortcuts by a Multi-Certified Microsoft Trainer with over 18 years of Excel training