The Course finder will help you filter through our entire range of courses. You can browse by level, discipline or institution.

Microsoft Excel 2013 – Level 1 Essentials

Structure Duration Two days
Time 9am - 5pm
Trainer Microsoft Certified Trainer
Commencement Date 04 - 05 Jan 2018
03 - 04 Apr 2018
02 - 03 Jul 2018
09 - 10 Oct 2018

COURSE FEE (NON-MEMBER): S$321.00* (including 7% GST)
COURSE FEE (MEMBER): S$272.85* (including 7% GST)
* Members enjoy a 15% discount before GST
* Group Discount (5 or more participants) - 10%

FUNDING AVAILABLE:
COMPANY SPONSORED PARTICIPANT
1) SDF GRANT REIMBURSEMENT (Non-WSQ)
    SDF Grant Amount: S$28.00
    SDF Course Code: CRS-N-0028973

INDIVIDUAL PARTICIPANT
SkillsFuture Credit
(Individual Singaporean aged 25 and above)
Pre-approved SkillsFuture funding of S$500.00
Click HERE for more info on SkillsFuture.

  Introduction

Excel is very much more than just a spreadsheet. In the very real sense of the word, Excel is a “number-cruncher”, the likes of which have only been equalled by Lotus 1-2-3 and which it has now surpassed. From humble beginnings, Excel has developed to become the spreadsheet everyone uses, be it simple home accounting to modular solutions in major corporations.


  Key Takeaways

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

This course forms an excellent formal introduction to Microsoft Excel and the art of number crunching in a spreadsheet
- Participants will leave the course familiar with the workings of Excel and will be able to confidently produce spreadsheets and calculated totals


  Who Should Attend

This course would benefit anyone who works with numbers and are seeking to present them in a coherent, tabulated format for analysis.


  Programme Outline
  1. Excel Basics
    - Interface, Ribbon and Quick Access Toolbar
    - Using The File Tab
    - Opening and Saving Excel Files
    - Spreadsheet Layout and Navigation
    - Getting Help
  2. Data Entry
    - Selecting Cells
    - Entering, Editing and Deleting Data
    - Data Entry Shortcuts
    - Moving and Copying Data
    - Using Paste Options
      > Pasting Multiple Items

      > Pasting Raw Data, Formulas and Formatting
    - Using Auto Fill
  3. Worksheets and Workbooks
    - Workbook Organisation
      > Inserting and Deleting Sheets
      > Renaming Sheets
      > Moving Worksheets
      > Duplicating Worksheets
      > Hiding and Un-hiding Worksheets
      > Setting Worksheet Tab Color
    - Worksheet Organisation
      > Inserting Cell Comments
      > Hiding and Un-hiding Rows and Columns
      > Splitting and Freezing Panes
  4. Formatting
    - Columns and Rows
      > Inserting and Deleting
      > Modifying Column and Row Height and Width
      > Using Autofit
      > Hiding / Un-hiding Columns and Rows
    - Text Formatting
    - Alignment, Wrapping and Indentation
    - Numbers
      > Number Display
      > Currency Formats
      > Date and Time Formats
    - Borders and Shading
    - Clearing Formatting
    - Formatting and Applying Table Styles
      > Setting Table Options
      > Filtering and Sorting
    - Applying Cell Styles
    - Using the Format Painter
    - Working with Themes
    - Using Conditional Formatting
      > Specifying Rules
      > Applying Format Changes
  5. Formulas and Functions
    - Formulas in Excel
      > Creating and Editing Simple Formulas
      > Mathematical Operator Precedence
      > Absolute and Relative Cell Referencing
    - Functions
      > Using Common Function
      > Using Auto Sum and Auto Calculate
      > Function Types
      > Function Syntax
      > Understanding and Using the Basic if Function
  6. Charts
    - Introduction to Charts in Excel
    - Building Basic Charts
    - Chart Editing and Formatting
    - Setting Data Source and Plot Direction
    - Changing Chart Layout and Styles
    - Manipulating Labels, Axes and Background
    - Formatting 3D Rotations
    - Working with Quick Analysis
    - Inserting Sparklines
  7. Printing
    - Print Options
    - Setting the Print Area
    - Customising Headers and Footers
    - Repeating Row and Column Headers
    - Scaling Printouts
    - Print Preview
    - Moving Page Breaks
    - Adjusting Margins and Spacing
    - Printing Charts
    - As an Independent Object
    - As Part of a Worksheet
  8. Templates
    - Using Templates
    - Creating and Modifying Templates
    - Saving an Existing Workbook as a Template
  9. Protection
    - Overview of Data Protection
    - Locking and Hiding Cells
    - Setting Spreadsheet Passwords
    - Worksheet and Workbook Protection
    - File Protection

  Methodologies

No foreknowledge of Excel is required.

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

 

Local Enquiries
etc@mdis.edu.sg
+65 6247 9111
ib@mdis.edu.sg
+65 6278 8000
International Enquiries