Microsoft/Excel 2019 for users/MO-200


Excel 2019 for users 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. Download Course Contents

Excel 2019 for users Course schedule & Prices

Course Details Schedule
Live Virtual Classroom (Instructor-Led)
Duration : 1 Day (2 Days for 4 Hours/Day)
Fee : 200 (Includes Taxes) 
9 AM - 5 PM (Flexible Time Slots for 4 hours option)




Client's Location
As per mutual convenience
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients. Click here

Enquire Now

Course Prerequisites
  • No formal pre-requisites for this course.

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