Register

Overview

Objective

Outline

Instructor

Location

Microsoft Excel 2013  Training Course

This extensive hands-on two-days course will provide the participants with the vital knowledge, skills, and techniques to use Microsoft Excel in everyday business and personal computing setup.  The participants learn applying basics to advanced features of excel in their specific environment for progress, efficiency and growth. They will learn all necessary skills of workplace productivity required as an entrepreneur or employers are looking for in their employee. After attending this course you will be able to discover the power of Excel and do your jobs in easy, fast and skillful way independently.

 

The participants will be learn to create and edit workbooks with multiple worksheets for various purposes and situations including for; invoices, expanses, budgets, performance charts, estimates, predictions, data analysis, visual reports etc.

Who Shall Attend

  • Entrepreneurs
  • Junior to Senior Level Mangers
  • Small and Medium Business owners and Employees
  • Contractors, ants, Consults, Engineers, Architects, Planners,
  • Quantity Surveyors, Business Analysts
  • IT, Accounts and Finance Professionals & Bankers
  • Students, support workers, instructors and others

Requisite Knowledge

  • Familiarity working with Microsoft Windows
  • Knowledge of Numbers and Arithmetic Operations.

Required Material

  • Personal Laptop
  • Microsoft Excel 2013 Software (Free download available from Microsoft website for limited learning     period)

Microsoft Office Specialist (MOS) Certification

This course will help you in preparation of following credentials after fulfilling essential requirements; if you are motivated to excel your career to a next level.

Microsoft Office Specialist (MOS) after passing Exam 77-420

Course Objective

To enhance participant’s knowledge and skills of use of Excel as a basic business tool. The goal is that after completion of course you should be able utilizing advance capabilities of Microsoft Excel 2013 towards better business management and growth.

What Participants will learn

  • Understanding the Excel Environment, Backstage View, Ribbons, Commands, Worksheet basics
  • Create and Manage highly efficient and attractive Worksheets
  • Working with Cells and Name Ranges
  • Customize and Format Worksheets
  • Use Formulas and Functions to work with numbers and data
  • Visualize Data and trends with Charts and Graphs
  • Data Exchange with other Applications (Word, Access, Project)
  • Sorting, Grouping, and Filtering Information
  • Spot trends and Sparklines
  • Printing Worksheets
  • Insert Graphics, WordArt, SmartArt, Shapes and other items
  • Manage Data with Tables
  • Pivot Tables and Pivot Charts
  • Record, Save and Use Macros to Automate tasks

and more………….

Outline of Course

DAY 1

Module 1: Overview

Software Orientation

Starting Excel

Navigating the Ribbon and Tabs

Introducing Office Backstage

Changing Excel’s View

Workbooks

Navigating a Worksheet

Working with Excel’s Help System

Module 2: Working with Microsoft Excel 2013

Creating, Saving and Opening Workbooks

Opening and saving in previous version workbooks

Entering and Editing Basic Data in a Worksheet

Entering Basic Data in a Worksheet

Working with Columns, Rows and Cells

Entering Labels and Using AutoComplete

Using Auto Fill and Flash Fill features

Cutting, Copying, and Pasting Data in a worksheet

Editing a Workbook’s Properties

Module 3: Using Backstage View

Accessing and Using Backstage view

Printing and Previewing With Backstage

Customizing Ribbon, Tabs and Quick Access Toolbar

Accessing and Using Excel Templates

Module 4: Working with Formulas

Understanding and Displaying Formulas

Understanding Order of Operations

Building Basic Formulas

Performing Addition, Subtraction, Multiplication and Division

Using Relative and Absolute Cell References in Formulas

Using External Cell References and Name Ranges

Module 5: working with Functions

Understanding Functions and various types of functions

Displaying Dates and Times with Functions

Using the SUM, Count, Average, Min and Max Function

Using Formulas to Create Subtotals

Reviewing Error Messages

Tracing and Removing Trace Arrows

Displaying and Printing Formulas

Module 6: Formatting Worksheets

Inserting or Deleting a Row or Column

Modifying Row Height and Column Width

Formatting an Entire Row or Column

Hiding or Un-hiding a Row or Column

Transposing Rows or Columns

Selecting a Theme for a Workbook

Modifying a Worksheet’s Onscreen and Printed Appearance

Formatting a Worksheet Background

Viewing and Printing a Worksheet’s Gridlines

Viewing and Printing Column and Row Headings

Inserting Headers and Footers

Adding Page Numbers, Header and Footer to a Worksheet

Inserting a Watermark

Page setup and Preparing a Document for Printing

Adding and Moving a Page Break

DAY 2

Module 7: Managing Worksheets

Organizing, Inserting, Deleting, Copying, and Renaming a Worksheet

Repositioning the Worksheets in a Workbook

Changing the Color of a Worksheet Tab

Hiding and Un-hiding Worksheets

Working with Multiple Worksheets

Working with Multiple Worksheets in a Workbook

Using Zoom and Freeze to Change the Onscreen View

Work with Find and Replace Command

8: Working with Data and Macros

Importing External Data

Opening Non-Native Files Directly in Excel

Appending Data to a Worksheet

Ensuring Your Data’s Integrity

Restricting Cell Entries to Certain Data Types

Allowing Only Specific Values to Be Entered in Cells

Removing Duplicate Rows from a Worksheet

Sorting, Grouping and Filtering Data

Outlining and Auto Outlining Data

Setting up Data in a Table Format

Formatting a Table with a Quick Style

Removing Styles from a Table

Defining a Title for a Table

Using the Total Row Command in a Table

Adding and Removing Rows or Columns in a Table

Using a Slicer to View Table Data

Converting a Table into a Range

Recording, Saving and Running Macros

Module 9: Using Advanced Formulas

Using Formulas to Conditionally Summarize Data

Using SUMIF, COUNTIF, AVERAGEIF

Using VLOOKUP and HLOOKUP

Adding Conditional Logic Functions to Formulas

Using IF, AND, OR, NOT Functions

Using Text function to Modify Text

Module 10: Securing and Sharing Workbooks

Protecting a Worksheet

Allowing Multiple Users to Edit a Workbook Simultaneously

Using the Document Inspector

Marking a Document as Final

Distributing and Sharing a Workbook by Email and the Cloud

Tracking Changes to a Workbook

Adding, Editing and Deleting a Comment

Printing Comments in a Workbook

Module 11: Display Data by Creating Charts

Working with Charts and Graphs

Choosing the Right Chart for Your Data

Formatting a Chart with a Quick Style and Layout

Formatting the Parts of a Chart MANUALLY

Editing and Adding Text on Charts

Formatting the Data Series and other components

Choosing a Different Chart Type

Switching Between Rows and Columns in Source Data

Using New Quick Analysis Tools

Adding a Chart or Sparklines

Working with Totals

Applying Conditional Formatting

Creating PivotTables and PivotCharts

Module 12: Inserting Pictures and Shapes to a Worksheet

Inserting Pictures

Adding Shapes, Lines, Text Boxes, and WordArt

Deleting, Copying and Moving Graphics

Applying Styles to Shapes and Changing Styles

Adding Graphic Enhancements Using Picture Tools

Toronto, Ontario, Canada