Microsoft Excel - Excel from Beginner to Advanced 2022

Focused View

Yassine Blh

4:16:07

143 View

1. Week 1 Excel basics for beginners

1. Day 1 INTRODUCTION to Microsoft Excel.mp4

04:43

2. Day 2 the RIBBON - Exploring what it is and what is on it.mp4

09:50

3. Day 3 UNDO and REDO - learn the basics.mp4

01:54

4. Day 4 COPY and PASTE - the basics of using the clipboard in Mircosoft excel.mp4

04:43

5. Day 5 FIND and REPLACE.mp4

02:18

6. Day 6 KEYBOARD NAVIGATION - work in excel using just your keyboard.mp4

05:49

7. Day 7 KEYBOARD SHORTCUTS - some of my most used shortcuts.mp4

08:44

2. Week 2 - Basic formatting options in excel

1. Day 1 RESIZING rows and columns - viewing your data in excel.mp4

04:05

2. Day 2 FONT FORMATTING - learn the basics with our FREE tutorial.mp4

02:56

3. Day 3 NUMBER FORMATTING - learn the basics with our FREE tutorial.mp4

04:28

4. Day 4 CELL ALIGNMENT - learn the basics with our FREE excel tutorial.mp4

04:36

5. Day 5 FORMATTING from the home tab - preset options.mp4

02:10

6. Day 6 Cell FORMATTING Learn how to add borders, colours and patterns.mp4

04:16

7. Day 7 SORTING and FORMATTING - the basics.mp4

04:49

3. Week 3 - Inputting, viewing and managing data

1. DAY 1 PRINTING EXCEL - using WORKBOOK VIEWS to setup your print!.mp4

04:01

2. DAY 2 WORKSHEETS options and working with several Excel Tabs.mp4

05:26

3. DAY 3 EXCEL BASICS - AUTOFILL and inputting data.mp4

02:54

4. DAY 4 FLASH FILL - learn how to use it!.mp4

03:09

5. DAY 5 EXCEL DROP DOWN LIST - tutorial for beginners.mp4

05:12

6. DAY 6 TRANSPOSE - find out how with this free excel tutorial.mp4

03:24

7. DAY 7 IMPORT data from the web - learn how with this excel tutorial.mp4

03:06

8. DAY 8 Naming data in excel and how to use in formulas and lists (named ranges).mp4

18:37

4. Week 4 - Introduction to functions and formulas

1. Day 1 FORMULAS and OPERATORS Learn the basics of Excel formulas and functions.mp4

09:23

2. Day 2 SUM and SUMIF formulas - the basics of adding in Microsoft Excel.mp4

04:32

3. Day 3 FORMULAS - Understanding basic division in Excel.mp4

01:57

4. Day 4 ABSOLUTE and RELATIVE cell references.mp4

06:07

5. Day 5 ABSOLUTE CELL REFERENCE learn the shortcut!.mp4

03:10

6. Day 6 FUNCTIONS - SUM, AVERAGE, COUNT and COUNTA.mp4

08:10

7. Day 7 ERROR checking and calculating FORMULAS.mp4

08:07

5. Week 5 - Commonly used FUNCTIONS in Excel (IF, IFERROR, VLOOKUP, AND, OR & NOT)

1. Day 1 IF function - learn how to use it with our introduction tutorial.mp4

04:27

2. Day 2 IFERROR function - learn the basics with our excel tutorial.mp4

01:59

3. Day 3 VLOOKUP tutorial everything you need to know about VLOOKUP in Ms Excel.mp4

02:51

4. Day 3 VLOOKUP tutorial learn to VLOOKUP with approximate values.mp4

03:32

5. Day 4 AND function - learn how to use it with our beginners tutorial!.mp4

02:10

6. Day 5 OR function - learn how to use it with our beginners tutorial!.mp4

02:00

7. Day 6 NOT function - learn how to use it with our beginners tutorial.mp4

01:27

8. Day 7 What is XLOOKUP and why is it a good alternative to VLOOKUP.mp4

08:30

9. Day 7 XLOOKUP & Named Ranges use them together to read functions easily.mp4

06:47

6. Week 6 - More FUNCTIONS in Excel

1. Day 1 TRIM function - Introduction.mp4

02:04

2. Day 2 SUBTOTAL function - ExpliningExplination !.mp4

08:53

3. Day 3 ROUND, ROUNDDOWN and ROUNDUP functions - how to use them.mp4

04:15

4. Day 4 MAX and MIN functions - learn how to find largest and smallest values.mp4

02:09

5. Day 5 TEXT function - Explanations !.mp4

05:34

6. Day 6 LARGE and SMALL functions - how to find find and sort values by position.mp4

04:52

7. Day 7 TODAY and NOW functions - how to use them with conditional formatting.mp4

03:56

7. Week 7 - Managing data with functions and sorting data 9

1. Day 1 UPPER, LOWER and PROPER functions (Changing sentence case in Excel ).mp4

03:13

2. Day 2 Extracting text using LEFT, RIGHT and MID in Excel.mp4

04:03

3. Day 3 Basics of the FIND and SEARCH functions in Excel.mp4

03:41

4. Day 4 Combining the FIND and MID functions in Excel.mp4

03:35

5. Day 5 How to create a CUSTOM SORT LIST in Excel.mp4

03:45

6. Day 6 SUMIF and How to fix issue with DATA SORTING..mp4

05:07

7. Day 7 using the RANK function in Excel.mp4

03:29

8. Day 8 Advanced drop down lists with dynamic array formulas UNIQUE & FILTER.mp4

04:48

9. Day 9 Dynamic array functions - FILTER function, the basics (Advanced filter).mp4

06:24

Description

Microsoft Excel Formulas and Functions in 10 weeks Program. Microsoft Excel 2010 2013 2016, Excel 2019 and Ms Office 360

What You'll Learn?

Learn how to write powerful and dynamic Excel formulas from scratch
Learning everything about: tables, charts, formatting, formulas and functions, macros, pivot tables/charts, and much more!
Show the world you're the boss by unlocking dynamic formulas with IF, VLOOKUP, XLOOKUP, INDEX, MATCH functions, FILTER, SORT & UNIQUE functions and many more
Start Excel from the beginning and become more CONFIDENT.

Who is this for?

This Microsoft Excel courses will take you from verry beginning to advenced level in 10 weeks program.

Anyone who want to learn how to write advanced formulas from scratch.

Anyone looking to build powerful analytical thinking and business intelligence skills.

Anyone who want to make sure they have the Excel knowledge to succeed at their career.

What You Need to Know?

No experience or knowledge is needed. You'll learn everything from the beginning.

Microsoft Excel on your computer or laptop.

Microsoft Excel 2019, Excel 2016 or Microsoft 365 . Our course is compatible with almost any version of Excel.

More details

Description
Microsoft Excel is one of the most utilized software applications of all time. Plus than 750 million people around the world use Microsoft Excel.
If you're beginner at Excel and you want to become an Excel pro! ,
Well, this course 'Microsoft Excel - Excel from Beginner to Advanced 2022' is all what you need .

So what you going to learn with in this course :
in
Week1: of our Excel course covers the basics of Excel, where to find things and how to navigate around your workbook.
Week 2 of our Excel course for beginners covers theÂ some basic formatting options in Excel.
Week 3 of our Microsoft Excel course looks at the basics of how to input, view and manage your data in Excel
Week 4 of our Excel course for beginners introduces formulas and functions in Excel and tips to help you use these more effectively.
Week 5 of our Excel course for looks at some of the most commonly used functions in Excel and the basics of how to use these. Learn about IF, IFERROR, VLOOKUP, AND, OR & NOT
Week 6 of our Excel course for beginners takes a first look at charts and how to visualise your data in Excel, as well as how to insert illustrations and images into your workbook.
Week 7 - we get a look at more commonly used function in Excel.
Week 8 - Tables, conditional formatting and pivot tables
Week 9 - managing data with functions and sorting data
Week 10 we will be more focusing onÂ INDEX, MATCH and variations on IF

Which version of EXCEL is used in the course ?
This course is useful for Excel 2019, Excel 2016, and Excel for Microsoft 365. In general, all functions and formulas work with Excel 2010 and Excel 2013, with the exception of some Excel charts (Histogram, Pareto, Treemap, and Sunburst Chart). For the Power Query section, if you want to use Excel 2010 or Excel 2013, you need to install the free Excel Power Query add-in. Otherwise, the other functions and formulas shown are valid for all versions of Excel.

What do you get when youÂ buy the course :
- 30 day money-back guaranteed by Udemy, so you have nothing to lose.
- A lifetime access. Buy now. So you watch the course anywhere and anytime you want.
- A certificate after completion to add to your resume/CV.

Iâ€™ll see you inside .
Yassine Blh

Who this course is for:
This Microsoft Excel courses will take you from verry beginning to advenced level in 10 weeks program.
Anyone who want to learn how to write advanced formulas from scratch.
Anyone looking to build powerful analytical thinking and business intelligence skills.
Anyone who want to make sure they have the Excel knowledge to succeed at their career.

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Yassine Blh

Instructor's Courses

Hi, my name is Yassine Blh,I have been a digital marketer for the past 6 years now.At the beginning of my online journey, I start with a CPA and ClickBank.In the last 3 years, I start Amazon affiliate marketing and have created several successful websites. As of Mars 2020, this website was driving around 1,900,000+ visitors/month and making good money.I have created several passive income sources for myself. now my goal is to help 1,000 peoples to start their Digital Marketing Journey.

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.