Microsoft Excel 2010 / 2013 Training With an Exam

Course

Online

Price on request

Description

  • Type

    Course

  • Methodology

    Online

Master Excel completely with this comprehensive course encompassing both Excel 2010 and Excel 2013. Learn how to capture, understand and present data with this powerful application and make full use of all of the tools and functions across both editi...

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • IT
  • MS Excel
  • Excel
  • Microsoft Excel
  • Microsoft excel training

Course programme

Master Excel completely with this comprehensive course encompassing both Excel 2010 and Excel 2013. Learn how to capture, understand and present data with this powerful application and make full use of all of the tools and functions across both editions. Excel 2013 has many new features that allow you to manipulate your data in new ways and guide you to make better, more informed decisions based on your calculations. A thorough understanding of Excel adds to your professional skill set and can boost your career by making you more attractive to potential employers.

A Microsoft Office specialisation certification is available for Excel, validating your knowledge and skills in this application. On passing the exam included in this course you will receive your certification.

Comprehensive and convenient

The course is broken down into 6 comprehensive modules covering basic, intermediate and advanced uses of Excel 2010 and 2013, with an exam at the end. You can spend as little or as much time on each module as you feel is necessary – simply log in and out of your course at your convenience. The flexible nature of the course means you can learn at your own pace depending on other commitments. The nature of online learning enables you to study anywhere and at any time.

key learning points

This course has been developed to enable you to become an expert in Microsoft Excel 2010 and 2013 and their various uses. Focus areas include:

  • MS Excel 2010 Introduction: Learn how to create tables in Microsoft Excel, how to enter data into them, how to format the data and how to edit the table format.
  • MS Excel 2010 Intermediate: Explore advanced techniques for data processing in Excel including formatting, locking, using templates and advanced copying. Create complex formulas and use functions within the date & time and text categories, as well as the logical, financial and database functions.
  • MS Excel 2010 Advanced: Explore working with the advanced Microsoft Excel functions for data manipulation and analysis. Familiarise yourself with macro creation, with the XML format and its use in Excel and with protecting and managing permissions for accessing workbooks.
  • MS Excel 2013 Introduction: Explore the basic concepts of Excel 2013 in this module. Learn how to create, open and save workbooks; how to enter and edit data; the use of formatting, headers and footers; working with columns and rows; using autofill and sorting and filtering data.
  • MS Excel 2013 Intermediate: Discover how Excel can transform raw data into reports using charts and graphs, formulas and functions and named ranges. Learn about data validation, sparklines, conditional formatting, comments, protecting a workbook and more.
  • MS Excel 2013 Advanced: Learn advanced Excel techniques and push your skill set to the next level. Create custom lists, use advanced forms and formulas, learn how to use the Watch Window, pivot tables, macros and how to work with external data sources.
advantages of this course
  • Comprehensive high quality e-learning content delivered in 12 manageable modules
  • Boost your education and job prospects. Develop skills and qualifications to take you to the next step in your career
  • Learn at your own pace and fully understand each module before moving on
  • Our technical support team will be on hand to offer you advice and guidance via telephone, email or online chat
  • Gain a certificate validating your core skills in this application

Invest in this course now and boost your job prospects with skills vital for the modern workplace.

  • Units of study
MS Excel 2010: Introduction

In this course, you will learn to create tables in the Microsoft Excel program, to enter data in them, to format the data and edit the table format. You will provide calculations through simple functions and formulas and will familiarize yourself with the basics of chart creation and formatting.

List of Lessons:

  • Introduction to Excel
  • Data entry and editing
  • Worksheet navigation and basic settings
  • Cell range selection
  • Manipulation with cell ranges
  • Cell inserting and deleting
  • Text and cell formatting
  • Number, Date and Time format
  • Formatting via style gallery
  • Working with files and windows
  • Printing smaller tables
  • The AutoSum button and formula copying
  • Custom formula creation
  • Work with functions
  • Chart creation
  • Chart formatting
  • Proofing
  • Basic Excel settings
  • Getting help
MS Excel 2010: Intermediate

In this course, you will learn advanced techniques for data processing in Excel (formatting, locking, using templates, advanced copying etc.). You will be creating complex formulas and using functions belonging to the date & time and text categories, as well as the logical, financial and database functions. You will learn how to filter lists on a sheet and create pivot tables. You will also practice advanced chart editing.

List of Lessons:

  • Lock
  • Advanced cell formatting
  • Conditional and custom formatting
  • Templates
  • Workbook properties and work with sheets
  • Sharing workbooks and tracking changes
  • Comments and workbooks comparing
  • Copying options, orders and lists
  • Formula creation and absolute links
  • Errors and formulas dependencies
  • Connected sheets
  • The IF, MIN, and COUNT functions
  • Functions and formulas used for Date and Time data
  • Functions for working with text
  • Rounding off
  • Financial functions
  • Techniques of work with relation tables
  • Data validation and sorting
  • Go To, Find and Replace orders
  • Printing larger tables
  • AutoFilter
  • Criteria table and advanced filter
  • Database functions
  • Outlines and totals
  • Splitting text into columns
  • Pivot table
  • Editing pivot tables and charts
  • Advanced chart editing
MS Excel 2010: Advanced

In this course, you will learn to work with the advanced Microsoft Excel functions for data manipulation and analysis. You will familiarize yourself with macro creation, with the XML format and its use in MS Excel, with protecting and managing permissions for accessing workbooks.

List of Lessons:

  • Work with range names
  • Form creation in a sheet
  • Protection options within workbooks
  • Conditional calculations
  • Conditional calculations using SUMIF and COUNTIF
  • Working with an array
  • Calculation criteria in database functions
  • Using functions for searching in tables
  • Data import
  • Work with Microsoft Query
  • Complicated queries in Microsoft Query
  • Data merging
  • Sheet scenarios
  • Resolver
  • What-if analysis and goal seek
  • Statistical methods and functions
  • Macros recording and usage
  • The VBA code view and editing
  • Webpages, links and e-mail sending
  • File security
  • Permission control
  • Introduction to XML
  • Working with data in the XML format
Excel 2013 Basic
  • Introduction
  • Create Workbook
  • Opening an Existing Workbook
  • Saving a workbook
  • Entering and editing data
  • Formatting
  • Headers & Footers
  • Copy, pasting and moving data
  • Working with columns and rows
  • Using Autofil
  • Preview and Printing
  • Formula and Functions
  • Sorting and Filtering Data
Excel 2013 Intermediate
  • Charts and Graphs
  • Named Ranges
  • Intermediate Formula and Functions
  • Formula Auditing
  • Outline Groups
  • Data Validation
  • Sparklines
  • Conditional Formatting
  • Comments
  • Protecting a workbook
Excel 2013 Advanced
  • Create Custom Lists
  • Forms
  • Advanced Formula and Functions
  • Using the Watch Window
  • Scenarios
  • Goal Seek
  • Solver
  • Pivot Tables
  • Macros
  • Working with External Data sources

Microsoft Excel 2010 / 2013 Training With an Exam

Price on request