Excel 2019, Intermediate EX-036

Course Overview

To efficiently use workbooks and the different management and data analysis tools available. Working with charts and exploring data analysis tools.

Prerequisites

Microsoft Excel 2019 Beginner.

Syllabus

Workbooks:

  • What is a workbook;
  • Working with several sheets in a workbook;
  • Modifying the number of sheets contained in a workbook;
  • Moving and copying sheets;
  • Displaying multiple windows;
  • Viewing several sheets of the same workbook;
  • Protecting sheets;
  • Hiding and displaying sheets;
  • Mastering the rules used for naming cells;
  • Consolidating data;
  • Creating a three dimensional formula;
  • Adding a range of data using the instant data analysis tools;
  • The Watch Window.

Charts:

  • General information about charts;
  • Understanding the different components that are used to create a chart
  • ;Creating the appropriate chart that is best tailored to your data;
  • Customizing a chart;
  • Quickly changing the overall appearance of your charts;
  • Changing the format of a chart;
  • Adding drawings to a chart;
  • Displaying animations contained in charts;
  • Exploring the different types of charts;
  • Creating and using Pie charts;
  • Using data analysis tools;
  • Creating a bank of custom charts.

Lists (Databases):

  • Creating a database;
  • Adding data;
  • Data validation;
  • Using the sort features;
  • Working with filters;
  • Using an advanced filter;
  • Using conditional formatting;
  • Performing calculations within a database;
  • Creating a Pivot Table that is best tailored to your data;
  • Using a list of fields to create different types of Pivot Tables.

Functions and Data Analysis Tools:

  • Mastering the rules used for naming cells;
  • Creating formulas using functions;
  • Understanding Excel’s functions;
  • Using Search functions;
  • Using Logical functions;
  • Using Statistical and Mathematical functions;
  • Using Text functions;
  • Using Financial functions and the Goal Seek tool.

Exploring Data Analysis Tools:

  • Managing views;
  • Managing reports;
  • Managing scenarios
Duration : 2 Days
Regular Rate : 300.00 $
Preferential Rate : 255.00 $
Note :
Upcoming Dates :
qty
Virtual Class
30 Nov and 1 Dec. 2020 - 9:00 to 16:00

Virtual Class
3 and 4 Dec. 2020 - 9:00 to 16:00

Virtual Class
21 and 22 Dec. 2020 - 9:00 to 16:00

Virtual Class
6 and 7 Jan. 2021 - 9:00 to 16:00

Virtual Class
4 and 5 Feb. 2021 - 9:00 to 16:00

Only your registration is missing

Virtual Class
22 and 23 Feb. 2021 - 9:00 to 16:00

Virtual Class
1 and 2 Mar. 2021 - 9:00 to 16:00

Virtual Class
18 and 19 Mar. 2021 - 9:00 to 16:00

Laval
1 and 2 Apr. 2021 - 9:00 to 16:00

Montreal
8 and 9 Apr. 2021 - 9:00 to 16:00

Virtual Class
8 and 9 Apr. 2021 - 9:00 to 16:00

Montreal
6 and 7 May. 2021 - 9:00 to 16:00

Virtual Class
6 and 7 May. 2021 - 9:00 to 16:00

Montreal
27 and 28 May. 2021 - 9:00 to 16:00

Virtual Class
27 and 28 May. 2021 - 9:00 to 16:00

Brossard
10 Jun and 28 May. 2021 - 9:00 to 16:00

Montreal
15 and 16 Jun. 2021 - 9:00 to 16:00

Virtual Class
15 and 16 Jun. 2021 - 9:00 to 16:00

Montreal
22 and 23 Jul. 2021 - 9:00 to 16:00

Virtual Class
22 and 23 Jul. 2021 - 9:00 to 16:00

Laval
3 and 4 Aug. 2021 - 9:00 to 16:00

Montreal
24 and 25 Aug. 2021 - 9:00 to 16:00

Virtual Class
24 and 25 Aug. 2021 - 9:00 to 16:00

Montreal
9 and 10 Sep. 2021 - 9:00 to 16:00

Virtual Class
9 and 10 Sep. 2021 - 9:00 to 16:00