Microsoft Excel 365 Masterclass

Name: Microsoft Excel 365 Masterclass
Rating: 4.5 (16 reviews)

It includes Microsoft Excel, Formula, Functions, Pivot Table, Data Analysis and Visualization, Charts, Table and Map

Created byNhoeb Khan

Last updated 3/2024

English

What you'll learn

Learn Microsoft Excel from Beginner to Expert
Learn how to Analyze Data for all type works in profit or nonprofit
Learn Data Visualization on Excel Charts to drive effectively decision making
Learn how to utilize Pivot Tables and Charts in data analysis skill
Learn Formulas & Functions for project calculations for all career sectors
Understand Formatting and Conditional Format to highlight information
Understand the Mathematical Functions to use in engineer careers
Understand the Logical Functions for using in business careers
Understand the Lookup Functions to quickly find correlate data
Collaborate on Excel workbooks at the same time with co-authoring

Course content

7 sections • 46 lectures • 2h 43m total length

Introduction1:19

Available number formats5:36
Use conditional formatting to highlight information5:55
Align or rotate text in a cell1:52
Change the format of a cell1:55
Learn to change font styles and cell styles in Microsoft Excel by selecting cells, using the Home menu, and applying text effects to highlight data.
Copy cell formatting with the Format Painter1:48
Add a watermark in Excel3:20
Display or hide zero values2:35
Create or delete a custom number format2:39
Create and apply custom number formats in excel to display numbers as currency, decimals, or text. Use the custom formats dialog to set US dollars for unit prices.

Basic Formulas7:41
Explore the basics of formulas and functions in Microsoft Excel, including addition, subtraction, multiplication, division, and power, with guided practice using cell references to convert human steps into computer calculations.
SUM function1:45
SUMIF and SUMIFS8:42
COUNTIF and COUNTIFS function8:09
Learn to count values with countif and countifs by selecting a range and applying single or multiple criteria, using apples, lemons, and bananas as examples.
IF statement5:59
VLOOKUP3:19
Date and Time6:38
Combine text from two or more cells into one cell2:59
Extract Text from Cell (Left and Right)2:55
Count number of Characters (Len)1:18
Function (Left, Right and Len)3:12
Min and Max3:41
Descriptive Analysis ( Statistic Formula)7:37

Create a chart from start to finish4:20
Learn to create a chart from start to finish in Excel by selecting data, using recommended charts, switching rows and columns, and adding data labels for clear visuals.
Add or remove titles in a chart2:00
Format elements of a chart2:08
Show or hide a chart legend or data table1:09
Add a trend or moving average line to a chart1:17
Analyze your data instantly1:17
Update the data in an existing chart1:25
Select the chart, highlight the data, and edit values to update the bars; see how changing data to 150 updates the chart and reveals updated data labels.
Use sparklines to show data trends1:40
Learn to visualize data trends with sparklines in Excel by selecting data and using Quick Analysis to insert line sparklines for quarterly sales.
Visualize Data on Map5:22

Requirements

You need to have a computer with Microsoft Excel installed

Description

Why learn this course

Microsoft Excel is a versatile spreadsheet and data analysis tool with several features. Attending this course is an excellent approach to learning Excel quickly and efficiently.

Learning this course will boost your marketability. Attending this course can teach you more sophisticated Excel techniques that will help you stand out in the job market.

What you'll improve after learning this course.

You will obtain advanced Excel training that focuses on a variety of important abilities that may be applied and appreciated in practically every job within a business. You will be able to learn:

Visualize, modify, and assess data.
Create equations that will help you to deliver additional information about critical corporate activities such as workflow, project efficiency, financial estimates and budgets, and even inventory levels and utilization.
Create an easy-to-read data collection that higher management may utilize to examine current initiatives or conditions in the firm.
Create spreadsheets that better organize data and offer a clearer view of the information entered.
Maintain, organize, and balance complex financial and inventory accounts.
Create tracking systems for different departments and operations, including various workflow processes.
Pivot Tables and charts will allow you to quickly identify trends in large datasets and inform business decisions.

Who this course is for:

This masterclass is for Engineers, Data Scientists, Data Analysts, Students or Teachers and Researchers.
Anyone who work in NGOs, Private Sectors or Government

Microsoft Excel 365 Masterclass

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 1min

Basic Formatting8 lectures • 26min

Creating Tables and Data Structure5 lectures • 13min

Using Formulas & functions for calculations13 lectures • 1hr 4min

Practice Data Visualization on Excel Chart9 lectures • 21min

Analyzing Data on Pivot Table and PivotChart10 lectures • 38min

Quiz0

Requirements

Description

Who this course is for: