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 : 300.00 $
Preferential Rate : 255.00 $
Note :
Upcoming Dates :
qty