DURATION
2 days
Methodology
Hands on
Discussion
Challenges
Who Should Attend
Senior Executive
Managers
Staff that need to help preparing data
Course Materials
Will be provided
Pre-requisite
Must Possessed intermediate Excel Skills
EXPECTED OUTCOME:
At the end of the course, attendees should be able to:
Create all the 7 data models and charts
Creatively integrate various Excel functions to achieve its desire results
Understand how to use the Excel smartly
Increase his efficiency in leveraging on technology
Leverage on special features in Excel enhance your analysis
Would You Want to Know
how to create a moveable chart?
how to leverage on Excel to increase your efficiency?
how to extract data from other worksheet using combo box?
how to build in formula in a cell without having #DIV/0!?
how to create variances with arrows that changes in colour?
how to create Gantt Chart?
how to record simple Makro with button?
Results:
How many YES do you have?
>5 : This is for YOU!
3 - 5 : Come & discover more
<3 : Congratulations! Joint us to reinforce your learning
Excel Functions
Autofill
4 types of Anchoring
Connecting Cells
Text Wrap
Vlookup
Spinner
TEXT Function
Linking Cells
How to Create Chart
Trend Line
Insert Picture
Dual Y Axis
Creating Button
Connecting Cells
Vlookup
Multiple IF Function
Indirect Function
WingDing
Merge & Centre
Insert Column Icon
Anchoring
Autosum
Conditional Formatting
Create Chart
Combine Line & Bar
Macro Recording
Advance Autofill
Creating Trend Line
AVERAGE Function
and other useful short cut keys
Special Features
Manual with ‘Fill-in-the-Blank’ & in Outline Form
The manual is prepared in a user friendly manner where the Fill-in-the-blank allows user to focus and the Outline form made it easy to refer
Practical Tips & Tricks
Practical tips will be provided on how to leverage on available technologies to create output needed without incurring too much time
Course Content
Model 1: Quick Sales Report Preparation
Preparing 3 years Sales Report within shortest possible
time. Participants will learn how to customise the toolbars
and learn what are the common and powerful short cut
keys that will help to increase participant’s productivity.
Through this learning, participants will increase their
effectiveness at least by 30%
Model 2: Moveable Chart with Spinner
When user click on the spinner, the chart will
move up or down. Data in the chart, trend line
and the date on the legend will all be updated simultaneously. Also, participants will learn
how to skip blank on dates where there is no
Data
Model 3: One Click Data Extraction & Chart Plotting
User can change the data extracted by clicking on the pull down menu. Data is built on separate worksheets and it is linked to this summary of data where when user click on the pull down menu, it will extract the selected data into the summary table and at the same time updating the chart with the trend line
Model 4: Easy Monthly, Year-to-Date Update
Building a table requiring the user to key in only
the current month data and excel will transfer
the data into the Year-To-Date table and
automatically calculate the variance and the
arrow that represents the variance. The arrow
will also change colour depending whether it is a negative or positive variance
Model 5: KPI Scorecard
Building a chart with 2 Y-Axis. Combining both the line chart and bar chart. Also, the bar chart is represented with pictures. Participants will also understand how to prepare a effective scorecard to track company’s performance
Model 6: Building Gantt Chart
Building a Gantt Chart using Excel. This allows simple Project Management and planning to be captured in Excel
Model 7: Simple Makro Recording
Learn to create button and record simple makro to allow automatic update from the current to the year-to-date column at the same time creating a tracking number
Programme scope, delivery arrangements and suitability are confirmed during enquiry.