Microsoft Advance Excel

What's Included

30 Lectures
Access on tablet and phone
Certificate of completion

What you'll learn

Understand the advanced features and functions of Microsoft Excel
● Learn how to create and manage complex spreadsheets
● Learn how to work with data tables and PivotTables
● Learn how to automate repetitive tasks using macros
● Understand best practices for data analysis and visualization in Excel

Course Curriculum

Expand all Collapse all

30 Lectures

00:00

Introduction to Advanced Excel

Overview of Advanced Excel Features

Importance of Advanced Excel in Data Analysis

Setting up Advanced Excel Environment

Organizing and Manipulating Data

Data Visualization and Summarization

Loading Data from Various Sources using Power Query

Analyzing Complex Data

Dashboard and Automation

Requirements

Description

The Advanced Excel course is designed to provide participants with in-depth knowledge of the advanced features and functions of Microsoft Excel. Participants will learn how to create and manage complex spreadsheets, work with data tables and PivotTables, and automate repetitive tasks using macros.
The course is designed to help participants build on their existing knowledge of Microsoft Excel and take their skills to the next level. It covers a wide range of advanced features and functions of Excel that are commonly used in professional settings.

Instructors

(4.86)

6 Courses

12247 Students

315 Reviews

OpenLabs Ghana

I.T Consultancy

OpenLabs (previously NIIT Ghana) is the most well-known name in West African IT education. We are best recognized for our training, consulting, and content production capabilities. OpenLabs offers a diverse selection of education programs that appeal to people from all walks of life, from businesses with growing training needs to individuals seeking IT and related skills.