Microsoft® Excel 2013 Basic & Intermediate



By TED Integrated
![]() |
![]() |
![]() |
![]() |
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
Jun 2019 ›
TED Learning Centre, Binjai 8 Premium SOHO, Kuala Lumpur, Malaysia
Schedule:
Mon 10 Jun 2019 - Tue 11 Jun 2019
9:00AM - 5:00PM
Fee Per Person:
RM954.00
Promotions:
- 10% discount for group registration of 3 paxs or more.
* Other terms & conditions apply.
Jul 2019 ›
TED Learning Centre, Binjai 8 Premium SOHO, Kuala Lumpur, Malaysia
Schedule:
Mon 01 Jul 2019 - Tue 02 Jul 2019
9:00AM - 5:00PM
Fee Per Person:
RM954.00
Promotions:
- 10% discount for group registration of 3 paxs or more.
* Other terms & conditions apply.
Aug 2019 ›
TED Learning Centre, Binjai 8 Premium SOHO, Kuala Lumpur, Malaysia
Schedule:
Thu 01 Aug 2019 - Fri 02 Aug 2019
9:00AM - 5:00PM
Fee Per Person:
RM954.00
Promotions:
- 10% discount for group registration of 3 paxs or more.
* Other terms & conditions apply.
Sep 2019 ›
TED Learning Centre, Binjai 8 Premium SOHO, Kuala Lumpur, Malaysia
Schedule:
Mon 02 Sep 2019 - Tue 03 Sep 2019
9:00AM - 5:00PM
Fee Per Person:
RM954.00
Promotions:
- 10% discount for group registration of 3 paxs or more.
* Other terms & conditions apply.
Oct 2019 ›
TED Learning Centre, Binjai 8 Premium SOHO, Kuala Lumpur, Malaysia
Schedule:
Tue 01 Oct 2019 - Wed 02 Oct 2019
9:00AM - 5:00PM
Fee Per Person:
RM954.00
Promotions:
- 10% discount for group registration of 3 paxs or more.
* Other terms & conditions apply.
Nov 2019 ›
TED Learning Centre, Binjai 8 Premium SOHO, Kuala Lumpur, Malaysia
Schedule:
Mon 04 Nov 2019 - Tue 05 Nov 2019
9:00AM - 5:00PM
Fee Per Person:
RM954.00
Promotions:
- 10% discount for group registration of 3 paxs or more.
* Other terms & conditions apply.
Dec 2019 ›
TED Learning Centre, Binjai 8 Premium SOHO, Kuala Lumpur, Malaysia
Schedule:
Mon 02 Dec 2019 - Tue 03 Dec 2019
9:00AM - 5:00PM
Fee Per Person:
RM954.00
Promotions:
- 10% discount for group registration of 3 paxs or more.
* Other terms & conditions apply.
![]() |
Request for Quotation |
![]() |
+603-2386-7788 |
![]() |
training@ted.com.my |
- Language: English
- PowerPoint Presentation
- Computer Lab Work
- Certificate of Participation
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 ›
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
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 ›
|
|
![]() |
![]() |