Excel 2007, Intermediate EX-020

Course Overview

To efficiently use workbooks as well as their tools for management and data analysis. Using graphs and databases. Using different Excel functions and thier database analysis features.


Prerequisites

Microsoft Excel 2007 Beginner.

Syllabus

Day 1

Workbooks :

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

Charts :

  • Creating a chart;
  • Creating a chart with the wizard;
  • Modifying a chart;
  • Formatting the chart;
  • Adding drawings to a chart;
  • Using Pie charts;
  • Creating Pie charts;
  • Using a pie chart with extracted values.

Day 2

Lists (Databases) :

  • Creating a database;
  • Adding data to a sheet;
  • Entering data using the data form;
  • Sorting data;
  • Using filters;
  • Using AutoFilter;
  • Using advanced filters;
  • Using Database functions;
  • Using Formulas;
  • Creating a report with Pivot Table.

Functions and Analysis tools :

  • Understanding Range Names;
  • Creating 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.

Share

[ssba]


Duration : 2 days
Regular Rate : $290
Preferential Rate : $220
Notes :


Upcoming Dates

[ESPRESSO_TICKET_SELECTOR event_id=13435]

Duration : 2 Days
Regular Rate : 290.00 $
Preferential Rate : 220.00 $
Note :
Upcoming Dates :
price
qty
Montreal, 9 to 10 Oct. 2018 - 9:00 to 16:00
290.00 $
Brossard, 9 to 10 Oct. 2018 - 9:00 to 16:00
290.00 $
Laval, 9 to 10 Oct. 2018 - 9:00 to 16:00
290.00 $
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
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 $