Learn: in:
» back to Search Results

Course rating of 4 Vendor rating of 4


The Objective of this 2-day course is to efficiently use workbooks as well as their tools for management and data analysis. Using graphs and databases. Using different Excel functions and their database analysis features.

  • Course Start Date: Sep. 29
  • 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
The Objective of this 2-day course is to efficiently use workbooks as well as their tools for management and data analysis. Using graphs and databases. Using different Excel functions and their database analysis features.

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;
     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.
Prerequisites & Certificates
Pre-Requisites

Microsoft Excel 2007 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
 
The seminar is scheduled over two days with hour long lunches (that go long) and two break (morning and afternoon). With all of that free time, the course still ended quite early each day. This course could definitely be condensed into a four hour morning or afternoon.
Reviewed by 2012
29-September-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 15 times.