Microsoft Excel 2013

Apply now for our Microsoft Excel 2013 Course



  • Get started with Excel 2013
  • Use SUBTOTAL and Database Functions
  • Analyzing Data with PivotTables, Slicers, and PivotCharts
  • Use Formulas and Functions to Apply Conditional Formatting
  • Apply Data Validation


Course Details


Instructor Led Learning


  Duration: 3 Days

  Registration Open Now!

Online Learning


  Duration: 365 Days

  Registration Open Now!

Call us : 0861 111 460

Microsoft Excel Course overview

Part 1:
In this course, students will use Microsoft Excel Training to create spreadsheets and workbooks that you can use to store, manipulate, and share your data.

Part 2:
Students will build upon the foundational Microsoft Excel 2013 knowledge and skills already acquired and learn to create advanced workbooks and worksheets, including advanced formulas, tables, PivotTables, PivotCharts and data filtering.

Part 3:
In this course, students will learn some of the more advanced features of Microsoft Excel, including automating common tasks, auditing workbooks to avoid errors, sharing data with other people, analyzing data, and using Excel data in other applications.





 Microsoft Excel training course cape town

Is this course for you?

Microsoft Excel 2013 is the standard spreadsheet application for both business and personal use. Microsoft Excel 2013 features graphing tools, calculations, pivot tables and more. Whether you’re new or already an advanced user, MasterGrade IT’s Excel courses for Microsoft Excel 2013 will teach you all you need to know – from basic to advanced features – to become an excel power user.

From formatting to design, this short Excel training course will allow you to create a range of documents for use in both the business and personal realm.


Available Microsoft Excel Exams and Certification Paths

Start off with Microsoft Excel exams: Other Microsoft Office Course:

Job Opportunities

Job Title:Office Administrator

Responsibilities:
The Microsoft Excel will you build a spreedsheets that helps your business. You will be responsible for the working on spreedsheets for business equipment, such as status and business maintains. Responsibility for staff login.

3 Steps to Master Microsoft Excel

01

Take a
course

02

Write an
Exam

03

Get
Certified

What you will learn
Microsoft Excel 2013 Training Course

  • Lesson 1:Microsoft Excel Part 1:
  • Lesson 2:Microsoft Excel Part 2:
  • Lesson 3:Microsoft Excel Part 3:

Full course outline
Microsoft Excel 2013 Training Course

Microsoft Excel 2013 Part 1

Lesson 1: Getting Started Microsoft Excel 2013

  • Navigate the Excel User Interface
  • Use Excel Commands
  • Create and Save a Basic Workbook
  • Enter Cell Data
  • Use Excel Help

Lesson 2: Performing Calculations

  • Create Formulas in a Worksheet
  • Insert Functions in a Worksheet
  • Reuse Formulas

Lesson 3: Modifying a Worksheet

  • Insert, Manipulate, and Delete Cells, Columns, and Rows
  • Search for and Replace Data
  • Use Proofing and Research Tools

Lesson 4: Formatting a Worksheet

  • Modify Fonts
  • Add Borders and Color to Cells
  • Apply Number Formats
  • Align Cell Contents
  • Apply Styles and Themes
  • Apply Basic Conditional Formatting
  • Create and Use Templates

Lesson 5: Printing Workbooks

  • Preview and Print a Workbook
  • Define the Page Layout

Lesson 6: Managing Workbooks

  • Manage Worksheets
  • Manage Workbook and Worksheet Views
  • Manage Workbook Properties

Microsoft Excel 2013 Part 2

Lesson 1: Customizing the Excel Environment

  • Configure Excel Options
  • Customize the Ribbon and the Quick Access Toolbar
  • Enable Excel Add-Ins

Lesson 2: Creating Advanced Formulas

  • Use Range Names in Formulas
  • Use Specialized Functions
  • Use Array Formulas

Lesson 3: Analyzing Data with Functions and Conditional Formatting

  • Analyze Data by Using Text and Logical Functions
  • Apply Advanced Conditional Formatting

Lesson 4: Organizing and Analyzing Datasets and Tables

  • Create and Modify Tables
  • Sort Data
  • Filter Data
  • Use SUBTOTAL and Database Functions

Lesson 5: Visualizing Data with Basic Charts

  • Create Charts
  • Modify and Format Charts

Lesson 6: Analyzing Data with PivotTables, Slicers, and PivotCharts

  • Create a PivotTable
  • Analyze PivotTable Data
  • Present Data with PivotCharts
  • Filter Data by Using Slicers

Microsoft Excel 2013 Part 3

Lesson 1: Working with Multiple Worksheets and Workbooks Simultaneously

  • Use 3-D References
  • Use Links and External References
  • Consolidate Data

Lesson 2: Sharing and Protecting Workbooks

  • Collaborate on a Workbook
  • Protect Worksheets and Workbooks

Lesson 3: Automating Workbook Functionality

  • Apply Data Validation
  • Work with Forms and Controls
  • Work with Macros

Lesson 4: Applying Conditional Logic

  • Use Lookup Functions
  • Combine Functions
  • Use Formulas and Functions to Apply Conditional Formatting

Lesson 5: Auditing Worksheets

  • Trace Cells
  • Search for Invalid Data and Formulas with Errors
  • Watch and Evaluate Formulas

Lesson 6: Using Automated Analysis Tools

  • Determine Potential Outcomes Using Data Tables
  • Determine Potential Outcomes Using Scenarios
  • Use the Goal Seek Feature
  • Activate and Use the Solver Tool
  • Analyze Data with Analysis ToolPak Tools

Lesson 7: Presenting Your Data Visually

  • Use Advanced Chart Features
  • Create Sparklines

Do you want to create sales dashboards using Microsoft Excel?