Designed and built with care, filled with creative elements

Basic and advanced excel skills
Week 1
Design Research
5 videos, 1 reading
Video: The Interaction Design Specialization
20 m
Video: Introducing Elizabeth Gerber
40 m
Video: Who, What, Where, When and How People Work
35 m
Video: Michael Chapman of IDEO on Interviewing
20 m
Reading: Slides
30 m
Graded: Final Quiz: Design Research
5 Questions
Video: Michael Chapman of IDEO on Interviewing
20 m
Week 2
Ideation
2 videos
Video: The Interaction Design Specialization
20 m
Video: Introducing Elizabeth Gerber
40 m
Graded: Cumulative Quiz
4 Questions
Top
Image Alt

Basic and advanced excel skills

  /  Finance and financial management  /  Basic and advanced excel skills

Basic and advanced excel skills

About this course

Course Description

Microsoft Excel is the world leading spreadsheet modeling software and

Excel training is a must attend for everyone. This course is for Excel users

who want to learn the advance features of Microsoft Excel. This is a practical

course which will help you build Excel Spreadsheet models, analyze and

report data in a professional manner. Advanced Excel knowledge is essential

for those who want to work or are currently working in strategic positions in

any corporate organization.


Who should attend?

This course is designed for users of Microsoft Excel.


Learning Objectives

This is a hands-on training; participants are expected to come with their

Laptop. At the end of this class, you should be able to do the following:

  • Navigate within Excel and range name manager.
  • Understand, create and work with formulas and functions used to perform calculations
  • Use Paste Special and Hyperlink in linking worksheets or workbooks
  • Use a range of excel cell referencing, lookup and logical functions
  • Use Excel Table formatting, filter and conditional formatting tools
  • Use data validation, freeze pane and outline tools
  • Use “What IF Analysis”-Goal seek, Data Table and Scenario manager
  • Conduct simple and advance statistical analysis in excel                                         
  • Build optimization models and use Excel Solver add-in
  • Use data consolidation tools to combine data from different sources
  • Use Macros and control forms in automating task in Excel
  • Use Excel formula auditing and Excel special print tools
  • Protect data in worksheets and shared workbooks
  • Create effective charts and graphs in Microsoft Excel
  • Create and edit PivotTables and charts