Excel 365 From Beginner To Advanced

Published 4/2023
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz
Language: English | Size: 9.07 GB | Duration: 13h 15m
Data Analysis With Excel

Free Download What you’ll learn
Use tools such as Pivot Table, Flash Fill, Relationships that would automatically perform complex tasks
Understand key Logical, Text, Date, Time, Lookup, Math and Financial formulas.
Understand and use Array formulas, including new formulas such as Xlookup, Filter, Unique
Combine formulas and function for the complex tasks in Data Analysis and Business Inteligence
Requirements
No experience is needed. You will learn everything you need to know in Excel
Description
If you want a single course that starts from the very basic and covers all the functions and formulas that you need for the data analysis in Excel, this course is for you.The course is future proof as it covers new approach in Excel – Array Formulas. You will learn new functions such as Xlookup, Filter, Unique and so on.But it is not what you learn, but how. The course is designed so that you will understand what tools you need, when and why. It will teach you how to use excel to solve problems. The main focus of the course is to teach you how to analyse the data in general and Excel is just the tool to help you.Moreover, Excel helps you as much as possible to work with the data. You just need to know the tools it offers. For example, there is a function called Flash Fill that automatically fills in the values. It means you will rarely need complex formulas to work with text in Excel.Another example, instead of writing complex Lookup formulas, you can often use Relationships in Excel. We not only cover connecting tables, but dive deeply into Business Intelligence tools Excel offers. These tools are also part of the Power BI application, so you can consider this course as an introduction to Power BI.
Overview
Section 1: Introduction
Lecture 1 1.1 Introduction
Lecture 2 1.2 Format Cell
Lecture 3 1.3 Format Text in the Cell
Lecture 4 1.4 Format Number in the Cell
Lecture 5 1.5 Formula
Lecture 6 1.6 Copy Paste
Lecture 7 1.7 Exercise 1
Lecture 8 1.8 Exercise 2
Lecture 9 1.9 Exercise 3
Lecture 10 1.10 Exercise 4
Lecture 11 1.11 Exercise 5
Section 2: Table and Pivot Table
Lecture 12 2.1 Sort, Filter and Subtotal
Lecture 13 2.2 Excel Table (Ctrl + T)
Lecture 14 2.3 Custom Sort and other Filter options
Lecture 15 2.4 Introduction to Pivot Table
Lecture 16 2.5 Pivot Table: Existing Sheet
Lecture 17 2.6 Pivot Table: Refresh
Lecture 18 2.7 Pivot Table: Calculated Field
Lecture 19 2.8 Pivot Table: Average and Other Functions
Lecture 20 2.9 Pivot Table: Count
Lecture 21 2.10 Excersises
Section 3: Basic Charts, Formulas and Functions
Lecture 22 3.1 Charts: Column Chart
Lecture 23 3.2 Charts: Table and Column (Bar) Chart
Lecture 24 3.3 Charts: Line Chart
Lecture 25 3.4 Charts: Pie Chart
Lecture 26 3.5 Pie Chart and Pivot Table
Lecture 27 3.6 Basic Functions
Lecture 28 3.7 Find
Lecture 29 3.8 IF function
Lecture 30 3.9 Vlookup function
Section 4: Array Formulas
Lecture 31 4.1 Introduction to Array Formulas
Lecture 32 4.2 Basic Principles Behind Array Formulas
Lecture 33 4.3 Filter the data using Array Formulas
Lecture 34 4.4 DataTime and Array Formulas
Lecture 35 4.5 IF and Array Formulas
Lecture 36 4.6 Sumifs
Lecture 37 4.7 Isnumber
Lecture 38 4.8 Countifs
Section 5: Text, Date and Lookup Formulas
Lecture 39 5.1 Application: Quadratic Equation
Lecture 40 5.2 Custom Number Formats
Lecture 41 5.3 Application: Arythmetic Operation Results
Lecture 42 5.4 Creating Custom Formula Using Text Functions
Lecture 43 5.5 Left, Right and Middle
Lecture 44 5.6 Last Word From The Sentence
Lecture 45 5.7 Textjoin
Lecture 46 5.8 Match
Lecture 47 5.9 Xlookup
Lecture 48 5.10 Datediff
Lecture 49 5.11 Vlookup Approximate Match
Lecture 50 5.12 Workdays and Networkdays
Section 6: Financial Applications
Lecture 51 6.1 Simple and Compound Interest
Lecture 52 6.2 Payment PMT
Lecture 53 6.3 Loan Amortisation Schedule
Lecture 54 6.4 Goal Seek
Lecture 55 6.5 Data Table
Lecture 56 6.6 Solver
Lecture 57 6.7 Net Present Value NPV
Lecture 58 6.8 Forecast
Lecture 59 6.9 Conditional Formatting
Lecture 60 6.10 Loan Scenario
Lecture 61 6.11 Profit and Loss Scenario
Section 7: Data Analysis
Lecture 62 7.1 Relationships
Lecture 63 7.2 Analysing Orders
Lecture 64 7.3 Data Validation
Lecture 65 7.4 Protect and Hide
Lecture 66 7.5 Create Table with Validations
Lecture 67 7.6 Indirect formula
Lecture 68 7.7 Offset formula
Lecture 69 7.8 Combining Offset and Indirect
Lecture 70 7.9 Combining Offset and If
Section 8: Business Inteligence BI Tools in Excel
Lecture 71 8.1 Power Query and Power Pivot
Lecture 72 8.2 Coma Separated Values CSV
Lecture 73 8.3 Import From Web
Lecture 74 8.4 Import from Google Forms
Everyone who wants to study Excel or fill-in the gaps in the knowledge or update the knowledge to new Excel formulas and functions

Homepage

www.udemy.com/course/excel-365-from-beginner-to-advanced/