FOCUSING ON |
- Quick Overview Of Excel Essentials
- Formatting Techniques
- Understanding Formulas
- Using Advanced Functions
- Advance Time And Date
- Protecting And Sharing Files
- Working With Charts
- Understanding Pivot Tables And Macro
|
INTRODUCTION |
One of the most importance business tools for every company. Excel is all about numbers and presentation. There’s almost no limit to what you can do with numbers in Excel, including sorting, advanced calculations, and graphing. In addition, Excel’s formatting options mean that whatever you do with your numbers, the result will always look professional! This class is designed for skilled executives who want to use excel to improve work efficiency.
- Prerequisite for advance level: familiar with basic excel functions, able to formulate simple excel formulas. Experience working with any version of excel is essential
|
WHO SHOULD ATTEND |
- Admin Staff
- HR Staff
- Customer Service Staff
- Sales & Operations Staff
- Production Staff
- Accounts Staff
- All Staff using Excel in to collect, analyse data and present results for business purposess
|
METHODOLOGY |
- Guided Learning, group-paced, hands-on classroom training with real life examples for business applications.
- Challenging exercises are set based on practical applications for typical organizational functions such as HR, Admin, Production, Sales etc.
|
AFTER ATTENDING THIS COURSE YOU WILL RETURN TO YOUR JOB… |
By the end of this course you will go beyond the basic features in Excel:
- Using multiple sheets, linking them to create formulae across sheets.
- Using common and advance functions, generate and format professional charts.
- Using advance formatting such as conditional formatting and advance data techniques such as validation and able to set up worksheet to work with others.
| |
|
DAY 1 |
9:00 |
MODULE 1: QUICK OVERVIEW OF EXCEL ESSENTIALS | |
- Excel 2016 Interface
- Excel 2016 compare to 2013 and 2010
- Understand common Excel applications
|
10:45 |
MODULE 2: FORMATTING TECHNIQUES | |
- Worksheet planning and formatting
- Planning of Multiple worksheets
- Design of a practical workbook
- Group and split tables and windows view
- Working with multiple workbooks
- Custom Auto fill
|
2:00 |
MODULE 3: UNDERSTANDING FORMULAS | |
- Understand Relative /Absolute Cell Reference in complex functions
- Using excel build-in Functions
- Understand how excel functions work
- Manipulating text and numbers
- Using Range names
|
3:45 |
MODULE 4: USING ADVANCED FUNCTIONS | |
- Using if function and multi-level if functions
- Using SumIf, sumifs, countif, countifs Functions
- Using Index, lookup and related functions
- Using other logical and information functions
- Calculating using Date Function
|
|
DAY 2 |
9:00 |
MODULE 5: ADVANCE TIME AND DATE | |
- Understand Date and time in Excel
- Using Time related function
|
10:45 |
MODULE 6: PROTECTING & SHARING FILES | |
- Sharing a file
- Accepting or rejecting changes
- Inserting comments
- Data validation
- Import data
- Conditioning format
|
2:00 |
MODULE 7: WORKING WITH CHARTS | |
- Creating a Chart
- Formatting the Chart
- Adding Labels
- Changing the Chart Type, Data Source
- Advance Charting Techniques
|
3:45 |
MODULE 8: UNDERSTANDING PIVOT TABLES AND MACRO | |
- Creating Pivot Tables
- Refreshing Pivot Table Report
- Intro to Macro
- Using Form controls
|
| |