Microsoft Excel Training > Data Analysis and Financial Modelling with Excel 2013 / 2016

Data Analysis and Financial Modelling with Excel 2013 / 2016

Course Objectives

Manage database effectively.
Apply proper formula and function.
Troubleshooting errors
Link and Embed Data from other sources.
Applying Conditional Formatting and Validation Rules

Target Audience

Prerequisite

Good Excel Background.

Course Modules

Lesson 1: Customizing the Excel Environment
Lesson 2: Creating Advanced Formulas
Lesson 3: Analysing Data with Built In Functions and Conditional Formatting
Lesson 4: Organizing and Analysing Datasets and Tables
Lesson 5: Visualizing Data with Charts
Lesson 6 : Using Pivot Tables , Pivot Charts, Slicers and Dashboard Reporting

Get To Know The Trainer

Trainer Shabenah

4.5

Shabenah is an experienced corporate trainer, facilitator and consultant with deep knowledge in the field of IT, soft skills, leadership and communication. She has a great passion for training, learning and development, and is able to work effectively with people of all levels. Shabenah is also an active participant in local community and social activities.

VIEW PROFILE