Advance MS Excel for Business

Course Details

Advanced Microsoft Excel for Business is a 24-hour course that teaches participants how to use the Microsoft Excel at advanced level. This course aims to enhance participants to gain the necessary practical experience by using hands-on exercises simulating real life business analysis scenarios.

Course Content

Using Advance functions
Working with data series
Using scenario and goal seeking
Using worksheet protection
Using conditional and custom formats
Consolidating worksheets
Creating, Revising pivot tables
Sharing Workbooks
Using Data Tables
Using auditing tools
Using Macros
Recording Macros

Entry Qualification

Basic Knowledge of Excel spreadsheet management, Calculations.

Certification

Certificate will be awarded to Trainees with 80% attendance

Certification Awarding Body

Focus Education Centre

COURSES

Certificate IV

Certificate IV in Business Administration Duration: 8 months / 12 months Block
Certificate IV in Accounting and Finance Duration: 8 months / 12 months Block
Certificate IV in Office Practice Duration: 1 year

Certification

Certificate III in Draftsman with AutoCAD Duration: 5 Months
Certificate I in Computing Duration: 1 month
Certificate III in Graphic Design Duration: 5-6 months / 8 months Block
Certificate III in Information Communication Technology Duration: 5-6 months / 8 months Block
Certificate III in Human Resource Management Duration: 5-6 months / 8 months Block
Certificate III in Office Skills Duration: 5-6 months / 8 months Block
Certificate II in Retail Service Duration: 5 months / 8 months Block
National Certificate II in IT Technician Duration: 4-5 months
Certificate I in Personality Development Duration: 1 month
Certificate III in Customer Service Duration: 5-6 months / 8 months

Diploma

Diploma in Business Administration Duration: 12 months / 16 months Block
Diploma in Project Management Duration: 12 months / 16 months Block
Advanced Diploma in Managerial Skills Duration: 12 months / 16 months Block
Diploma in ICT, Systems Support Duration: 2 year
Diploma in Human Resource Development Duration: 12 months / 16 months Block
Diploma in Project Management Duration: 1 Academic year

Frontline

Work Ethics Duration: 8 Hours (1 Full Day)
QuickBooks Duration: 12 Hours (2 Weeks)
Basic Non-Linear Editing Duration: 16 Hours (3 Weeks)
Google SketchUp Duration: 20 Hours (1 Month)
Project Management Workshop – 2 Days Duration: 16 hours (2 full days)
Customer Service Skills Duration: 8 Hours (1 Full Day)
MS Project Duration: 40 Hours
Time Management: Get Organized for Peak Performance Duration: 8 Hours (1 Full Day)

Middle Managers

Train The Trainer Duration: 3 Full Days
CCNA Security Routing & Switching Duration: 60 Hours (6 Full Day)
Project Management Workshop – 2 Days Duration: 16 hours (2 full days)
The 7 Habits of Highly Effective People Duration: 2 Full Days

Senior Management

Supervisory Skills Duration: 16 Hours (2 Full Days)
Coaching: A Leadership Skill Duration: 8 Hours