learn@sitespower.com

Dubai: +9714 330 6555

Sharjah: +9716 575 1315

 

 

Microsoft Excel 2013

Microsoft Office >

 

Microsoft Office Excel 2013 Courses

7 Hours per Level - Instructor Led Course

 

 

Upcoming Schedules for Excel 2013 :view all Computer Skills schedules
Dubai 26/Feb/2017 10:00 AM - 6:00 PM Sundays Enquire Now
Dubai 27/Feb/2017 10:00 AM - 6:00 PM Mondays Enquire Now
Dubai 28/Feb/2017 10:00 AM - 6:00 PM Tuesdays Enquire Now
Dubai 01/Mar/2017 10:00 AM - 6:00 PM Wednesdays Enquire Now

 

Center Benefits - Microsoft Office Courses :

• Free Online Skills Assessment Tests

• Corporate Venue: Onsite or at SitesPower

• UAE Ministry of Education Accredited Institute

• International Curriculum

• Certified Instructors

• Computer Labs: 1 PC for each student

• Certificate of Achievement (Ministry Attestation fees apply)

 

Training Quality Guarantees :

(conditions apply)

• Free Course Trial

• Free Course Repeat

• Corporate HR Investment Guarantee

• Corporate Customization

• Course Version Upgrade

 

COURSE OUTLINES

 

FOUNDATION LEVEL COURSE OUTLINE

Getting Started With Excel 2013
Starting Excel 2013
Selecting the Blank Worksheet Template
The Excel 2013 Cell Referencing System
Entering Numbers and Text
Default Text and Number Alignment
Summing a Column of Numbers
Entering a Date
Worksheets and Workbooks
Saving a Workbook to Your Hard Disk
Closing a Workbook
Creating a New Workbook
Opening a Workbook
Opening a Recently Used Workbook
Pinning Files and Folders
Switching between Workbooks
Saving a Workbook Using another Name
Saving a Workbook Using a Different File Type
Getting Help within Excel 2013
Searching For Help
The Help 'Table of Contents'
Printing a Help Topic
Alt Key Help
Using Other Excel Templates

 

Excel 2013 Selection Techniques
Why Are Selection Techniques Important?
Selecting a Cell
Selecting a Range of Connecting Cells
Selecting a Range of Non-Connecting Cells
Selecting the Entire Worksheet
Selecting a Row
Selecting a Range of Connecting Rows
Selecting a Range of Non-Connected Rows
Selecting a Column
Selecting a Range of Connecting Columns
Selecting a Range of Non-Connecting Columns
Recommended Techniques When Creating or Editing Lists

 

Manipulating Rows and Columns within Excel 2013
Inserting Rows into a Worksheet
Inserting Columns into a Worksheet
Deleting Rows within a Worksheet
Deleting Columns within a Worksheet
Modifying Column Widths
Modifying Column Widths Using 'Drag and Drop'
Automatically Resizing the Column Width to Fit Contents
Modifying Row Heights

 

Manipulating Cells and Cell Content within Excel 2013
Copying a Cell or Range Contents within a Workbook
Deleting Cell Contents
Moving the Contents of a Cell or Range within a Workbook
Editing Cell Content
Undo and Redo
Copying Data between Worksheets (Within the Same Workbook)
Moving Data between Worksheets (Within the Same Workbook)
Moving Data Worksheets (Between Different Workbooks)
Copying Data between Worksheets (In Different Workbooks)
AutoFill
Copying a Data Range Using AutoFill
Sorting a Cell Range
Searching and Replacing Data

 

Excel 2013 Worksheets
Switching between Worksheets
Renaming a Worksheet
Recommended Techniques with Naming Worksheets
Inserting a New Worksheet
Deleting a Worksheet
Copying a Worksheet within a Workbook
Moving a Worksheet within a Workbook
Copying or Moving Worksheets between Workbooks

 

Font Formatting within Excel 2013
Font Formatting Options
Font Type
Font Size
Bold, Italic, Underline Formatting
Cell Border Formatting
Formatting the Background Colour
Formatting the Font Colour

 

Alignment Formatting within Excel 2013
Horizontally Aligning Contents in a Cell Range
Centring a Title over a Cell Range
Cell Orientation
Text Wrapping within a Cell
Aligning Cell Contents Vertically
Format Painter

 

Number Formatting within Excel 2013
Number Formatting
Decimal Point Display
Applying and Removing Comma Style Formatting (To Indicate Thousands)
Currency Symbol
Date Styles
Percentages

 

Freezing Row and Column Titles
Freezing Row and Column Titles

 

Excel 2013 Formulas
Creating Formulas
The Easy Way to Create Formulas
Copying Formulas
Operators
Using Operators in Formulas
Formula Error Messages
Relative Cell Referencing within Formulas
Absolute Cell Referencing within Formulas

 

Excel 2013 Functions
What Are Functions?
Common Functions
Sum Function
Average Function
Max Function
Min Function
Count Function
The Counta Function
The Countblank Function
What Are 'If Functions'?
Using the If Function

 

Excel 2013 Charts
Inserting a Column Chart
Inserting a Line Chart
Inserting a Bar Chart
Inserting a Pie Chart
Resizing a Chart
Deleting a Chart
Chart Title or Labels
Changing the Column, Bar, Line or Pie Slice Colours in a Chart
Modifying the Legend Fill Colour
Changing the Chart Type
Modifying Charts Using the Layout Tab
Copying and Moving Charts within a Worksheet
Copying and Moving Charts between Worksheets
Copying and Moving Charts between Workbooks

 

Customising Excel 2013
Modifying Basic Excel Options

 

INTERMEDIATE LEVEL COURSE OUTLINE

Excel 2013 Setup & Printing Issues
Worksheet Margins
Worksheet Orientation
Worksheet Page Size
Headers and Footers
Header and Footer Fields
Scaling Your Worksheet to Fit a Page(S)
Visually Checking Your Calculations
Displaying Gridlines When Printing
Printing Titles on Every Page
Printing Row and Column Headings
Spell Checking
Previewing a Worksheet
Viewing Workbooks Side By Side
Zooming the View
Printing Options
Setting the Number of Copies to Print
Selecting a Printer
Selecting Individual Worksheets or the Entire Workbook
Selecting Which Pages to Print
Single or Double Sided Printing
Collation Options
Page Orientation
Paper Size
Margins
Scaling
Printing

 

Excel 2013 Functions and Formulas
Getting Help with Functions
Nested Functions
Consolidating Data Using a 3-D Reference Sum Function
Mixed References within Formulas

 

Excel 2013 Time & Date Functions
Inserting the Current Time and Date
Today Function
Now Function
Day Function
Month Function
Year Function

 

Excel 2013 Mathematical Functions
Round Function
Rounddown Function
Roundup Function


Excel 2013 Logical Functions
If Function
And Function
Or Function

 

Excel 2013 Mathematical Functions
Sumif Function

 

Excel 2013 Statistical Functions
Count Function
Counta Function
Countif Function
Countblank Function
Rank Function

 

Excel 2013 Text Functions
Left Function
Right Function
Mid Function
Trim Function
Concatenate Function

 

Excel 2013 Financial Functions
Fv Function
Pv Function
Npv Function
Rate Function
Pmt Function

 

Excel 2013 Lookup Functions
Vlookup Function
Hlookup Function

 

Excel 2013 Database Functions
Dsum Function
Dmin Function
Dmax Function
Dcount Function
Daverage Function

 

Excel 2013 Named Ranges
Naming Cell Ranges
Removing a Named Range
Named Cell Ranges and Functions

 

Excel 2013 Cell Formatting
Applying Styles to a Range
Conditional Formatting
Custom Number Formats


Manipulating Worksheets within Excel 2013
Copying or Moving Worksheets between Workbooks
Splitting a Window
Hiding Rows
Hiding Columns
Hiding Worksheets
Un-Hiding Rows
Un-Hiding Columns
Un-Hiding Worksheets

 

Excel 2013 Templates
Using Templates
Creating Excel Templates
Editing Excel Templates

 

Paste Special Options within Excel 2013
Using Paste Special to Add, Subtract, Multiply & Divide
Using Paste Special ‘Values’
Using Paste Special Transpose Option

 

ADVANCED LEVEL COURSE OUTLINE

 

Pivot Tables
Creating and Using a Pivot Table
Filtering and Sorting Data within a Pivot Table
Automatically Grouping Data in a Pivot Table and Renaming Groups
Manually Grouping Data in a Pivot Table and Renaming Groups

 

Input Tables
One-Input Data Tables
Two-Input Data Tables

 

Charts
Creating a Combined Line and Column Chart
Adding a Secondary Axis to a Chart
Changing the Chart Type for a Particular Data Series
Adding a Data Series to a Chart
Removing a Data Series from a Chart
Re-Positioning Chart Title
Re-Positioning the Chart Legend
Moving and Formatting Chart Data Labels
Modifying Chart Axis Scales
Formatting an Axis to Display Using Commas
Inserting Images into Chart Columns
Inserting Images to Chart Bars
Formatting the Chart Plot Area Using a Picture
Formatting the Chart Area Using a Picture

 

Hyperlinks
Inserting a Hyperlink
Editing a Hyperlink
Removing a Hyperlink

 

Linking & Embedding
What Is Embedding and Linking?
Linking Data within a Worksheet
Linking Cells between Worksheets within a Workbook
Linking Data between Workbooks
Linking Data from Excel to a Word Document
Linking an Excel Chart to a Word Document
Updating, Locking and Breaking Links


Importing Text Files
What Is a Delimited Text File?
Importing a Delimited Text File

 

Sorting and Filtering Data
Sorting Data by Multiple Columns at the Same Time
Applying a Pre-Installed Custom Sort
Creating a Customized List and Performing a Custom Sort
Removing a Customised List
Using AutoFilter
Using AutoFilter to Perform Multiple Queries
Top 10 AutoFilter
Removing All AutoFilters from a Worksheet
Advanced Filter Criteria
Sub-Totalling
Removing Subtotals
Expanding and Collapsing Outline Detail Levels

 

Tracking and Reviewing Changes
Enabling or Disabling the 'Track Changes' Feature
Sharing, Comparing and Merging Worksheets

Scenarios
Scenario Manager
Scenario Summary Reports

 

Validating
Data Validation - Whole Number
Data Validation - Decimal Number
Data Validation - List
Data Validation - Date
Data Validation - Time
Data Validation - Text Length
Customising a Validation Input Message and Error Alert
Removing Data Validation

 

Auditing
Tracing Precedent Cells
Tracing Dependent Cells
Cells with Missing Dependents
Showing All Formulas in a Worksheet
Inserting and Viewing Comments
Editing and Deleting Comments
Showing and Hiding Comments

 

Macros
Macro to Change the Page Set-Up
Macro to Apply a Custom Number Format
Macro to Format a Cell Range
Macro to Insert Fields into the Header or Footer
Assigning a Macro to a Button on the Quick Access Toolbar
Deleting Macros

 

Passwords & Security Issues
Adding 'Open' Password Protection to a Workbook
Adding 'Modify' Password Protection to a Workbook
Removing an 'Open' Password from a Workbook
Removing a 'Modify' Password from a Workbook
Password Protecting Cells and Worksheets
Hiding Formulas
Un-Hiding Formulas