Excel 2013/2016/2019/2021/365 Intermediate EX-028

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 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;
  • Use a database to create different TCDs

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.

New Features in the 2013 Version:

  • Incorporating data contained in a worksheet directly into a web page;
  • Sharing an Excel worksheet during an online meeting.
Duration : 2 Days
Regular Rate : 350.00 $
Preferential Rate : 297.50 $
Note :

Upcoming Dates

qty

Montreal

29 Feb and 1 Mar. 2024 - 9:00 to 16:00

Virtual Class

29 Feb and 1 Mar. 2024 - 9:00 to 16:00

Confirmed

Virtual Class

28 and 29 Mar. 2024 - 9:00 to 16:00

Virtual Class

11 and 12 Apr. 2024 - 9:00 to 16:00

Laval

2 and 3 May. 2024 - 9:00 to 16:00

Virtual Class

2 and 3 May. 2024 - 9:00 to 16:00

Montreal

23 and 24 May. 2024 - 9:00 to 16:00

Virtual Class

23 and 24 May. 2024 - 9:00 to 16:00

Virtual Class

6 and 7 Jun. 2024 - 9:00 to 16:00

Virtual Class

20 and 21 Jun. 2024 - 9:00 to 16:00

Virtual Class

16 and 17 Jul. 2024 - 9:00 to 16:00

Virtual Class

25 and 26 Jul. 2024 - 9:00 to 16:00

Montreal

6 and 7 Aug. 2024 - 9:00 to 16:00

Virtual Class

6 and 7 Aug. 2024 - 9:00 to 16:00

Virtual Class

22 and 23 Aug. 2024 - 9:00 to 16:00

Virtual Class

4 and 5 Sep. 2024 - 9:00 to 16:00

Montreal

19 and 20 Sep. 2024 - 9:00 to 16:00

Virtual Class

19 and 20 Sep. 2024 - 9:00 to 16:00

Virtual Class

26 and 27 Sep. 2024 - 9:00 to 16:00

Laval

17 and 18 Oct. 2024 - 9:00 to 16:00

Virtual Class

17 and 18 Oct. 2024 - 9:00 to 16:00

Virtual Class

30 and 31 Oct. 2024 - 9:00 to 16:00

Quebec

12 and 13 Nov. 2024 - 9:00 to 16:00

Virtual Class

12 and 13 Nov. 2024 - 9:00 to 16:00

Montreal

28 and 29 Nov. 2024 - 9:00 to 16:00

Virtual Class

28 and 29 Nov. 2024 - 9:00 to 16:00

Virtual Class

3 and 4 Dec. 2024 - 9:00 to 16:00

Qualifying educational activities