Microsoft Excel Basic (201-UK)
-
Correction Exercise 1
- Introduction (22:14)
- Launching and Using Excel
- Data Entry and Decimal Symbols
- Opening a Workbook
- Simple Calculations (39:01)
- Simple Calculations
- Formatting Cells
- Exercise 1: Simple Operations 1
- Correction Exercise 1
- Number Format
- Exercise 2: Simple Operations 2
- Correction Exercise 2
- The Fill Handle
- Exercise 3: Simple Operations 3
- Correction Exercise 3
- Simple Functions (44:01)
- SUM and AVERAGE Functions
- MIN and MAX Functions
- Exercise 4: Simple Functions 1
- Correction Exercise 4
- Exercise 5: Simple Functions 2
- Correction Exercise 5
- Exercise 6: Simple Functions 3
- Correction Exercise 6
- Percentage, Carryover, and Rounding to 5 cents
- Exercise 7: Payroll (Percentages and Carryovers)
- Correction Exercise 7
- Absolute Reference (22:24)
- The Absolute Reference
- Exercise 8: Absolute Reference 1
- Correction Exercise 8
- Exercise 9: Absolute Reference 2
- Correction Exercise 9
- Exercise 10: Absolute Reference 3
- Correction Exercise 10
- Dates (17:06)
- Dates
- Exercise 11: Working with Dates 1
- Correction Exercise 11
- Exercise 12: Working with Dates 2
- Correction Exercise 12
- IF Function (20:42)
- The Logical IF Function
- Exercise 13: IF Function 1
- Correction Exercise 13
- Exercise 14: IF Function 2
- Correction Exercise 14
- Exercise 15: IF Function 3
- Correction Exercise 15
- Exercise 16: IF Function 4
- Correction Exercise 16
- Exercise 17: IF Function 5, Dates and Absolute Ref...
- Correction Exercise 17
- Graphs (40:16)
- Creating a Graph
- Editing a Graph
- Exercise 18: Graph 1 Pie
- Correction Exercise 18
- Exercise 19: Graph 2 Histogram
- Correction Exercise 19
- Exercise 20: Graph 3 Line
- Correction Exercise 20
- Exercise 21: Graph 4 Histogram
- Correction Exercise 21
- Exercise 22: Graph 5 Logarithmic Scale
- Correction Exercise 22
- Exercise 23: Graph 6 3D Pie
- Correction Exercise 23
- Exercise 24: Graph 7 Line
- Correction Exercise 24
- Layout and Printing (10:30)
- Layout and Printing
- Opinion on the training
- Give your opinion on the training
- Knowledge assessment
- Excel knowledge assessment
- Info cours
