Advanced Microsoft Excel

4.9 /5

(14 Ratings)

Offered byMicrosoft

Advanced Microsoft Excel
at
Microsoft
Overview

A Guide to Learn Excel Charts, Spreadsheets, Formulas, Shortcuts, Macros and Tips & Tricks

Duration	1 day
Mode of learning	Online
Difficulty level	Advanced
Credential	Certificate

Advanced Microsoft Excel
at
Microsoft
Highlights

Earn a Certificate of Completion
Lab Exercises after every module

Advanced Microsoft Excel
at
Microsoft
Course details

Skills you will learn

Excel Macros

Who should do this course?

For Students who want to learn more advanced skills

What are the course deliverables?

Create pivot tables and charts.
Learn to trace precedents and dependents.
Convert text and validate and consolidate data.
Collaborate with others by protecting worksheets and workbooks.
Create, use, edit, and manage macros.
Import and export data.

More about this course

This Advanced Microsoft Excel 2019 training class is designed for students to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros

Advanced Microsoft Excel
at
Microsoft
Curriculum

Module 1: Using Pivot Tables

Creating Pivot Tables

More PivotTable Functionality

Inserting Slicers

Multi-Select Option in Slicers

PivotTable Enhancements

Working with Pivot Tables

Inserting Pivot Charts

More Pivot Table Functionality

Working with Pivot Tables

Module 2: Auditing Worksheets

Tracing Precedents

Tracing Dependents

Showing Formulas

Module 3: Data Tools

Converting Text to Columns

Linking to External Data

Controlling Calculation Options

Data Validation

Using Data Validation

Consolidating Data

Goal Seek

Using Goal Seek

Module 4: Working with Others

Protecting Worksheets and Workbooks

Password Protecting a Workbook

Password Protecting a Worksheet

Password Protecting Ranges in a Worksheet

Marking a Workbook as Final

Module 5: Recording and Using Macros

Recording Macros

Recording a Macro

Running Macros

Editing Macros

Adding Macros to the Quick Access Toolbar

Adding a Macro to the Quick Access Toolbar

Module 6: Random Useful Items

Sparklines

Inserting and Customizing Sparklines

Using Microsoft Translator

Preparing a Workbook for Internationalization and Accessibility

Importing and Exporting Files

Importing Text Files

Copying Data from Excel to Word

Copying Charts from Excel to Word

Module 7: Cloud

Using the Cloud.

Advanced Microsoft Excel
at
Microsoft
Entry Requirements

Eligibility criteria Up Arrow Icon

Prerequisites: Basic and Intermediate Excel experience.

Conditional Offer Up Arrow Icon

Not mentioned

Other courses offered by Microsoft

Create a Language Understanding solution with Azure Cognitive Services

MicrosoftCertificate

Total Fees

Free

Duration

2 hours

Difficulty level

Intermediate

Architect infrastructure operations in Azure

MicrosoftCertificate

Total Fees

Free

Duration

4 hours

Difficulty level

Intermediate

Skills

Accounting Security

Manage resources in Azure

MicrosoftCertificate

Total Fees

Free

Duration

5 hours

Difficulty level

Beginner

Skills

Saas PaaS Microsoft Azure Cloud Services

Implement goal management in Dynamics 365 Sales and Customer Service

MicrosoftCertificate

Total Fees

Free

Duration

1 hours

Difficulty level

Beginner

Skills

Sales

View Other 1171 Courses

Advanced Microsoft Excel
at
Microsoft
Students Ratings & Reviews

4.9/5

14 Ratings

4-5
13
3-4
1

Argho

Advanced Microsoft Excel

Offered by Microsoft

Learning Experience: The course content was great, in my whole learning period which was of 4-5 months I studied about excel from scratch, learned each and every functionality from the very basics, overall it was a good experience

Reviewed on 8 Oct 2022Read More

Shaikh Sohel Rashid

Advanced Microsoft Excel

Offered by Microsoft

Learning Experience: If you are one of those people who work with data a lot or you know someone who works, there are a lot of situations where you need to deal with messy data which you need to clean before you use it. The process of cleaning and transforming data takes a big chunk of your time and it can be a tedious process. For this, Microsoft has introduced the power query which is a data transformation and cleaning engine well you can load data from multiple sources, transform it, and then load it back to the worksheet.

Faculty: Faculty is well trained and know each every thing I. Excel who to use and when to Yes it was updated and very good all assignments are also challenging.structure and duration is not comfortable .

Course Support: I am already with large scale organisation but after the excel skill right now am feeling very confident

Reviewed on 11 Sep 2022Read More

DILIP KUMAR V

Advanced Microsoft Excel

Offered by Microsoft

Learning Experience: Its not easy. Pass mark is 700. Total exam mark is 1000.you should be take 70% mark. Once you completed autlmatically you got the certificate.

Faculty: No any faculty if need please contact me i will help you I have experience in excel so i m not study any material. Syllabus in microsoft website

Course Support: Nope

Reviewed on 13 Aug 2022Read More

Don P Benny

Advanced Microsoft Excel

Offered by Microsoft

Learning Experience: 2019 microsoft excel usage

Faculty: Instructors taught well Curriculum was relevant and comprehensive

Course Support: No career support provided

Reviewed on 22 May 2022Read More

Kundan lal

Advanced Microsoft Excel

Offered by Microsoft