Microsoft Excel 2013 - Level 3 Beyond Advanced

MDIS


Course introduction

An often overlooked area of Excel is its power to derive answers from the data entered. This takes Excel out of the realm of a mere spreadsheet and into the realm of a "modeller". The ability to build analytical solutions and conclusions.



Course Benefits


Upon completion of this workshop, participants will be able to:

  • This course aims to empower existing Excel users who wish to take their skills further and venture into the areas of data modelling, financial expositions, statistical summaries and scenario management.



Target Audience


This course would benefit anyone who needs to apply advanced analysis techniques to more complex data sets.



Course Outline


Custom Formatting

  • Creating Styles- Creating New Styles
  • Applying and Modifying Styles
  • Merging Styles
  • Complex Number Formatting
  • Number Format Codes
  • Creating Custom Number Formats
  • Displaying Leading or Trailing Zeros
  • Customise Currency, Date, Time, Scientific and Text Formats
Advanced Data Manipulation
  • Rounding Numbers
  • Rounding to Nearest Multiple
  • Rounding Dollar Values
  • Extracting Integer Values
  • Rounding to Even or Odd Integer
  • Manipulating Text
  • Matching Cell Contents
  • Joining Cells
  • Changing Case
  • Extracting Character
  • Text Length
  • Working with Dates and Times
  • Calculate Number of Days Months or Years Between Dates
  • Offsetting a Date
  • Calculate Time Difference
  • Rounding Time Values
  • Counting, Summing and Averaging Techniques
  • Conditional Counting and Multiple Criteria
  • Counting Frequent Entries
  • Conditional Summing and Multiple Criteria
  • Conditional Averaging and Multiple Criteria
Specialised Lookups
  • Two Way Lookup
  • Multiple Column Lookup
Financial Functions
  • Loan Calculations
  • Investment Calculations
  • Depreciations
Statistical and Array Functions
  • Constructing Array Formulas
  • Ranking
  • Frequency Distribution
  • Histograms
Advanced Data Analysis
  • Analysis Toolpak
  • Regression
  • Sampling
  • Working with Trend Lines
Data Modelling
  • Building Spreadsheet Models
  • Optimising Spreadsheet Using Solver
Introduction to Macros
  • Recording a Macro
  • Running Macros
  • Assigning Macros
Forms In Excel
  • Understanding Excel’s Forms and Form Controls
  • Using the Form Controls
  • Text Boxes and Labels
  • Check Boxes and Option Buttons
  • Spinner and Combo Boxes
  • Drop-Down Lists
  • Buttons
  • Form Calculations
Methodologies

A good foundation in Excel is essential for this course. Participants should be familiar with absolute versus relative cell referencing, basic and conditional functions, formulae syntax, chart creation, as well as worksheet linking. Having attended an advanced course is advantageous.

A combination of lectures, explicit teaching, practical demonstrations and peer teaching is applied to this course.

Experiential learning approach is adopted where the learners will be required to consider the experience as a learning process joined with critical reflection which further qualifies for this theory to be applied for this course because, at each segment, the learners are introduced to some form of experience after which they are asked to reflect on these experiences before sharing with each other and putting ideas into practice.

Key Information
 
Duration 2 days
Time 9 am to 5 pm
Date 21 - 22 Feb 2019
16 - 17 May 2019
05 - 06 Aug 2019
30 - 31 Oct 2019
Trainer Microsoft Certified Trainer

Course Fee
 
Member $363.80
Non-Member $428.00
  • Members enjoy a 15% discount before GST
  • Group Discount (5 or more participants) - 10%
  • All fees are inclusive of 7% GST
Funding Available

1) COMPANY SPONSORED PARTICIPANT
  • SDF GRANT REIMBURSEMENT (Non-WSQ)
  • SDF Grant Amount: S$28.00
  • SDF Course Code: CRS-N-0030702
2) INDIVIDUAL PARTICIPANT
SkillsFuture Credit
(Individual Singaporean aged 25 and above)
Pre-approved SkillsFuture funding of S$500.00



Available Course Sessions


Please click here to stay updated on upcoming sessions.



Trainer Profile


Microsoft Certified Trainer

All of our Associate Trainers offer our high level of service therefore are subject to regular peer assessments and interview prior to joining our Institute. They must all be qualified and have relevant experience to an agreed level and are subjected to continual audit and evaluation. Strict internal assessment is implemented as an integral part of our quality control mechanism.



 

Top