Udemy - Microsoft Excel Masterclass 2023

0

1

2

3

4

5

Posted on 27 Feb 12:57 | by mitsumi | 21 views

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