Top Categories
Microsoft Excel Tutorial for Beginners | Excel Training | FREE Online Excel course (2021)
- Category:
- Sub Category:
Welcome to the The Beginner's Guide course to Excel. This Excel Full Course enables you to Learn MS Excel in simple and easy steps. In this Microsoft Excel Basics Tutorial series we will start from the basics and gradually move towards the Expert level in Microsoft Excel. This MS Excel course
Welcome to the The Beginner's Guide course to Excel. This Excel Full Course enables you to Learn MS Excel in simple and easy steps. In this Microsoft Excel Basics Tutorial series we will start from the basics and gradually move towards the Expert level in Microsoft Excel. This MS Excel course provides the Beginners to Intermediate Excel Skills, Tips, and Tricks. In this course we will learn how to Enter and edit Excel data, Format numbers, fonts and alignment, Make simple pivot tables and charts, Create simple Excel formulas, How to Use Excel Functions IF and VLOOKUP. Learn common Excel functions used in any Office, How to Create dynamic reports, Build Excel formulas to analyze date, text fields, values and arrays and much more advanced stuff. Microsoft Excel Course1- 00:02:38 - Introduction to MS Excel 2- 00:13:48 - Organizing Data 3- 00:25:10 - Basic Excel Formulas | Important Formulas for Beginners 4- 00:35:47 - How to use the Excel IF function 5- 00:46:54 - Pivot Tables in Excel | How to Create a Pivot Table in Excel 6- 00:57:04 - Text Functions in Excel | Excel TEXT Function - Formula and Examples 7- 01:07:29 - Cell Reference in Excel with Examples 8- 01:18:29 - Text to Columns in Excel | How to Use Text-to-Columns in Excel 9- 01:28:04 - How to Use Paste Special + How to Use Speak Cells Feature in Excel 10- 01:39:10 - Custom List in Excel + Using Advanced Fill in Excel 11- 01:49:30 - Flash Fill in Excel + Series features 12- 01:59:48 - Nested IF, AND, IF ERROR Function ( Logical Functions in Excel) 13- 02:11:51 - Comments and Custom Views 14- 02:22:03 - How to Make Charts and Graphs in Excel 15- 02:32:59 - Excel DATE function with examples + Mathematical Functions 16- 02:44:33 - How to Rotate Text in Cells in Excel + How to Print in Excel 17- 02:55:04 - How to use Header and Footer in MS Excel 18- 03:05:24 - Data validation in Excel 19- 03:15:49 - How to Record a Macro in Excel 20- 03:27:12 - Relative References in Excel 21- 03:38:13 - How to Make a Macro in Excel | Write Macros in Excel 22- 03:49:51 - Name Array in MS Excel 23- 04:00:21 - How To Use VLOOKUP in Excel 24- 04:10:12 - Approximate Match and VLOOKUP rules 25- 04:21:21 - Consolidate Data in Excel | Excel Consolidate Function 26- 04:32:04 - Count Functions in MS Excel 27- 04:43:00 - Single Criteria Statistical functions 28- 04:53:42 - Multiple Criteria Statistical Functions in Excel 29- 05:04:26 - How to use Index, Match, Lookup and HLookup in Excel 30- 05:16:22 - Protection Rules in MS Excel | Protecting a Worksheet's Format Excel 31- 05:26:55 - Create Hyperlinks in Excel | Links in MS Excel 32- 05:37:41 - Data Sorting In MS Excel | How to Sort Lists in Excel 33- 05:48:07 - Filtering Data | How to Filter in Excel 34- 05:58:48 - Advanced Filters in MS Excel 35- 06:09:14 - Chart Shortcuts in MS Excel | Create Excel Chart With Shortcut Keys 36- 06:19:37 - Combo Charts and Pie Charts in MS Excel 37- 06:31:07 - Spark Line Charts in MS Excel 38- 06:41:26 - Pivot Chart in MS Excel 39- 06:52:25 - Conditional Formatting in Excel : Part 1 40- 07:02:52 - Conditional Formatting in Excel : Part 2 41- 07:13:13 - Conditional Formatting for Icon Sets - How to use Icon Sets 42- 07:23:35 - Advanced Conditional Formatting Formulas in MS Excel 43- 07:32:17 - Customizing Pivot Tables Part 1 44- 07:43:40 - Customizing Pivot Tables Part 2 45- 07:53:55 - Pivot Table Item Slicers | Excel Pivot Table Slicers 46- 08:04:52 - Slicer and Timeline over Pivot Table in MS Excel 47- 08:15:03 - Dependent Dropdown Lists in MS Excel 48- 08:25:36 - Summary Report in MS Excel | How to Create an Excel Summary Report 49- 08:35:34 - Objects In Ms Excel | Excel Worksheet Objects 50- 08:45:58 - Table vs Cell Range in MS Excel 51- 08:56:10 - Slicers on Charts in MS Excel | Slicer Controlled Interactive Charts 52- 09:06:40 - How to Create a Linked Object in Microsoft Excel 53- 09:16:46 - Ctrl Shortcuts in MS Excel 54- 09:27:08 - Function Keys Shortcut In Microsoft Excel 55- 09:37:23 - Alt Key Shortcuts in MS Excel (Keyboard shortcuts in Excel) 56- 09:46:55 - Shift + Function Key shortcuts in MS Excel 57- 09:57:54 - Ctrl + Function Key Shortcuts In Ms Excel 58- 10:08:22 - Alt And Shift With Special Keys Shortcuts In Ms Excel 59- 10:19:28 - #Excel #MSExcel #MicrosoftExcel #ExcelTutorial #excelTutorial #excelTutorialForBeginners #excel #excelCompleteCourse