Excel Advanced 2010

Teacher

Michael Nyoni

Categories

excel

Review

(0 review)

R850.00

02-Time-Management-Habits-Successful-People-Use_important-work_508454788_monkeybusinessimages-1024×683

Welcome To Emotional Intelligence In Engineering. To view the course outline click on Curriculum Tab.

To enrol on a course click on the “Buy This Course”. If you have already registered, it will take you to the course, if not, it will redirect you to the learner registration page were you will be required to fill in your details and create your free account.

To start with your course click on Curriculum tab and Read Instructions that follow

Course Features

Lectures 18
Quizzes 4
Students 0
Certificate Yes
Assessments Self

Read Instructions
Please read instructions below
1
- Lecture1.1
  Instructions 30 min
Session One
Macros, Workbook Properties, Conditional Formattin
4
- Lecture2.1
  Macros 30 min
- Lecture2.2
  Workbook Properties 30 min
- Lecture2.3
  Apply Conditional Formatting 30 min
- Quiz2.1
  Excel 3 Quiz 1 6 questions
Session Two
Data Validation, Auditing Group, Outlines
5
- Lecture3.1
  Data Validation 30 min
- Lecture3.2
  Trace Cells 30 min
- Lecture3.3
  Data list outline 30 min
- Lecture3.4
  Create Sparklines 30 min
- Quiz3.1
  Excel 3 Quiz 2 10 questions
Session Three
Scenarios, What-If Analysis, Analysis ToolPak,Consolidate
5
- Lecture4.1
  Create Scenarios 30 min
- Lecture4.2
  Perform a What-If Analysis 30 min
- Lecture4.3
  Perform a Statistical Analysis with the Analysis ToolPak 30 min
- Lecture4.4
  Consolidate Data 30 min
- Quiz4.1
  Excel 3 Quiz 3 9 questions
Session Four
Link Cells, Merge Workbooks, Excel Data, Import a Delimited Text File, Pivot Tables, Web Query
7
- Lecture5.1
  Link Cells in Different Workbooks 30 min
- Lecture5.2
  Merge Workbooks 30 min
- Lecture5.3
  Export Excel Data 30 min
- Lecture5.4
  Import a Delimited Text File 30 min
- Lecture5.5
  Pivot Tables 30 min
- Lecture5.6
  Create a Web Query 30 min
- Quiz5.1
  Excel 3 Quiz 4 11 questions