Excel 2013 Basic & Intermediate Training

Excel 2013 Basic & Intermediate Training Course Microsoft® Excel 2013 Basic & Intermediate
By TED Integrated
Microsoft® Excel Series:

Microsoft® Excel 2013 Basic & Intermediate

“Assists a complete Excel beginner up to speed from basic to intermediate in 2 days!”

By TED Integrated


PSMB Certified Training Provider
Request for In-house TrainingRequest for In-house Training
Register for Public Training Public program not yet available
Register for Public TrainingRegister for Public Training
Email Customer Service [email protected] Contact Customer Service +603-2386-7788
Course Title:
Microsoft® Excel 2013 Basic & Intermediate
Training Category:
Information Technology
Target Audience:
Suitable for complete beginners without prior knowledge of Excel and those who wanting more knowledge on formulas and creating simple charts
Duration:
2 Days
Public Training Events
Jan 2017 ›
Venue:
TED Integrated, Binjai 8 Premium SOHO, Kuala Lumpur, Malaysia
Schedule:
Mon 23 Jan 2017 - Tue 24 Jan 2017
9:00AM - 5:00PM

Fee Per Person:
RM900.00
Promotions:
  • 10% discount for group registration of 3 paxs or more from the same organization.
Register Now!

* Other terms & conditions apply.
May 2017 ›
Venue:
TED Integrated, Binjai 8 Premium SOHO, Kuala Lumpur, Malaysia
Schedule:
Wed 03 May 2017 - Thu 04 May 2017
9:00AM - 5:00PM

Fee Per Person:
RM900.00
Promotions:
  • 10% discount for group registration of 3 paxs or more from the same organization.
Register Now!

* Other terms & conditions apply.
Jul 2017 ›
Venue:
TED Learning Centre, Binjai 8, Kuala Lumpur, Malaysia
Schedule:
Tue 04 Jul 2017 - Fri 05 Jul 2017
9:00AM - 5:00PM

Fee Per Person:
RM900.00
Promotions:
  • 10% discount for group registration of 3 paxs or more from the same organization.
Register Now!

* Other terms & conditions apply.
Oct 2017 ›
Venue:
TED Learning Centre, Binjai 8, Kuala Lumpur, Malaysia
Schedule:
Thu 12 Oct 2017 - Fri 13 Oct 2017
9:00AM - 5:00PM

Fee Per Person:
RM900.00
Promotions:
  • 10% discount for group registration of 3 paxs or more from the same organization.
Register Now!

* Other terms & conditions apply.
For In-house Training
Request for Quotation Request for Quotation
For Other Inquiries
Contact TED Integrated
Contact customer service +603-2386-7788
Email customer service [email protected]
Delivery Methods
  • Language: English
  • PowerPoint Presentation
  • Computer Lab Work
  • Certificate of Participation
Ad by Google
*Terms & Conditions

Course Introduction ›

Basic

This course covers the very basics of the Excel spreadsheet. It is suitable for complete beginners without prior knowledge of Excel. At the end of this course you will have good understanding of the basic Excel features and you will be able to create a simple, presentable spreadsheet.

Intermediate

This course covers the intermediate level understanding of the spreadsheet. It is suitable for beginners wanting more knowledge on formulas and creating simple charts. At the end of this course you will have better understanding of the Excel features and you will be able to create formulas and charts.

Course Objectives ›

At the end of the course, participants will be able to:

  • Understand basic spreadsheet concepts
  • Create basic formulas
  • Format worksheets
  • Use multiple worksheets
  • Create bar, lines and pie charts
  • Create drawings & picture objects
  • Print worksheets and graphs

Prerequisites ›

Knowledge of Microsoft Windows.

Course Outline ›

DAY 1

Module B1: Walking Through Excel 2013

  • The New Excel 2013
  • 2013 Landing Page
  • Signing In Office 2013
  • Cloud Computing
  • Charts
  • Quick Analysis
  • Power View
  • Flash Fill

Module B2: Managing Workbooks & Navigating with Excel

  • The User Interface
    • Tabs & Ribbons
    • Customising The User Interface
  • Using Shortcuts
    • Keyboard short cuts
    • Keyboard & mouse combinations
  • Getting More Menu Options
  • Creating A New Workbook
  • Saving A Workbook
  • Opening A Workbook
  • What's Compatibility Mode?
    • Problems With Compatibility Mode
    • How to Convert a file in Compatibility Mode
  • Working With Templates
  • Handling Multiple Workbooks
  • Selecting A Range
    • With Mouse
    • With Keyboard
    • With Short Cut Keys
    • When to use the SHIFT key
    • When to use the CTRL key

Module B3: Data Entry in Excel

  • Entering and Editing Data
    • Text
    • Values
    • Formulas
  • Copying & Pasting Data
    • Short cuts
    • The Various Types of Paste
  • Filling Trends, Formulas & Text
    • Short cuts
    • Fill Tricks
    • Flash Fill

Module B4: Introduction to Functions and Formulas

  • Basic Formulas
    • Operators
    • Using cell references
  • Functions
    • AutoSum
    • Summing Tricks
    • AVERAGE / AVERAGEA
    • MAX / MIN
    • COUNT / COUNTA

Module B5: Modifying A Worksheet

  • Handling Columns & Rows
    • Changing Column Width
    • Fitting Contents to a Column
    • Adding & Removing Columns
    • Hiding Columns
    • Adding & Removing Rows
    • Hiding Rows
    • Fitting Font Size to a Row
  • Formatting Text
    • Changing the Font Properties
    • Using Cell Styles
  • Formatting Numbers
    • Changing Number Formats
    • Customising Number formats
  • Changing Alignment
    • Changing Text Alignment
    • Merging Cells
    • Controlling Text Appearance in a cell
  • Borders and Shading
  • Format Painter

Module B6: Printing Your Work

  • Printing Your Worksheet
    • Choosing What To Print
    • How To Insert / Remove Page Breaks
    • Changing Page Orientation
    • Creating Custom Headers
    • Inserting Dates & Page Numbers
  • How to Print Repeated Headings in Excel
  • How to Print The Entire Workbook
DAY 2

Module i1: Worksheets and Workbooks

  • Managing The View of Your Worksheet
    • Changing the Zoom settings
    • Freezing Rows & Columns for large worksheets
    • Splitting windows to views different parts of the worksheet
    • Customising and Saving Custom Views with hidden rows / columns together with print settings
  • Handling Multiple Windows
    • Viewing Multiple Workbooks Simultaneously
    • Viewing Multiple Sheets Within the same Workbook Simultaneously
  • Managing Worksheets
    • Hiding and Unhiding Worksheets
    • Changing Tab Colors
    • Renaming Worksheet
    • Adding / Removing Worksheets
    • Moving Worksheets
    • Copying Worksheets
    • Deleting Worksheets
  • Manipulating WorkSheets Simulataneously

Module i2: Basic Functions & Formulas

  • Understanding Cell References
    • When to use the double $ sign ($A$1)
    • When to use the single $ sign ($A1 or A$1)
  • Inserting Date and Time
    • Shortcuts
    • TODAY Function
    • NOW Function
  • Conditional Count & Sum Function
    • COUNTIF
    • SUMIF

Module i3: Analysing Data

  • Quick Analysis
    • Conditional Formatting
    • Recommended Charts
    • Automatic Totals
    • Tables
    • Recommended Pivot Tables
    • Sparklines

Module i4: Performing Visual Analysis

  • With Formatting
  • Applying Cell Formatting
  • Using Built In Pre-sets
  • Using Data Bars and Icon Sets
  • Using Custom Rules
  • Managing Rules
  • Prioritizing Rules

Module i5: Adding Illustrations

  • Customizing your Workbook
  • Adding Shapes
    • Formatting
    • Adding Effects
  • Precision Text Placement with Text Boxes
    • Adding a Text Box
    • Formatting a Text Box
    • Creating Dynamic Text Box
  • SmartArt
    • Inserting SmartArt
    • Adding Text
    • Formating With Colours & 3D Effects
  • Inserting Image Files
    • Insert a Photo
    • Performing Colour Corrections
    • Adding Effects
    • Removing Background
    • Layering Images
    • Grouping objects

Module i6: Performing Visual Analysis

  • With Charts
  • Introduction To Charting
  • Excel 2013's Recommended Chart
  • Inserting A Chart
    • Column
    • Bar
    • Line
    • Pie
    • Dual Axis Charts
    • Combination Charts
  • Adding Chart Elements
    • Title
    • Legend
    • Data Labels
    • Data Table
  • Chart Styles (Formatting a Chart)
    • Change the Chart Type
    • Changing the Chart Location
    • Adding Dynamic Text Boxes
    • Adding An Image in the Plot Area
  • Adding Chart Data
  • Filtering Chart Data
  • Charting Tips.

Appendix A

  • Excel 2013 Short Cuts
  • CTRL combination shortcut keys
  • Function shortcut keys
  • Other useful shortcut keys

Contact us now ›

  • Course content customization
  • In-house training request
  • Available public program
  • Consultation services
  • Other inquiries
Contact Customer ServiceCall : +603-2386-7788
Email Customer Service E-mail : [email protected]

Related Courses ›

More Other Training Courses ›

Published by: ,