MS Excel Essentials for Professionals - Intermediate

Module Overview

Take your Excel skills to the next level with our comprehensive training program. This course is designed to equip you with advanced techniques for data visualization, manipulation, and collaboration using Microsoft Office Excel. Throughout the program, you'll dive deep into creating dynamic charts and tables to visually represent your data with clarity and precision. Discover time-saving formatting options and validation features that streamline your workflow and ensure data accuracy. Gain expertise in creating complex formulas that leverage built-in functions for advanced data analysis.

Learning Objectives

• Utilize Excel Tables effectively for dynamic reporting purposes

• Efficiently manipulate and visualize data to gain insights

• Apply intermediate-level formulas and functions for dynamic data analysis

• Create professional-quality charts for data presentation

• Utilize Pivot Tables and Pivot Charts to construct basic Excel Dashboards

• Perform WHAT-IF analysis for basic planning and budgeting scenarios

• Implement simple macros for task automation to streamline workflow

• Generate reports with minimal future maintenance requirements, ensuring long term usability

Who Should Attend

Participants should have basics Excel introduction or equivalent skills. Participants must be able to:

• Create, open, save, format, and print a worksheet

• Use formulas and the SUM function

• Copy, move and delete values and formulas

Course Outline

Module 1: Formula Basics

Module 2: Reference

Module 3: Text Formulas

Module 4: Date & Time

Module 5: Logical Function

Module 6: Conditional Formatting

Module 7: Working with Functions

Module 8: Analyzing Data

Module 9: VLOOKUP & HLOOKUP FUNDAMENTALS

Module 10: Advanced LOOKUP Techniques

Module 11: Working with Charts

Module 12: Using Table Features

Module 13: Formatting and Data Validation

Download the course outline here

Click here to register