Excel 2016 Tutorial
87 videos • 4,834 views • by IT Army
1
Excel Tutorial 1 - Introduction
IT Army
Download
2
Excel Tutorial 2 - Excel Commands
IT Army
Download
3
Excel Tutorial 3 - Create and Save Workbook
IT Army
Download
4
Excel Tutorial 4 - Entering Cell Data
IT Army
Download
5
Excel Tutorial 5 - Autofill
IT Army
Download
6
Excel Tutorial 6 - Flash Fill
IT Army
Download
7
Excel Tutorial 7 - Advanced Fill Options
IT Army
Download
8
Excel Tutorial 8 - Help
IT Army
Download
9
Excel Tutorial 9 - Formulas
IT Army
Download
10
Excel Tutorial 10 - Functions
IT Army
Download
11
Excel Tutorial 11 - Commonly Used Functions
IT Army
Download
12
Excel Tutorial 12 - Reuse Formulas and Functions
IT Army
Download
13
Excel Tutorial 13 - Paste Options
IT Army
Download
14
Excel Tutorial 14 - Paste Special
IT Army
Download
15
Excel Tutorial 15 - Absolute, Relative and Mixed Cell References
IT Army
Download
16
Excel Tutorial 16 - Errors #####, #VALUE!, #DIV/0!, #REF!, #NULL!, #NAME?, #NUM!, #N/A
IT Army
Download
17
Excel Tutorial 17 - Error Checking Rules
IT Army
Download
18
Excel Tutorial 18 - Insert, Delete and Adjust Cells, Columns and Rows
IT Army
Download
19
Excel Tutorial 19 - Find and Replace
IT Army
Download
20
Excel Tutorial 20 - Go To Command
IT Army
Download
21
Excel Tutorial 21 - Proofing and Research
IT Army
Download
22
Excel Tutorial 22 - Text Formatting, To-do List
IT Army
Download
23
Excel Tutorial 23 - Font Settings
IT Army
Download
24
Excel Tutorial 24 - Alignment Settings
IT Army
Download
25
Excel Tutorial 25 - Format date or number as Text
IT Army
Download
26
Excel Tutorial 26 - Number Formatting, Custom Number Formatting
IT Army
Download
27
Excel Tutorial 27 - Date and Time Formatting
IT Army
Download
28
Excel Tutorial 28 - Percentage formatting
IT Army
Download
29
Excel Tutorial 29 - Hyperlink using Autocorrect
IT Army
Download
30
Excel Tutorial 30 - Insert/Edit/Remove Hyperlink
IT Army
Download
31
Excel Tutorial 31 - Format Painter
IT Army
Download
32
Excel Tutorial 32 - Cell Styles
IT Army
Download
33
Excel Tutorial 33 - Themes
IT Army
Download
34
Excel Tutorial 34 - Conditional Formatting
IT Army
Download
35
Excel Tutorial 35 - Templates
IT Army
Download
36
Excel Tutorial 36 - Print Preview a workbook
IT Army
Download
37
Excel Tutorial 37 - Page Setup
IT Army
Download
38
Excel Tutorial 38 - Header and Footer
IT Army
Download
39
Excel Tutorial 39 - Managing Worksheets
IT Army
Download
40
Excel Tutorial 40 - Custom Views
IT Army
Download
41
Excel Tutorial 41 - Split
IT Army
Download
42
Excel Tutorial 42 - Freeze Panes
IT Army
Download
43
Excel Tutorial 43 - Windows Commands
IT Army
Download
44
Excel Tutorial 44 - Workbook Properties
IT Army
Download
45
Excel Tutorial 45 - Border Options
IT Army
Download
46
Excel Tutorial 46 - Excel Customization
IT Army
Download
47
Excel Tutorial 47 - Cell Names
IT Army
Download
48
Excel Tutorial 48 - Range Names
IT Army
Download
49
Excel Tutorial 49 - Comparison Operators
IT Army
Download
50
Excel Tutorial 50 - If Function
IT Army
Download
51
Excel Tutorial 51 - Countif Function
IT Army
Download
52
Excel Tutorial 52 - SUMIF and AVERAGEIF Functions
IT Army
Download
53
Excel Tutorial 53 - COUNTIFS, SUMIFS & AVERAGEIFS Functions
IT Army
Download
54
Excel Tutorial 54 - AND, OR and NOT Functions
IT Army
Download
55
Excel Tutorial 55 - Nested Functions
IT Army
Download
56
Excel Tutorial 56 - Student Grade Calculator
IT Army
Download
57
Excel Tutorial 57 - Date Functions
IT Army
Download
58
Excel Tutorial 58 - Text Functions
IT Army
Download
59
Excel Tutorial 59 - Math and Trigonometry Functions
IT Army
Download
60
Excel Tutorial 60 - Data Sorting
IT Army
Download
61
Excel Tutorial 61 - Autofilter
IT Army
Download
62
Excel Tutorial 62 - Advanced Filter
IT Army
Download
63
Excel Tutorial 63 - Database Functions (DCOUNT, DSUM, DAVERAGE, DGET)
IT Army
Download
64
Excel Tutorial 64 - Group/Ungroup Outline
IT Army
Download
65
Excel Tutorial 65 - SUBTOTAL Function
IT Army
Download
66
Excel Tutorial 66 - Subtotal command
IT Army
Download
67
Excel Tutorial 67 - Table
IT Army
Download
68
Excel Tutorial 68 - Advanced Conditional Formatting
IT Army
Download
69
Excel Tutorial 69 - Charts
IT Army
Download
70
Excel Tutorial 70 - PivotTable
IT Army
Download
71
Excel Tutorial 71 - PivotChart
IT Army
Download
72
Excel Tutorial 72 - Timelines and Slicers
IT Army
Download
73
Excel Tutorial 73 - Linking Cells, Worksheets and Workbooks
IT Army
Download
74
Excel Tutorial 74 - 3D References
IT Army
Download
75
Excel Tutorial 75 - Consolidate Data
IT Army
Download
76
Excel Tutorial 76 - VLOOKUP and HLOOKUP
IT Army
Download
77
Excel Tutorial 77 - Lookup Function
IT Army
Download
78
Excel Tutorial 78 - Index and Match Function
IT Army
Download
79
Excel Tutorial 79 - Trace Cells
IT Army
Download
80
Excel Tutorial 80 - Watch and Evaluate Formulas
IT Army
Download
81
Excel Tutorial 81 - Data Validation
IT Army
Download
82
Excel Tutorial 82 - Macros
IT Army
Download
83
Excel Tutorial 83 - Sparklines
IT Army
Download
84
Excel Tutorial 84 - Data Tables
IT Army
Download
85
Excel Tutorial 85 - Goal Seek
IT Army
Download
86
Excel Tutorial 86 - Scenario Manager
IT Army
Download
87
Excel Tutorial 87 - Solver
IT Army
Download