Intermediate (Intensive) Excel Workshop

Loading Events

« All Events

  • This event has passed.

Intermediate (Intensive) Excel Workshop

21/Apr/2016 @ 9:00 am - 5:00 pm

RM450

Overview

In today's fast-paced, technical business environment world, numbers meant everything. So it is of utmost importance that we the users, are able to manage and consume the data - statistics, planning, reporting efficiently.  We learn how we are doing and discover our next course of action by studying and interpreting numbers. That explains why we need to master the incredibly powerful tool – Microsoft Excel.

A solid understanding on Microsoft Excel prepare you in finding improvement via creative ways. With right skills and knowledge, the time can be shorten and tasks are simplified. Tasks can be automated to lessen manual workload and minimize human errors.

With this objective in mind, the course is designed to equip your with both know-how and find-how knowledge. Know-how is to equip you with firm foundation knowledge in Microsoft Excel. And, find-how is to instil you with right skills to discover new solutions to new challenges after the training. The topics are delivered with simple examples, and you are encouraged to explore and experiment alternate solutions in Microsoft Excel.

Prerequisite

The participants are expected to have basic skills in Microsoft Excel, such as manage multiple windows, move around data, enter data, using basic functions and formulas, handling file operations, basic cells formatting, working with multiple worksheets, printing, and set Excel options.

Duration

1 Day (usual: 2 days)

Outline

  • Strategies to Search for Relevant Functions
  • Using Nested Functions (i.e. combination of multiple functions)
  • Text Functions
  • Date Calculation
  • Relative vs. Absolute References
  • Function Library
  • Insert Function
  • Function Box
  • Function Argument Tool Tips
  • Cell References
  • Fill Handle
  • Common Functions
  • Protection Tab
  • Unlock Cells
  • Worksheet Protection
  • Unprotect Sheets
  • View Worksheets Side By Side
  • Hide Windows
  • Watch Window
  • Consolidate Data within Same Workbook
  • Consolidate Data from Multiple Workbooks
  • Strategies to Search for Relevant Functions
  • Using Nested Functions (i.e. combination of multiple functions)
  • Text Functions
  • Date Calculation
  • Relative vs. Absolute References
  • Function Library
  • Insert Function
  • Function Box
  • Function Argument Tool Tips
  • Common Functions
  • Protection Tab
  • Unlock Cells
  • Worksheet Protection
  • Unprotect Sheets
  • Consolidate Data within Same Workbook
  • Consolidate Data from Multiple Workbooks
  • Using IF, AND, OR, NOT
  • COUNTIF vs. COUNTIFS
  • SUMIF vs. SUMIFS
  • Using VLOOKUP
  • Reversed Lookup (MATCH & INDEX)
  • Sorting Database List
  • Filtering Database List (Auto Filter)
  • Transposing Data from Rows to Columns
  • Using the Text to Columns Feature
  • Checking for Duplicates
  • Showing & Copying Subtotal Data
  • Grouping & Outlining Data
  • Viewing Grouped and Outlined Data
  • Using Advanced Filters
  • Using Slicers (Excel 2010 onward)
  • Inserting a PivotTable
  • Choosing Fields and Grouping Data
  • Changing the Data Displayed and Refreshing the PivotTable
  • Creating a PivotChart from a PivotTable
  • Using Slicers (Excel 2013 onward)
  • Delete PivotTable
  • Highlight Top 10 Numbers
  • Using Data Bar
  • Using Icons Instead of Numbers
  • Adding a Conditional Format
  • Changing a Conditional Format
  • Creating a Custom Format
  • Using Own Formula
  • Delete a Conditional Format
  • Creating Chart
  • Modifying a Chart
  • Moving Charts to a Chart Sheet
  • Combo Chart (e.g.: line chart inside a bar chart)
  • Adding and Deleting Sparklines (Excel 2010 onward)

Details

Date:
21/Apr/2016
Time:
9:00 am - 5:00 pm
Cost:
RM450

Venue

Above Ace® Resources
C-6-3, Block C, Viva Home Jalan Loke Yew,
Kuala Lumpur, Kuala Lumpur 56100 Malaysia
+ Google Map

Organizer

WhyExcel PLT
Email:
ask@WhyExcel.com
Website:
www.WhyExcel.com
Skip to toolbar