Overview
This course focuses on Excel features that are key to business reporting!, It is a course that identifies specific purposes that will help delegates to derive meaningful, actionable results from advanced statistical, and information formulas. Accomplish more, faster with an array of formulas, which perform calculations on a series of values simultaneously. Manipulate PivotTable data with greater precision using custom grouping and custom calculations.
Objectives
WHAT WILL YOU GAIN FROM THE COURSE?
- Delegates will learn how to create and analyse reports
- Keep your finger on the pulse of the business
- Effectively track sales against targets
- Maximise Return on Investment (ROI) by keeping track of campaigns.
- Generate Statistical information
Course content
Below is an example of the course content. The content can be ‘tailored’ to meet the exact requirements of the client.
Basic Functions
- Smart Lookup
- Sorting, Subtotaling and Filtering Data
- Data Validation
- What-If Data Analysis
- Forecasting Sheet
- Macros
Formulas and Functions
- Data Consolidation
- Conditional Formatting Worksheet Protection
- Managing and Preparing Data
- Using Cell References
- Lookup, Text and Logical Functions
- Statistical and Mathematical Functions
- Date and Time Functions
Pivot Tables and Pivot Charts
- Pivot Table Basics (new search field added to Excel 2016)
- Pivot Table Options
- Formatting a Pivot Table (new Automatic Time Grouping added to Excel 2016)
- Calculated Items and Fields
- Sort and Filter a Pivot Table (new Multi Select Slicer added to Excel 2016)
- Consolidated Pivot Table
- Pivot Charts and Sparklines
Methodology Of Training
The foundation of our training is anchored in activity-based experiential learning. This methodology takes into consideration different learning and communication styles, and more importantly language and cultural differences. It is through active participation that the adoption and application of theory is expedited.
Our training team pays careful attention to planning and designing effective instructional methods essential for the transfer of knowledge. It is the creative skill of our management trainers and consultants that reveal untapped skills of the delegates through:
- Group discussion
- Individual and syndicate activities
- Individual and group tasks
- Case studies
- Role plays
- Audio and video evaluation
- Action planning
- Experiential learning games
- Presentations
- Assessments
Overview
This course focuses on Excel features that are key to business reporting!, It is a course that identifies specific purposes that will help delegates to derive meaningful, actionable results from advanced statistical, and information formulas. Accomplish more, faster with an array of formulas, which perform calculations on a series of values simultaneously. Manipulate PivotTable data with greater precision using custom grouping and custom calculations.
Objectives
What will you gain from the course?
- Delegates will learn how to create and analyse reports
- Keep your finger on the pulse of the business
- Effectively track sales against targets
- Maximise Return on Investment (ROI) by keeping track of campaigns.
- Generate Statistical information
Course Content
Below is an example of the course content. The content can be ‘tailored’ to meet the exact requirements of the client.
Basic Functions
- Smart Lookup
- Sorting, Subtotaling and Filtering Data
- Data Validation
- What-If Data Analysis
- Forecasting Sheet
- Macros
Formulas and Functions
- Data Consolidation
- Conditional Formatting Worksheet Protection
- Managing and Preparing Data
- Using Cell References
- Lookup, Text and Logical Functions
- Statistical and Mathematical Functions
- Date and Time Functions
Pivot Tables and Pivot Charts
- Pivot Table Basics (new search field added to Excel 2016)
- Pivot Table Options
- Formatting a Pivot Table (new Automatic Time Grouping added to Excel 2016)
- Calculated Items and Fields
- Sort and Filter a Pivot Table (new Multi Select Slicer added to Excel 2016)
- Consolidated Pivot Table
- Pivot Charts and Sparklines
Methodology
The foundation of our training is anchored in activity-based experiential learning. This methodology takes into consideration different learning and communication styles, and more importantly language and cultural differences. It is through active participation that the adoption and application of theory is expedited.
Our training team pays careful attention to planning and designing effective instructional methods essential for the transfer of knowledge. It is the creative skill of our management trainers and consultants that reveal untapped skills of the delegates through:
- Practical sessions
- Individual and syndicate activities
- Individual and group tasks
- Case studies
- Role plays
- Audio and video evaluation
- Action planning
- Experiential learning games
- Presentations
- Assessments
Please complete our contact form below and a member of our team will get in touch with you.
Our specialists will explain advantages of different activities, advise you on additional services, and offer an attractive price package.
English 
Arabic 