Microsoft Excel – Excel from Beginner to Advanced 2022

سرفصل های دوره

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

1. Week 1 Excel basics for beginners

1. Day 1 INTRODUCTION to Microsoft Excel

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

3. Day 3 UNDO and REDO - learn the basics

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

5. Day 5 FIND and REPLACE

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

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

2. Week 2 - Basic formatting options in excel

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

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

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

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

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

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

7. Day 7 SORTING and FORMATTING - the basics

3. Week 3 - Inputting, viewing and managing data

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

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

3. DAY 3 EXCEL BASICS - AUTOFILL and inputting data

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

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

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

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

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

4. Week 4 - Introduction to functions and formulas

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

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

3. Day 3 FORMULAS - Understanding basic division in Excel

4. Day 4 ABSOLUTE and RELATIVE cell references

5. Day 5 ABSOLUTE CELL REFERENCE learn the shortcut!

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

7. Day 7 ERROR checking and calculating FORMULAS

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

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

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

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

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

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

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

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

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

6. Week 6 - More FUNCTIONS in Excel

1. Day 1 TRIM function - Introduction

2. Day 2 SUBTOTAL function - ExpliningExplination !

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

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

5. Day 5 TEXT function - Explanations !

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

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

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

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

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

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

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

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

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

7. Day 7 using the RANK function in Excel

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

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

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training