Microsoft Excel 365 Master Class : Beginner to Advanced

Focused View

Arman Ali

11:37:52

1,117 View

1. MS-EXCEL - 365 - Introduction

1. Starting EXCEL.mp4

01:58

2. Excel Interface.mp4

06:36

3. Navigating Workbook and Worksheets.mp4

04:54

4. Back Stage View.mp4

04:01

5. Mouse Movement.mp4

03:49

6. Ribbon.mp4

06:38

7. Save and Save As.mp4

05:25

8. Entering Data.mp4

07:12

9. Page Layout and Print 1.mp4

13:14

10. Page Layout and Print 2.mp4

07:35

11. Page Layout and Print 3.mp4

05:17

2. Basic Operations

1. Order of Operations.mp4

02:03

2. Ranges and Name Ranges.mp4

04:27

3. Relative and Absolute Referencing.mp4

04:52

4. Introduction To Formulas.mp4

09:59

5. More Functions and Formulas.mp4

06:29

6. How to find Formulas.mp4

06:21

3. Sheets, Rows and Columns

1. Rows & Columns 1.mp4

08:24

2. Rows & Columns 2.mp4

08:21

3. Outline.mp4

06:35

4. Sorting.mp4

15:32

5. Subtotal.mp4

07:27

4. Basic Formatting

1. Basic Formatting.mp4

28:14

2. Basic Filtering.mp4

07:48

3. Formatting - Borders & Shading.mp4

09:28

4. Formatting - Styles.mp4

02:59

5. Formatting - Table Styles.mp4

05:25

6. Freeze Panes - How.mp4

08:08

5. Functions, Ranges and Shortcuts

1. Recap Of Formulas and Functions.mp4

02:59

2. Sum Function.mp4

05:24

3. Flash Fill.mp4

03:09

4. Rounding - The basics.mp4

08:15

5. Rounding - Further explanation.mp4

06:03

6. Large & Small - Basics.mp4

03:58

7. Mode & Median.mp4

04:47

8. Sumproduct formula.mp4

06:12

6. Advance operations

1. Advanced Filtering.mp4

05:55

2. Paste Special.mp4

12:17

3. Formatting in Depth.mp4

11:12

7. Data Management

1. Errors - Introduction to types.mp4

04:22

2. Errors - IFError & ISError.mp4

03:08

3. Duplicates - What is the Issue.mp4

03:02

4. Duplicates - How to Resolve.mp4

09:25

5. Formula Auditing & Watch Window - How.mp4

07:13

6. Data validation - The Basics.mp4

07:21

7. Data validation - Custom - AND - Exact.mp4

12:03

8. Logical Functions

1. IF Function.mp4

02:56

2. Nested IF.mp4

03:45

3. Nested IF & IFS and IF ELSE.mp4

14:37

4. IF ELSE - Example - Inventory Reorder.mp4

03:21

5. IFS - Student Grading 1.mp4

02:35

6. IFS - Student Grading 2.mp4

06:44

7. IFS - Student Grading 3 +Formatting.mp4

03:32

8. Count - CountA -CountBlank - Countif(s) - FormulaText.mp4

13:09

9. Serial Numbers, Running Totals & Random Numbers.mp4

07:25

10. Average IFS.mp4

01:47

11. MAX & MIN IFS.mp4

06:00

12. Large AND Small - With IF Function.mp4

05:11

13. SumIF.mp4

04:09

14. SumIFS.mp4

01:44

15. SumIFS + Name Range.mp4

02:37

16. Applying Logic - And Or.mp4

04:54

17. Applying Logic - Various Usage of IS.mp4

06:50

18. More True - False & Exact Function.mp4

03:16

9. Text Functions

1. Len - Lower -Upper - Proper - Trim - True - False.mp4

05:50

2. Text Split -1 - How and the Advantages.mp4

04:23

3. Text Split -2 - Sorting & Text Joint.mp4

03:05

4. Text Split 3.mp4

01:24

5. Text Split 4 - Ignore Empty.mp4

02:11

6. TOCOL & TOROW.mp4

02:41

7. Text Before & Text After.mp4

02:31

8. Concatenate - Concat - Justify.mp4

02:31

9. Left - Right - Len - Concatenate.mp4

08:23

10. Left - Right - Len - Find - Adding without Concatenate.mp4

06:44

11. Mid - Extracting data from within data.mp4

02:27

12. Find & Search - A comparison.mp4

03:14

13. Text to Columns.mp4

05:01

14. Replace & Substitute.mp4

07:48

10. Charts

1. Charts - Introduction.mp4

07:16

2. Chart Types - Bar Chart.mp4

03:12

3. Chart Types - Various.mp4

03:45

4. Charts - Customization.mp4

05:07

5. Charts - Pie Charts.mp4

04:05

11. Date and Time In depth

1. Date & Time Functions.mp4

19:31

2. Date & Time Functions Continued.mp4

05:55

12. Lookup - Basic to Advanced

1. Vlookup - How to find Values.mp4

09:30

2. HLOOKUP - Horizontal Value Lookup.mp4

08:03

3. XLOOKUP - Reducing limitations Of Vlookup & Hlookup.mp4

10:38

4. Index Match - A Perfect Match.mp4

09:07

5. XMATCH.mp4

02:32

6. OFFSET.mp4

08:31

7. 2 Way Dynamic Lookup.mp4

12:43

13. Pivot Tables - In depth

1. Pivot Table - An Introduction.mp4

03:12

2. Pivot Table - Basic Operations.mp4

09:38

3. Pivot Table - Value Field Settings & Designs.mp4

04:47

4. Pivot Table - Calculated Fields.mp4

02:43

5. Pivot Table - Groupings.mp4

03:09

6. Pivot Table - Slicers.mp4

09:54

14. Data Analysis

1. What If Analysis.mp4

08:49

15. Financial Functions

1. Payment Calculation - Using Function.mp4

10:18

2. FV Calculation - What is it.mp4

03:56

3. Using FV to Calculate Retirement Fund.mp4

05:59

4. Schedule of Payments Using PPMT & IPMT.mp4

08:38

5. Loan Amortization Schedule.mp4

10:11

6. NPV - Net Present Value - Introduction.mp4

03:26

7. NPV - Using Functions.mp4

03:26

8. IRR - Internal Rate of Return.mp4

01:41

9. XNPV - Dealing With Infrequent Intervals.mp4

02:59

16. Basic Macros

1. Introduction to Macro.mp4

03:06

2. Creating a Simple Macro.mp4

02:34

17. Dashboards

1. Introduction to Dashboards.mp4

10:50

Description

MS-Excel A-Z Microsoft Course. Microsoft Excel 2013, 2016, Excel 2019 and Microsoft/Office 365/2024

What You'll Learn?

Learn Excel 365 from complete Beginner level to Advanced level
Learn how to use basic excel functions to using it for charts
Allowing you to complete office presentation and save time
Setting the base for the latest in MS-Excel

Who is this for?

Anyone who wants to work in Office environment and needs MS-EXCEL

What You Need to Know?

No Experience needed. You will learn from absolute basic level

More details

Description
Microsoft Excel 365 Full Basic to Advanced level Package
Master Microsoft Excel 365 from Beginner to Advanced Level
Build a solid understanding on the Basics of Microsoft Excel
Learn the most common Excel functions used in the Office
Learn Microsoft Excel automation to increase efficiency in your day to day tasks
learn tips and tricks how to maintain large sets of Excel data in a list or table
Create dynamic reports by mastering one of the most popular tools, PivotTables
Take control by unlocking dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions.
Set up base for career advancement with MS-EXCEL 365
This course is broken down into 17 Sections:
Each Section takes you step by step through Excel so that even if you are beginning or are intermediate level user, your foundation is built up thoroughly, so that you can understand complex functions and get creative with complexity as offered by this course.
I have added practical uses in lectures, which are driven by real life scenarios and things used in corporate level whether you are in Finance, HR, Marketing and Sales, or Admin.
Enroll and take a deep dive of the most popular worldwide spreadsheet tool, Microsoft Excel. As a Microsoft Corporate Expert I will use my 10+ years of Excel use to guide you step by step through the beginner to advanced level and beyond.
You will start at the very basics, building a solid foundation that will give you further knowledge as you progress into intermediate and advanced level topics.
At completion of this course you will have mastered the most popular Excel tools and have the confidence to complete any Excel tasks with efficiency and grace. See below a glimpse into what you will be learning:
Creating effective spreadsheets
Managing large sets of data
Mastering the use of some of Excel's most popular and highly sought after functions (SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH amongst others)
Create dynamic report with Excel PivotTables
learn to Audit &Â Analyze Excel Worksheet formulas to ensure how to bring quality in worksheet
What's Included?
10+ Hours of Step by Step Video Lectures.
Downloadable Exercise Files to follow along and practice with
Additional Exercise Files are provided at the end of each major section that can be download and practice the skills you've learned
So, what are you waiting for, enroll now and take the next step in mastering Excel and go from Excel Novice to Excel Corporate Elite
Who this course is for:
This Microsoft Excel courses will take you through 17 levels of Microsoft Excel topics (Beginner, Intermediate, Advanced).
If your looking to take your Excel skills from beginner to advanced level and beyond, then this course is for you.
Who this course is for:
Anyone who wants to work in Office environment and needs MS-EXCEL

User Reviews

Rating

average 0

Total votes0

Focused display

Excel Formulas and Functions

Arman Ali

Instructor's Courses

My name is Arman Ali, I am a ACMA (UK) – CPA (US) – CFC (CA) – CFRMC (US) – CFM (UK) qualified Accounts and Finance professional, with a passion for teaching. I began my professional journey in over 10 years ago and went to work in multi-billion Multi-National Corporations in UAE. I have also worked in Audit and accounts firms in UAE and in North-America as well. I have worked in various industries, construction, waste management, finance and Oil and gas and most recently, renewable energy. I learned to leverage my skills in MS-EXCEL to my advantage to reduce my work load and increase efficiency. No matter the ERP available the use of MS-EXCEL will not diminish any time soon.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.