تقييمات الطلاب
( 5 من 5 )
١ تقييمات
فيديو شرح Microsoft Excel Tutorial for Beginners The Beginner's Guide to Excel Excel Basics Tutorial ضمن كورس اكسيل | Excel شرح قناة ProgrammingKnowledge، الفديو رقم 61 مجانى معتمد اونلاين
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 Course
1- 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
#Excel #MSExcel #MicrosoftExcel #ExcelTutorial #excelTutorial #excelTutorialForBeginners #excel #excelCompleteCourse