Excel 2010 Intermediate EX-023

Course Overview

To efficiently use workbooks as well as tools for management and data analysis. Creating charts and analysing data

Prerequisites

Microsoft Excel 2010 Intermediate

Syllabus

Workbooks :

  • Working with several sheets in a workbook;
  • Defining a workbook;
  • Creating a workbook;
  • Working with multiple sheets;
  • Modifying the number of sheets;
  • Modifying the default number of sheets;
  • Moving and copying sheets;
  • Displaying multiple windows;
  • Displaying several windows of the same workbook;
  • Using environments;
  • Protecting sheets;
  • Hiding and displaying sheets;
  • Consolidating data;
  • Creating a three dimensional formula;
  • The Watch Window.

Charts :

  • General overview;
  • Identifying the different elements contained in a chart;
  • Creating a chart;
  • Customizing a chart;
  • Changing the format of a chart;
  • Adding shapes inside a chart;
  • The different types of charts;
  • Using Pie charts;
  • Creating Pie charts;
  • Using a pie chart with extracted value;
  • Using data analysis tools;
  • Create custom charts.

Using Database Functions :

  • Creating a database;
  • Adding data to a sheet;
  • Entering data using the data form;
  • Sorting data;
  • Using filters;
  • Using the AutoFilter;
  • Using the advanced filter;
  • Using database functions;
  • Using formula;
  • Creating a Pivot Table Report.

Functions and Analysis tools :

  • Understanding Range Names;
  • 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 Goal seek;
  • Using analysis tools;
  • Managing custom views;
  • Managing reports;
  • Managing scenarios.
Duration : 2 Days
Regular Rate : 290.00 $
Preferential Rate : 220.00 $
Note :
Upcoming Dates :
price
qty
Montreal, 30 to 31 Oct. 2018 - 9:00 to 16:00
290.00 $
Brossard, 30 to 31 Oct. 2018 - 9:00 to 16:00
290.00 $
Laval, 30 to 31 Oct. 2018 - 9:00 to 16:00
290.00 $
Montreal, 21 to 22 Nov. 2018 - 9:00 to 16:00
Confirmed
290.00 $
Brossard, 21 to 22 Nov. 2018 - 9:00 to 16:00
290.00 $
Laval, 21 to 22 Nov. 2018 - 9:00 to 16:00
290.00 $
Montreal, 19 to 20 Dec. 2018 - 9:00 to 16:00
290.00 $
Brossard, 19 to 20 Dec. 2018 - 9:00 to 16:00
290.00 $
Laval, 19 to 20 Dec. 2018 - 9:00 to 16:00
290.00 $
Montreal, 16 to 17 Jan. 2019 - 9:00 to 16:00
290.00 $
Montreal, 5 to 6 Feb. 2019 - 9:00 to 16:00
290.00 $
Montreal, 21 to 22 Feb. 2019 - 9:00 to 16:00
290.00 $
Montreal, 20 Mar 2019 - 9:00 to 16:00
290.00 $
Montreal, 15 to 16 Apr. 2019 - 9:00 to 16:00
290.00 $
Montreal, 8 to 9 May. 2019 - 9:00 to 16:00
290.00 $
Montreal, 27 to 28 May. 2019 - 9:00 to 16:00
290.00 $
Montreal, 19 to 20 Jun. 2019 - 9:00 to 16:00
290.00 $
Montreal, 24 to 25 Jul. 2019 - 9:00 to 16:00
290.00 $
Montreal, 13 to 14 Aug. 2019 - 9:00 to 16:00
290.00 $