Advanced Excel 2019 / Office 365

Detailed Course Outline for Advanced Excel Training

What Are The Objectives of Advanced Excel Training

After Completing the Advanced Excel 365 / 2019 Training Course, Participants will be able to:

• Do complex computations with Advanced Excel Functions & Formulas.
• Organize worksheet and table data using multiple techniques.
• Summarize information quickly using excel pivot tables, and generate Summarized Management Reports Quickly & Easily
• Create and modify charts & graphs With Ease
• Use the Correct Type of Chart in Excel 2019 to Create Meaningful & Insightful Information
• Use Excel Tips & Tricks.
• Be able to create and use the New Charts in Office 365 / Excel 2019 like the Pareto chart to display 80-20 principle in action
• Analyze data using Excel Pivot Tables and Pivot Charts.
• Insert graphic objects to enhance your Excel sheets.
• How to use VLookup & XLookup Functions in Office 365 / Excel 2019.
• Customize and enhance workbooks and the Microsoft Office Excel 2019 environment.

They will learn to deploy Advanced Office 365 / Excel 2019 features to increase productivity and improve efficiency by streamlining the workflow. Learn to:

• collaborate with others using workbooks
• audit worksheets
• analyze data with new features in Office 365 / Excel 2019 training
• Work with multiple worksheets & workbooks using Microsoft Office 365
  
• Import and export data in Excel
• Use Advanced Filters in Office 365 / Excel 2019
  
• Use Pivot tables in Excel
• Using the Quick Analysis Tools Within Excel 2019 / Office 365
  

Participants will learn to use advanced features and functions of Office 365 / Excel 2019 to improve productivity, enhance spreadsheets with templates, charts, graphics, and formulas and streamline their operational work.

•  They will apply visual elements and advanced formulas to a worksheet to display data in various formats with Pivot Tables, Conditional Formatting, Advanced Filtering, and Sorting options.
• Participants will also learn how to automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and leverage on Excel’s advanced functionality to simplify and streamline their day-to-day work.

What are the Pre-Requisites For Attending The Advanced Excel Training?

Basic knowledge of Microsoft Excel is sufficient for you to attend the Advanced Excel training program.

You must know how to start Excel program, key in numbers, text, and do simple formatting. You should know some of the the Basic Excel functions like Sum, Count, Average etc.

Advanced Functions and features of Excel would be taught in this  Excel workshop.

A laptop with the right Excel version pre-loaded is provided for use in the Advanced Excel Tutorial class.

Notes in folders, along with multiple Exercise files to do practice and learn Advanced Excel Features and Functions are provided in the class too.

Who is this Advanced Excel Training Most Suitable For?

Microsoft Advanced Excel 2019 Training / Office 365 program is most suitable for people who use Microsoft Excel in their day-to-day work, and know the basics of Excel pretty well, and would like to extend their knowledge of the more advanced features & functions of Excel to become more productive and make the most of Microsoft Excel 2019 / Office 365.

If you would like to learn how to write VLOOKUP in Excel, or how to Summarize Data using Pivot Tables, then this is the best Advanced Excel course for learning these.

The course is designed for participants who want to learn how to quickly analyze data, sort and filter data, import and export data sets, and understand data using the rich features provided in Excel. It will impart the necessary skills to create simple macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data.

In addition, the course is also for participants desiring to prepare for the Microsoft Certified Application Specialist exam in Microsoft® Office Excel® 2019, and who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.