ES WSQ - 2 days (Microsoft Excel 2013 - 17 hrs) Perform Spreadsheet Functions (ICDL Certification module 4 : Spreadsheets)

  

About this Course

This module enables candidates to understand the concept of spreadsheets and to demonstrate the ability to use a spreadsheet application. Candidates will understand and be able to accomplish tasks associated with developing, formatting, modifying and using a spreadsheet, in addition to using standard formulas and functions, and demonstrate competence in creating and formatting graphs or charts.

On completion of this module each candidate will be able to:

  1. Work with spreadsheets and save them in different file formats

  2. Choose built-in options such as the Help function within the application to enhance productivity

  3. Enter data into cells and use good practice in creating lists. Select, sort and copy, move and delete data

  4. Edit rows and columns in a worksheet. Copy, move, delete and appropriately rename worksheets

  5. Create mathematical and logical formulas using standard spreadsheet functions. Use good practice
    in formula creation and recognize error values in formulas

  6. Format numbers and text content in a spreadsheet

  7. Choose, create and format charts to communicate information meaningfully

  8. Adjust spreadsheet page settings and check and correct spreadsheet content before finally printing spreadsheets


Course Outline :

Section 1 : Introducing Excel 2013
  • Starting Excel Interface
  • Excel Screen
  • Navigating
  • Ribbon
  • Worksheet Window
  • Getting Help 
  • Set Preferences
Section 2 : Workbook Management
  • Workbook Open & Close
  • Opening Multiple Workbooks
  • Create & Save a New Workbook
  • Save in Different Formats
  • Template
  • Save & Share Files Online
Section 3 : Data Entry
  • Enter Labels, Numbers
  • Enter Formulas
  • Autosum
  • Check for Errors
  • Check Spelling
Section 4 : Worksheet Formatting
  • Multiple Worksheets, Rename
  • Copy, Move, Insert, Delete
  • Switch Workbooks
Section 5 : Data Manipulating
  • Edit, Delete, Undo, Redo
  • Ranges
  • Fill Handles
  • Flash Fill
  • Copy & Move Cells
  • Finding & Replacing Text
  • Sorting & Filtering
Section 6 : Printing and Output
  • Printing In Excel
  • Page Setup - Size, Orientation, Layout
  • Setting Margins
  • Printing Selections - Setting a Print Area
  • Setting Headers & Footers
  • Printing Titles
  • Preview Prints
Section 7 : Cell Formatting
  • Apply Formatting
  • Fonts, Font Size, Font Styles
  • Number Formatting
  • Formatting Dates & Times
  • Adding Cell Colours & Borders
  • Alignment & Rotation
  • Zoom & Freeze Panes
  • Inserting & Deleting Sheets
  • Changing Column Width & Row Height
  • Inserting & Deleting Rows & Columns
Section 8 : Formulas
  • Introduction to Excel Calculations
  • Writing Formulas 
  • Order of Operations
  • Relative & Absolute Cell Addressing
  • Troubleshoot Errors
Section 9 : Functions
  • Writing Functions
  • Autosum
  • Count Numbers
  • Average & Round
  • Maximum & Minimum
  • Logical Function - IF
Section 10 : Charts
  • Introducing Charts
  • Chart Recommendation 
  • Creating Charts
  • Moving Charts Between Worksheets
  • Chart Types
  • Copy, Move & Resize Charts 
  • Formatting Charts 
  • Setting Charts Options

Course Duration : 17 Hours

Target Audience

For beginner and professional who in need of Excel in order to produce charts and data analysis.

Pre-requistics

Need to possess the knowledge of Basic PC

Certification

Successful trainees will receive the internationally recognized ICDL Certificate upon completion of the course. This certificate is administered by ICDL Singapore. This is a joint certification between WDA and ICDL Singapore. Student must take a 45 min online assessment at the end of the course.

Course Pathway

ICDL - Perform Advanced Spreadsheet Functions (Advanced Excel 2013)


Rate this course:

Comments

Course Rating

  • /5 from users

Course Enquiry

Course Info

Similar Courses Provided By Other Premium Providers