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
[ Ссылка ]
[ Ссылка ]
https:/www.subjectmoney.com
[ Ссылка ]
[ Ссылка ]
