REQUIRED PREREQUISITES:
Basic knowledge of Microsoft Excel is essential with the following pre-requisites:
This program will be conducted with interactive lectures, PowerPoint presentation, discussions and practical exercise.
Module 1: Organize Summary and Details on Your Data
Topic A: Outlining and Grouping Data
• Using Automatic Outlining
• Displaying and Collapsing Levels
• Grouping Data Manually
• Creating Subtotals
Module 2: Planning, Forecasting & Projection of Your Data
Topic A: Using Data Analysis Tools
• Using a One or Two Input Data Table
• Using Goal Seek
Topic B: Exploring Scenarios
• What is a Scenario?
• Creating a Scenario
• Saving Multiple Scenarios
• Creating a Scenario Summary Report
Topic C: Using Solver
• Understanding Solver
• Generating Reports and Scenarios with Solver
• Changing Solver Values
• Managing Solver Constraints
• Using Solver as a Goal Seek Tool
Topic D: Linking, Consolidating, and Combining Data
• Linking Workbooks
• Consolidating Workbooks
• Combining Worksheets
Module 4: Present Data with Visual Report
Topic A: Create Combo Chart
• Comparing 2 Types of Values with high Variance
• Creating Combo Chart
• Editing Combo Chart
Module 5: Summarizing and Analyzing Data with PivotTable, Slicer and PivotCharts
Topic A: Create a PivotTable
• Create PivotTable Dialog Box
• PivotTable Fields Pane
• Summarize Data in a PivotTable
• Show Values as Functionality of a PivotTable
• Personalize the default PivotTable layout
Topic B: Filter Data by Using Slicer
• Insert Slicers Dialog Box
Topic C: Analyzing Data with PivotChart
• Creating PivotChart
• Editing a PivotChart
Module 6: Navigating Large Workbooks
Topic A: Customizing Workbooks
• Inserting Hyperlinks
• Editing Hyperlinks
• Formatting Hyperlinks
• Using Hyperlinks in Excel
Module 7: Automate Task with Macros
Topic A: Macros
• Recording Macros
• Saving to Macros Enabled Workbook
• Closing and Re-Opening a Macro Workbook
• Security Warning Message
• Playing a Macro
• Assigning a Keystroke to a Macro
Module 8: Prevent User Changes with Protection
Topic A: Protecting Worksheet and Workbook
• Protecting the Current Sheet
• Protecting an Entire Workbook
• File Protection
4.5
Izham has 14 years of teaching background with 4 years in the academic department of a public university followed by corporate clienteles in the later years. Since becoming a corporate trainer, Izham has been helping office workers all over cope with data and document volumes in digital form to become efficient and come out being smart office workers.
FREE QUOTATION!
COURSE INCLUDES
COURSE BENEFITS
ALL IN FROM ONLY
RM949/DAY
RRP RM2,500/DAY SAVE RM1,551
*T&C Applies
Customer Service 101
Trainer Indy
Effective Thinking and Solution Mindset (Online Training)
Trainer Dr Alvin
Time & Stress Management (Online Training)
Trainer Dr Alvin
Business English For Office (Online Training)
Trainer Fakitah
Enhancing Business Correspondence (Online Training)
Trainer Fakitah
Occupational Safety & Health (OSH) Management Workshop (Online Training)
Trainer Dominic
RRP RM1,000/day SAVE RM275
Behavioral-Based Safety for Accident Prevention Workshop (Online Training)
Trainer Dominic
RRP RM1,000/day SAVE RM275
Live chat, call or email, we’re here for you
Quorse is Asia’s #1 online training marketplace that connects learners with trainers who seek a value-added training experience on a single platform. Discover training courses from diverse categories, ranging from technical IT certifications to personal development programs.
Sign Up to Bookmark your Favourite Course
or Request for a Quotation instantly
Sign in with your social account
or
By signing up, you agree to our Terms of Use and Privacy Policy