lds1

February 20, 2023

Intermediate/Advanced Microsoft Excel for Professionals

0 Enrolled

Course Overview

Increase your level of mastery using the Microsoft Office Excel. This course focuses on helping participants develop the skills necessary to automate routine tasks, improve data analysis and decision-making, and communicate data more effectively through advanced charting and visualization techniques.

Duration: Feb. 27 – Mar. 1st 2023 (3 days)
Mode of delivery: Virtual and Classroom

What Will I Learn?

Identify advanced Excel functions and features
Create and edit complex spreadsheets
Organize data and improve on analytics using PivotTables
Perform advanced calculations and data analysis using complex formulas and functions
Better communication of complex data and information through advanced charting and graphic visualization capabilities
Use advanced Excel tools such as PivotTables and macros recording to increased efficiency and automation of repetitive tasks
Utilize Excel's data analysis and modeling capabilities
Adopt Excel for sales, financial and statistical analysis

Course Content

Working with Functions

Work with Ranges

00:00
Use Specialized Functions

00:00
Work with Date & Time Functions

00:00
Work with Text Functions

00:00

Working with Lists

Analyzing Data

Visualizing Data with Charts

Using PivotTables and Pivot Charts

Working with Multiple Worksheets and Workbooks

Using Lookup Functions and Formula Auditing

Sharing and Protecting Worksheets and Workbooks

Automating Workbook Functionality

Forecasting Data

Using the Logical Functions

Working with Mathematical and Statistical Functions

About the instructor

lds1

4.00 (36 ratings)

17 Courses

9 students

Durations: 24 hours

Lectures: 43

Students: Max 0

Level: Intermediate

Language: English

Certificate: Yes

ADD TO CART AND REGISTER

Audience

An intermediate/advanced Microsoft Excel course is typically targeted towards individuals who have a basic understanding of the software and its functions, but want to expand their skills and knowledge to become more proficient and efficient in their use of the program. This may include individuals who work in finance, accounting, sales, marketing, HR, logistics, data analysis, or other roles where Excel is frequently used.