PAY-BACK
8990
Microsoft Excel Intermediate
Business ► Management
English 
Certified skills you will learn
Business
Business development
Finance and Accounting
Budgeting
Personal development
Analyzing
Communication & Marketing
Collaboration
Skills legend
Levels
Skills have 3 levels to communicate the right grade of competence.
41 lectures
6,5 hours
Certificates
89.90 €
Revision and Introduction
Lecture 1RevisionFree
14:42
Lecture 2OverviewFree
14:42
Lecture 3Linking Sheets and Files
26:44
Lecture 4Linking Sheets exerciseFree
05:23
Names and Conditional Formatting
Lecture 5Named Cells and Ranges
10:45
Lecture 6Conditional formatting
14:40
Lecture 7Highlight Weekends
04:52
Lecture 8Exercise Tracker
14:49
Lecture 9Weight Loss Tracker
09:36
Lecture 10Section 2 Exercise Instructions
08:24
Analytical Functions
Lecture 11Group and Outline
10:32
Lecture 12Ratios
06:35
Lecture 13Subtotals and Countif
03:18
Lecture 14IF statements
17:12
Lecture 15Timesheet
16:50
Lecture 16Section three exercise instructions
10:12
Forms
Lecture 17Forms
04:47
Lecture 18Forms exercise instructions
00:47
Lecture 19SmartArt
08:04
Lecture 20QR Code
05:27
Lecture 21Dynamic organisation charts
09:33
Lecture 22Exercise Instructions SmartArt
00:38
Charts
Lecture 23Dynamic Graphs
08:28
Lecture 24Gantt Chart
08:52
Lecture 25Maps
05:15
Lecture 263D Maps
07:26
Lecture 27Intermediate charts
10:12
Lecture 28Pareto
07:52
Lecture 29S Curve
04:27
Lecture 30Exercise instructions for charts
08:48
lookups
Lecture 31Vlookup and Hlookup
04:05
Lecture 32Vlookup Exercise instructions
01:41
Lecture 33Invoice
16:47
Lecture 34Invoice Instructions
02:10
Pivot Tables
Lecture 35Pivot tables
19:14
Lecture 36Dashboard using Camera tool
10:44
Lecture 37Link to Access
07:21
Lecture 38Pivot exercise
06:07
Data Analysis Final exercise
Lecture 39Data Analysis
17:41
Lecture 40Data Analysis exercise
05:17
Lecture 41Final Exercise
12:38