| Available 24 Hours Monday - Friday | +60 1800812339
Please enter course

Got a quick question or comment?
Send us enquiry.

Enter your details and we will call you back to discuss your requirements

Excel Training | Excel Courses | Microsoft Excel Training

  • Learn how to Use & Apply Excel by your Accredited Microsoft Partner
  • Enhance Your Productivity at work with our Excel Tutorial
  • Gain a more advanced understanding of Microsoft Excel with this Masterclass
  • Courses delivered by Highly Experienced certified Excel instructors
  • Excel Training in Luxury Nationwide Venues
  • Book Online or Call +60 1800812339 to speak to an Excel advisor today
Schedule
Course Dates, Locations & Prices (Top) | View Course Info
Course Name Date Location Duration Price Book Online
Microsoft Excel Masterclass 15/09/17 Kuala Lumpur
1 day $1679 Book now Enquire
Microsoft Excel Masterclass 20/10/17 Kuala Lumpur
1 day $1679 Book now Enquire
Microsoft Excel Masterclass 17/11/17 Kuala Lumpur
1 day $1679 Book now Enquire
Microsoft Excel Masterclass 15/12/17 Kuala Lumpur
1 day $1679 Book now Enquire
Microsoft Excel Masterclass 19/01/18 Kuala Lumpur
1 day $1679 Book now Enquire
Microsoft Excel Masterclass 16/02/18 Kuala Lumpur
1 day $1679 Book now Enquire
Microsoft Excel Masterclass 16/03/18 Kuala Lumpur
1 day $1679 Book now Enquire
Microsoft Excel Masterclass 20/04/18 Kuala Lumpur
1 day $1679 Book now Enquire
Microsoft Excel Masterclass 18/05/18 Kuala Lumpur
1 day $1679 Book now Enquire
Microsoft Excel Masterclass 15/06/18 Kuala Lumpur
1 day $1679 Book now Enquire
Microsoft Excel Masterclass 20/07/18 Kuala Lumpur
1 day $1679 Book now Enquire
Microsoft Excel Masterclass 17/08/18 Kuala Lumpur
1 day $1679 Book now Enquire

Course Information (Top) | View Dates & Pricing

Description

Microsoft Excel Training

Introduction to Microsoft Excel Masterclass Course

Microsoft Excel course provides delegates with the vital knowledge and skills of creating and editing worksheets or workbooks. Microsoft Excel helps candidates to work with basic formulas, lists, illustrations, charts, and basic formatting tools and styles. This introductory course provides necessary skills to use pivot tables, assess or analyse worksheet data, utilise data tools, as well as create and manage macros.

Prerequisites

There are some prerequisites required for this course:
 
Candidates will need to have familiarity with using a computer as well as Windows 10.

Course Outline

1. Getting Started with Excel:
  • Starting Excel from the Desktop
  • Understanding the Excel Start Screen
  • The Excel Tab Interface
  • The Excel Workbook Screen
  • How Excel 2013 Works
  • Using the Ribbon
  • Showing and Collapsing the Ribbon
  • Understanding the Backstage View
  • Accessing the Backstage View
  • Using Shortcut Menus
  • Understanding Dialogue Boxes
  • Launching Dialogue Boxes
  • Understanding the Quick Access Toolbar
  • Adding Commands to the QAT
  • Understanding the Status Bar
2. Sorting Data:
  • Understanding lists
  • Performing an alphabetical sort
  • Performing a numerical sort
  • Sorting on more than one column
  • Sorting numbered lists
  • Sorting by rows
  • Understanding filtering
  • Applying and using a filter
  • Clearing a filter
  • Creating compound filters
  • Multiple value filters
  • Creating custom filters
  • Using wildcards
 
3. Managing Tables
  • Creating a table
  • Inserting or deleting table records
  • Removing duplicates
  • Modifying a table
  • Sorting data in a table
  • Filtering data in a table
  • Adding and removing table columns
  • Naming tables
  • Resizing tables
  • Playing with table styles
  • Converting a table to a range
  • Deleting a table
4. Conditional Formatting:
  • Understanding conditional formatting
  • Highlighting cells containing values
  • Highlighting cells containing text
  • Highlighting duplicate values
  • Using top and bottom rules
  • Using data bars
  • Using colour scales
  • Using icon sets
  • Creating custom rules
  • The conditional formatting rules manager
  • Managing rules
  • Clearing rules
  • Using Sparklines
5. Working with Functions and Formulas:
  • Using Formulas in Excel
  • Exploring Excel Functions
  • Using Functions in Excel
  • Working with Names and Ranges
  • Working with Array Formulas
  • What if Formulas
  • Common Error Messages
6. Pivot Tables:
  • Create a PivotTable from an Excel data list
  • Add/remove/reorganise data fields
  • View data in more detail
  • Change how values are summarised
  • Refresh data/change data source
  • Filter PivotTable with Slicers/Timelines
  • Create and modify a PivotChart
  • VLOOKUP’s
7. Charts
  • Create and modify charts such as Pie, Column & Line
  • Format charts to enhance their presentation
  • Print charts​

TIPS and TIRCKs – Top 10 Shortcuts

  • Enter data or formulas in nonadjacent cells simultaneously
  • Copy data or formulas down a column instantly
  • Instantly enter today's date or time
  • Convert formulas to values with a simple drag
  • Adjust all or selected column widths or row heights in a flash
  • Display all worksheet formulas instantly
  • Create charts instantly with either of these keystroke shortcuts
  • Display Print Preview instantly
  • Undo, redo, and repeat with keystrokes
  • Zoom in and out quickly
Whats Included?
  • Delegate pack consisting of course notes and exercises.
  • Manual.
  • Experienced Instructor.
  • Refreshments.

best-price      customer-charter

FAQs

There hasn't been any questions asked about this course

Why Choose us?
  • Certified and Approved

    We're accredited by leading training organisations including AXELOS, BCS, The Chartered Institute of IT, APMG, PMI, The Open Group and many more.


  • Best Price Guarantee

    As well as providing the best training in the industry, we'll also provide it at the best price. We'll beat any like for like quote from our competitors.


  • World's Largest Global Training Provider

    We offer training in the more locations than any other provider with over 1200 training locations globally.


  • Trusted by Industry Leading Brands

    We're proud of our range of high-profile clients including brands such as JP Morgan, HSBC, British Airways, BskyB, Sony, AT&T to name only a few


  • Hands-on, Expert Instructor-led Classroom Training

    All our trainers are hand-picked, highly experienced, subject matter experts, who can not only train you but also use real world and practical examples.


  • Dedicated 24/7 Support

    We are here to provide help and guidance before, during and after your training course to make sure you get the most from your training

Reviews
 Contact Us  More Courses

Happy Customers

There hasn't been any testimonials submitted to this topic