Microsoft Excel Masterclass 2023

Microsoft Excel for Beginners to Experts | A Comprehensive Guide to MS Excel

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

Requirements

You need to have a computer with Microsoft Excel installed

Description

Why learn this courseMicrosoft 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.

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Basic Formatting

Lecture 2 Available number formats

Lecture 3 Use conditional formatting to highlight information

Lecture 4 Align or rotate text in a cell

Lecture 5 Change the format of a cell

Lecture 6 Copy cell formatting with the Format Painter

Lecture 7 Add a watermark in Excel

Lecture 8 Display or hide zero values

Lecture 9 Create or delete a custom number format

Section 3: Creating Tables and Data Structure

Lecture 10 Create and format tables

Lecture 11 Sort data in a table

Lecture 12 Filter data in a range or table

Lecture 13 Total the data in an Excel table

Lecture 14 Use slicers to filter data

Section 4: Using Formulas & functions for calculations

Lecture 15 Basic Formulas

Lecture 16 SUM function

Lecture 17 SUMIF and SUMIFS

Lecture 18 COUNTIF and COUNTIFS function

Lecture 19 IF statement

Lecture 20 VLOOKUP

Lecture 21 Date and Time

Lecture 22 Combine text from two or more cells into one cell

Lecture 23 Min and Max

Section 5: Practice Data Visualization on Excel Chart

Lecture 24 Create a chart from start to finish

Lecture 25 Add or remove titles in a chart

Lecture 26 Format elements of a chart

Lecture 27 Show or hide a chart legend or data table

Lecture 28 Add a trend or moving average line to a chart

Lecture 29 Analyze your data instantly

Lecture 30 Update the data in an existing chart

Lecture 31 Use sparklines to show data trends

Section 6: Analyzing Data on Pivot Table and PivotChart

Lecture 32 Create a PivotTable from worksheet data

Lecture 33 Refresh PivotTables

Lecture 34 Work with PivotTable Values

Lecture 35 Work with calculating values in a PivotTable

Lecture 36 Create Calculated Fields

Lecture 37 Create a PivotChart

Lecture 38 Use slicers to filter PivotTable data

Lecture 39 Create a PivotTable timeline to filter dates

Lecture 40 Connecte PivotTables from other sources

Lecture 41 Change the source data for a PivotTable

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