Excel 2019 for users ( 1 Day) 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

 

 

  • 1. Do you have limited Window for training?
  • 2. Can you only spend 4-hours per day?
  • 3. Do you want to start training immediately?
  • If your answer is yes to any one of the above, you need 1-on-1- Training
The 1-on-1 Advantage
Methodology
Flexible Dates
4-Hour Sessions
  • View video
  • The course will be free if we are not able to start within 7 days of booking.
  • Only applicable for courses on which this logo appears.

Your will learn:

Part 1: Create and format workbooks
  • 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
Live Online Training (Duration : 8 Hours)
Group Training 250 Per Participant Incl. Official Courseware
06 Jun 09:00 AM - 05:00 PM CST
(8 Hours/Day)
04 Jul 09:00 AM - 05:00 PM CST
(8 Hours/Day)
1-on-1 Training 500 300 + If you accept merging of other students. Incl. Official Courseware
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

1-On-1 Training is Guaranteed to Run (GTR)
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Classroom Training is available. Enquire for the fee Click
Comfort Track

If you think 8 hours is too fast, we can offer Comfort Track for 16 hours for only USD 600

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

 

 

 

Request More Information

Add Name and Email Address of participant (If different from you)

FAQ's


The Fee includes:
  • Official courseware
  • Testing Via Qubits
Yes, Koenig Solutions is a Microsoft Learning Partner