Microsoft Excel 2016 Tutorial for Beginners Part 1 Full Intro Learn How to Use Excel 2016

From Subjectmoney 

Excel 2016 Tutorial for beginners

This is a Microsoft Excel 2016 Full Tutorial for beginners & intermediate users.In this crash course Excel video tutorial you will learn how to use Excel 2016 formulas and functions, Excel 2016 new features, Excel 2016 Charts along with many other necessary features that you must know how to use when using Excel 2016.

1:38 The Excel Ribbon

2:10 Ribbon Groups and Commands in Excel 2016

2:30 Data Entry in Microsoft Excel

3:08 How to enter data in to a cell in Excel

3:22 How to enter data into the formula bar in Excel

3:50 How to Navigate through Microsoft Excel

4:24 How to navigate and select cells in Excel with keyboard

8:01 Autofill in Excel 2016

9:15 Autocomplete in Excel 2016

10:32 How to zoom in and zoom out Excel 2016

10:50 Formulas & Functions Tutorial in Microsoft Excel 2016

11:25 Addition in Excel

13:04 Autosum Function in Excel

14:03 The Sum Function in Excel 2016

15:45 Subtraction in Microsoft Excel

16:12 Multiplication in Excel 2016

17:15 The Product Funtion/Formula in Microsoft Excel

17:44 How to Find/Search for a function in Excel using the insert function command in the Function Lirbrary

19:29 Division in Microsoft Excel

19:46 the Quotient Function in Excel

21:25 Exponential formulas in Excel

22:20 Concatenation in Excel

23:06 Logical Comparison in Excel

23:08 Equal to logical comparison in Excel

24:17 Logical Comparison Greater Than in Excel

24:36 Less Than Logical Comparison

24:58 Greater than or equal to

25:42 Not Equal to Excel 2016

26:14 Combining Formulas and Functions in Microsoft Excel 2016

29:18 Cell Reference Tutorial in Microsoft Excel

29:57 Types of cell reference in Excel

30:07 Relative Cell Reference in Excel 2016

32:04 Using Autofill for formulas and cell reference

32:25 Show formula in Excel 2016

33:15 Absolute cell reference in Excel 2016

33:10 How to lock cell reference

34:40 Mixed Cell Reference locking only the row or column

39:27 How to refer to cells in another worksheet in Excel

40:06 How to refer to another workbook in Excel

40:35 How to clear/remove/delet content in a cell

40:52 Autofill dates in Excel

41:15 How to delete a row or column in Excel

46:36 How to style and Excel worksheet

46:50 How to format numbers in Excel

47:50 increase of decrease decimals in Excel

48:54 How to format dates in Excel (short date, long date)

40:32 How to resize cells columns and rows in Excel

50:35 the Today function in Excel Today()

51:54 Formattin and styling cells in Excel

52:05 How to add color fill in Excel

52:55 How to add borders in Excel

53:44 How to copy and paste a range of cells in Excel

54:23 Cell Styles in Excel 2016

55:27 Text direction and how to angle diagnal text content and numbers in Excel

57:00 How to Merge cells in Excel

57:53 Merge across in Excel

58:18 Change height or width of cell in Excel

58:49 Font Style in Excel

1:01:37 content alignment in Excel 

1:02:20 Conditional Formatting in Excel 2016