fbpx

Data Analysis & Visualization

Microsoft Excel Training

Basic to Advanced

microsoft-excel-logo

OVERVIEW

Organizations all over the world rely on information to make sound decisions regarding all manner of affairs. But with the amount of available data growing on a daily basis, the ability to make sense of all of that data is becoming more and more challenging. Fortunately, this is where the power of Microsoft® Office Excel 2019 can help. Excel can help you organize, calculate, analyze, revise, update, and present your data in ways that will help the decision makers in your organization steer you in the right direction. It will also make these tasks much easier for you to accomplish, and in much less time, than if you used traditional pen-and-paper methods or non- specialized software. This course aims to provide you with a foundation for Excel knowledge and skills, which you can build upon to eventually become an expert in data manipulation.

This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Excel Associate (Office 365 and Office 2019): Exam MO-200 and Excel Expert (Office 365 and Office 2019): Exam MO-201 certifications.

Course Learning Outcomes

Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyse the data that is critical to the success of your organization. You will:

Course Audience Profile

This course is intended for students who wish to gain the foundational understanding of Microsoft Office Excel 2019 that is necessary to create and work with electronic spreadsheets.

  • Module 1: Getting started with Excel 2019
  • Module 2: Performing Calculations
  • Module 3: Modifying Worksheets
  • Module 4: Formatting Worksheets
  • Module 5: Printing Workbooks
  • Module 6: Managing Workbooks
  • Module 7: Basic Excel Customizations & Common Keyboards Shortcuts
  • Module 1: Working with Functions
  • Module 2: Working with List
  • Module 3: Analysing Data
  • Module 4: Visualizing Data with Charts
  • Module 5: Using PivotCharts and PivotTables

Financial Functions

Working with Graphical Objects

Internationalizing Workbooks

Using Array Formulas

  • Module 1: Working with Multiple Worksheets and Workbooks
  • Module 2: Sharing and Protecting Workbooks
  • Module 3: Automating Workbook Functionality
  • Module 4: Using Lookup Functions & Formula Auditing
  • Module 5: Forecasting Data
  • Module 6: Creating Sparklines and Mapping Data

Cube Functions

Importing and Exporting Data

Internationalizing Workbooks

Working with Power Pivots

Advanced Customization Options

Working with Forms and Controls

Share:
Shopping Cart