Live Instructor-Led Training
The course Data Analysis & Reporting (Excel Training) teaches you to analyze & report on data using Microsoft Excel. The course covers data layout using multiple Excel worksheets and custom & advanced functions. The training includes Excel graphs, PivotTables and the use of custom functions, sorting & filtering to analyze & report on data.
Feb 3 - 4, 2025$1,500.00Mar 3 - 4, 2025$1,500.00Apr 7 - 8, 2025$1,500.00May 5 - 6, 2025$1,500.00Jun 2 - 3, 2025$1,500.00Jul 7 - 8, 2025$1,500.00
Microsoft Excel Essential Skills Revised
Identifying and Referencing Cells
Working with Cell Contents
Formatting Cells
Working with Formulas
Business Graphics
Exercise: Setting up the Business Data
Working with Data
Characteristics of a Database Layout
Using Cell Names to Prepare the Data
Using Filters to Sort and Filter the Data
Creating Custom Filters to Find the Data you need
Using Search and Find Functions to Locate the Data you need
Using Subtotals to Summarize the Data
Removing Duplicates
Using Custom Functions to Clean the Data
Exercise: Summarizing the Data with Excel Functions
Advanced Functions: Conditional Logic
Using Conditional Formatting
Planning for Conditional Logic
Using a Single If Function to Implement Conditional Logic
Using Multiple If Functions to Implement Complex Conditional Logic
Using the AND and OR Functions to Implement Complex Criteria
Using Negation and DeMogan’s Theorem to Simplify Logic
Exercise: Implementing Complex Logic in Support of Data Cleanup
Advanced Functions: Statistics and Finance
Review of Fundamentals: Working with Excel Functions
Dealing with Special Situations: Blank Cells
Working with Statistical Functions: Count, Median and Average
Working with Statistical Functions: Variance and Standard Error
Working with Statistical Functions: Frequency and Ranking
Working with Statistical Functions: Linear Regression and Correlation
Working with Statistical Functions: Probability Distributions
Performing Variance and Standard Error Calculations
Working with Financial Functions: Payments, Interest and more
Working with Financial Functions: NPV, IRR and More
Performing Financial Analysis: Probability and Earned Value
Exercise: Creating Statistical Summary Sheets for Corporate Data
Exercise: Analyzing NPV and IRR for Project Allocation
Pivot Tables
Setting up the Data
Creating a Pivot Table
Changing Row, Column and Data Associations
Formatting the Pivot Table Headers
Formatting the Pivot Table Aggregate Values
Setting Pivot Table Options
Adding and Working with Splitters
Exercise: Using Pivot Tables to Analyze and Present Data
Excel Training: Data Analysis for Business Users
The course Data Analysis for Business Users (Excel Training) teaches you to organize, analyze, validate and present data using Microsoft Excel. Starting with data layout, the course explores basic and advanced functions. The training includes a detailed discussion of conditional, math & logic functions, PivotTables, Charts and a comprehensive introduction to Macro development.
Training course titled Excel Training: Data Analysis for Business Users that will allow you to hone your professional skills.
Feb 17 - 18, 2025$1,500.00Mar 17 - 18, 2025$1,500.00Apr 21 - 22, 2025$1,500.00May 19 - 20, 2025$1,500.00Jun 16 - 17, 2025$1,500.00Jul 21 - 22, 2025$1,500.00
Excel Training: Analysis & Reporting for Finance
The course Analysis & Reporting for Finance (Excel Training) teaches you how to use MS Excel to present, analyze and format financial data. The training includes data layout, basic math & financial functions and advanced financial analysis with MS Excel. You learn about present value and future value, WACC, IRR, cash flow calculations & interest considerations. Become a financial wizard with MS Excel.
Training course titled Excel Training: Analysis & Reporting for Finance that will allow you to hone your professional skills.
Feb 4 - 7, 2025$3,750.00Mar 4 - 7, 2025$3,750.00Apr 8 - 11, 2025$3,750.00May 6 - 9, 2025$3,750.00Jun 3 - 6, 2025$3,750.00Jul 8 - 11, 2025$3,750.00
Excel Training: Cells, Workbooks and Graphs
The course Cells, Workbooks and Graphs (Excel Training) teaches you how to work efficiently with cells, worksheets & workbooks. The training includes working with multiple worksheets, useful keyboard shortcuts & functions, absolute & relative references and custom functions. You learn to set your data so that it can be easily sorted and filtered. The course also covers how to create, edit & format graphs in MS Excel. Maximum productivity is within your grasp with Microsoft Excel.
Training course titled Excel Training: Cells, Workbooks and Graphs that will allow you to hone your professional skills.
Feb 10 - 11, 2025$1,500.00Mar 10 - 11, 2025$1,500.00Apr 14 - 15, 2025$1,500.00May 12 - 13, 2025$1,500.00Jun 9 - 10, 2025$1,500.00Jul 14 - 15, 2025$1,500.00
Excel Training: Mastering Task Automation
The course Mastering Task Automation (Excel Training) provides business participants with the skills they need to automate almost any business task. Starting with a review of essential concepts in data analysis using Microsoft Excel, the course quickly proceeds to a complete and in depth study of macros and VBA development. The course covers every aspect of VBA development including the Excel object model, looping, functions, conditional logic and database access amongst others. If you need to use Microsoft Excel to automate your business tasks, this SETC certified course will teach you the skills you need. SETC Training - Formation SETC provides advanced Microsoft Excel training in Ottawa, Montreal, Toronto, Quebec and Calgary.
Training course titled Excel Training: Mastering Task Automation that will allow you to hone your professional skills.
Feb 5 - 7, 2025$2,750.00Mar 5 - 7, 2025$2,750.00Apr 9 - 11, 2025$2,750.00May 7 - 9, 2025$2,750.00Jun 4 - 6, 2025$2,750.00Jul 9 - 11, 2025$2,750.00