Obtenir ce cours

ENGLISH TRAINING COURSES

Microsoft Excel Basic (201-UK)


Description
This training, lasting nearly 3.5 hours, is designed for those who want to learn or improve their skills in creating computer spreadsheets. Whether for accounting or statistics, MS Excel is the ultimate spreadsheet program.

Contenu
  • 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 échantillon
  • 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 Reference
  • 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
Règles d'achèvement
  • Vous devez terminer le test "Excel knowledge assessment"
  • Conduit à un certificat d'une durée: Toujours
Retour