Learn: in:
» back to Search Results

Course rating of 4 Vendor rating of 4


Master Excel's analytical & database management tools. Quickly perform data consolidation or other functions, & create charts & 3- dimensional formulas to highlight various areas of your business.

  • Course Start Date: Dec. 7
  • Location: Montreal (Map)
  • Time: 9:00 am - 4:30 pm (Note on end times)
  • Please Note: End Times are approximate and depend
    on the number or students and pace of the class.
    It is important to allow for the class to run a little bit longer,
    or finish a little sooner, than expected.
  • Duration: 2 days
  • Delivery Method(s):Instructor Led
  • Mentored training is a revolutionary training method
    that provides you with the quality training that
    you have come to expect, and combines it with
    flexible learning and a self paced environment.
    For more information click here.
  • Discount Seats Available:2
  • Category:Microsoft Excel Training

 
Course Outline
Master Microsoft Office Excel's analytical and database management tools. Quickly perform data consolidation or other functions, and create charts and three dimensional formulas to highlight various areas of your business. Microsoft Office Excel?s analytical and database management tools will clearly facilitate the interpretation and the management of your data to further assist you with your decesion-making process.

Course Outline 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;
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.

All scheduled courses are available in both English and French on identical dates.
Prerequisites & Certificates
Pre-Requisites

Microsoft Excel 2003 Beginner

Certificates offered

Certificate of completion


Cancellation Policy
All registration cancellations made within five (5) working days of the date of the course are billable at 100%. Synesis reserves the right to cancel any public courses due to lack of sufficient participants.
Map & Reviews
Synesis
[ View Provider's Profile ]

Synesis Inc.
2075 rue Robert-Bourassa
5th Floor

Montreal, Quebec
Canada   H3A 2L1


Reviews
 
I would DEFINITELY recommend this to my co-workers.
Reviewed by 2011
7-December-2016 $232 Regular Price $290 Register for this course

Registration is fast, and will take approximately 3 minutes. There is no membership fee.
» You are also welcome to Make an Offer Make An Offer Help

Not enough budget for this course? Maybe you just love to make deals!
In either case, our Make an Offer feature gives you the opportunity to name
your own price. Try it out, you might get lucky, just keep in mind it can
take up to 1 full business day to get a response!
need-to-train-a-group-banner

Not interested in this Course?

Tell us why:

This page has been viewed 35 times.