- Quick Note:
- Please refer to the course provider's website for the course details.
Course Information
Schedules*
- Anytime
Registration period*
Year-round Recruitment
Price
-
Course Level
Study Mode
Duration
4 Hour(s)
Language
English
Location
-
*Note: The schedule above is for reference only. Please refer to the course provider's website for the schedule.
Course Overview
This course begins with getting you familiar with the MS Excel interface, menu systems, and Ribbon and how to enter and organize, format data, how to create formulas using simple functions and learn how to use absolute and relative referencing with your functions in Excel.
What You’ll Learn
Then it progresses to more advanced features like building charts, conditional formatting, SmartArt, PivotTables and PivotCharts, working with multiple worksheets, using advanced functions like IF, VLookup, PMT. You will also learn to automate tasks using Macros and use data analysis tools like Goal Seek and the Scenario Manager.
