Courses

Existing User Login

Forgot password?

New User? Create An Account

Request new password

We are iCollege

Established in 2003 under the parent company XpertSkills, iCollege is one of the most trusted marketplaces in E-Learning. Our dedication transcends mere content – we source learning products from only the best suppliers and vendors across the globe so you have the widest selection of educational courses designed to equip you for success.

Headquartered in stunning South Africa, our distributed company spans 3 continents with employees in the U.S., India, and of course, South Africa. Our customers call more than 120 countries home. We're proud to say iCollege is trusted by leading organizations in major tech hubs, including Silicon Valley, to train and equip employees to be the very best that they can be.

Whether partnering with Fortune 500 companies or being part of an individual's journey toward career growth, we are committed to the success of all who trust us as their source for education and training.

Contact Details:

Web: www.xpertskills.com
Skype: xpertskills
Mail: info@xpertskills.com

Physical Address:

Head Office - South Africa
16 Monte Carlo Crescent
Kyalami business Park
Johannesburg
South Africa 1684

You are here

Home » Course » Microsoft Office 2013 - Excel

Microsoft Office 2013 - Excel

EDUTAINMENT COURSE E-Learning

Microsoft Office 2013 - Excel

Interactive and entertaining talk-show style format presented by industry leading experts.
Overview

Microsoft Excel is the most commonly used spreadsheet application. Learning how to use Excel is an investment in both your personal and professional life. Excel makes it easy to monitor financial performance, (such as business profit or loss, calculate payments on large purchases, plan a budget, or stay organized with checklists ) as well as for data analysts, developers, IT professionals, project leads, and project managers especially who are willing to explore the self-service business intelligence tools in Microsoft Excel 2013.

As most businesses use Excel, learning how to use the application efficiently opens up more opportunities for employment and career advancement. When employees know how to use Excel, it improves their efficiency in the workplace. Employees who know how to create detailed worksheets, invoices, charts, and complex formulas achieve professional results in a fraction of the time.

Objectives
  • Summarize data with Excel by incorporating formulas, formatting, and charts and graphs
  • Optimize your worksheets using templates, graphs, and formulas
  • Design simple to complex formulas by nesting Excel functions
  • Import, fine-tune, and share Excel data
  • Create, manage, and launch macros
Prerequisites

Some knowledge about basic data warehousing and data modeling concepts would be an added advantage. Working knowledge with Excel is mandatory.

Target Audience
  • Users with a basic knowledge of Excel
  • Users who have completed Beginners / Intermediate Excel title
  • If your looking to take your Excel skills from beginner to advanced level and beyond, then this course is for you.

Microsoft Excel 2013 - Course Introduction

  • Section 1-1 - Create Worksheets and Workbooks
  • Creating New Blank Workbooks
  • Creating New Workbooks Using Templates
  • Importing Files
  • Opening Non-Native Files Directly in Excel
  • Adding Worksheets to Existing Workbooks
  • Copying and Moving Worksheets

Section 1-2 - Navigate Through Worksheets and Workbooks

  • Searching for Data Within a Workbook
  • Using Go To and Name Box
  • Changing Worksheet Order
  • Inserting Hyperlinks

Section 1-3 - Format Worksheets and Workbooks

  • Changing Worksheet Tab Color
  • Modifying Page Setup and Inserting Watermarks
  • Inserting and Deleting Columns and Rows
  • Changing Workbook Themes
  • Adjusting Row Height and Column Width
  • Inserting Headers and Footers
  • Setting Data Validation

Section 1-4 - Customize Options and Views for Worksheets and Workbooks

  • Hiding Columns - Rows - Worksheets
  • Customizing the Quick Access Toolbar and the Ribbon
  • Managing Macro Security
  • Changing Workbook Views
  • Recording Simple Macros
  • Adding Values to Workbook Properties
  • Using Zoom
  • Displaying Formulas
  • Freezing Panes
  • Splitting the Window

Section 1-5 - Configure Worksheets and Workbooks to Print or Save

  • Setting a Print Area
  • Saving Workbooks in Alternate File Formats
  • Printing Individual Worksheets and Scaling
  • Repeating Headers and Footers
  • Maintaining Backward Compatibility
  • Configuring Workbooks to Print
  • Saving Files to Remote Locations

Section 2-1 - Insert Data in Cells and Ranges

  • Appending Data to Worksheets
  • Finding and Replacing Data
  • Copying and Pasting Data
  • Using AutoFill Tool
  • Inserting and Deleting Cells

Section 2-2 - Format Cells and Ranges

  • Merging Cells
  • Modifying Cell Alignment and Indentation plus Changing Font and Font Styles
  • Using Format Painter
  • Wrapping Text Within Cells
  • Applying Number Formatting
  • Applying Highlighting and Cell Styles
  • Changing Text to WordArt

Section 2-3 - Order and Group Cells and Ranges

  • Applying Conditional Formatting
  • Transposing Columns and Rows
  • Inserting Sparklines
  • Creating Named Ranges
  • Creating Outline - Collapsing Groups of Data in Outlines and Inserting Subtotals

Section 3-1 - Create a Table

  • Creating a Table and Moving Between Tables and Ranges
  • Adding and Removing Cells Within Tables
  • Defining Titles

Section 3-2 - Modify a Table

  • Applying Styles to Tables
  • Banding Rows and Columns
  • Inserting Total Rows
  • Removing Styles From Tables

Section 3-3 - Filter and Sort a Table

  • Filtering Records
  • Changing Sort Order
  • Sorting Data on Multiple Columns
  • Removing Duplicates

Section 4-1 - Utilize Cell Ranges and References in Formulas and Functions

  • Utilizing References - Relative - Mixed - Absolute
  • Defining Order of Operations
  • Referencing Cell Ranges in Formulas

Section 4-2 - Summarize Data with Functions

  • Utilizing the SUM Function
  • Utilizing the MIN and MAX Functions
  • Utilizing the COUNT Function
  • Utilizing the AVERAGE Function

Section 4-3 - Utilize Conditional Logic in Functions

  • Utilizing the SUMIF Function
  • Utilizing the AVERAGEIF Function
  • Utilizing the COUNTIF Function

Section 4-4 - Format and Modify Text with Functions

  • Utilizing the RIGHT - LEFT and MID Functions
  • Utilizing the TRIM Function
  • Utilizing the UPPER and LOWER Functions
  • Utilizing the CONCATENATE Function

Section 5-1 - Create a Chart

  • Creating Charts and Graphs
  • Adding Additional Data Series
  • Switching Between Rows and Columns in Source Data
  • Using Quick Analysis

Section 5-2 - Format a Chart

  • Adding Legends
  • Resizing Charts and Graphs
  • Modifying Chart and Graph Parameters
  • Applying Chart Layouts and Styles
  • Positioning Charts and Graphs

Section 5-3 - Insert and Format an Object

  • Inserting Text Boxes
  • Inserting SmartArt
  • Inserting Images
  • Adding Borders to Objects
  • Adding Styles and Effects to Objects
  • Changing Object Colors
  • Modifying Object Properties and Positioning Objects
  • Course Close
  1. Introduction
1
Microsoft Excel 2013 - Course Introduction
  1. Excel 2013 Module 1
2
Section 1-1 - Create Worksheets and Workbooks
3
Creating New Blank Workbooks
5
Creating New Workbooks Using Templates
6
Importing Files
7
Opening Non-Native Files Directly in Excel
8
Adding Worksheets to Existing Workbooks
9
Copying and Moving Worksheets
10
Section 1-2 - Navigate Through Worksheets and Workbooks
11
Searching for Data Within a Workbook
12
Using Go To and Name Box
13
Changing Worksheet Order
14
Inserting Hyperlinks
15
Section 1-3 - Format Worksheets and Workbooks
16
Changing Worksheet Tab Color
17
Modifying Page Setup and Inserting Watermarks
18
Inserting and Deleting Columns and Rows
19
Changing Workbook Themes
20
Adjusting Row Height and Column Width
20
Adjusting Row Height and Column Width
21
Inserting Headers and Footers
22
Setting Data Validation
23
Section 1-4 - Customize Options and Views for Worksheets and Workbooks
24
Hiding Columns - Rows - Worksheets
25
Customizing the Quick Access Toolbar and the Ribbon
26
Managing Macro Security
27
Changing Workbook Views
28
Recording Simple Macros
29
Adding Values to Workbook Properties
30
Using Zoom
31
Displaying Formulas
32
Freezing Panes
33
Splitting the Window
34
Section 1-5 - Configure Worksheets and Workbooks to Print or Save
35
Setting a Print Area
36
Saving Workbooks in Alternate File Formats
37
Printing Individual Worksheets and Scaling
38
Repeating Headers and Footers
39
Maintaining Backward Compatibility
40
Configuring Workbooks to Print
41
Saving Files to Remote Locations
  1. Excel 2013 Module 2
42
Section 2-1 - Insert Data in Cells and Ranges
43
Appending Data to Worksheets
44
Finding and Replacing Data
45
Copying and Pasting Data
46
Using AutoFill Tool
47
Inserting and Deleting Cells
48
Section 2-2 - Format Cells and Ranges
49
Merging Cells
50
Modifying Cell Alignment and Indentation plus Changing Font and Font Styles
50
Modifying Cell Alignment and Indentation plus Changing Font and Font Styles
51
Using Format Painter
52
Wrapping Text Within Cells
53
Applying Number Formatting
54
Applying Highlighting and Cell Styles
55
Changing Text to WordArt
56
Section 2-3 - Order and Group Cells and Ranges
57
Applying Conditional Formatting
58
Transposing Columns and Rows
59
Inserting Sparklines
60
Creating Named Ranges
61
Creating Outline - Collapsing Groups of Data in Outlines and Inserting Subtotals
  1. Excel 2013 Module 3
62
Section 3-1 - Create a Table
63
Creating a Table and Moving Between Tables and Ranges
64
Adding and Removing Cells Within Tables
65
Defining Titles
66
Section 3-2 - Modify a Table
67
Applying Styles to Tables
68
Banding Rows and Columns
69
Inserting Total Rows
70
Removing Styles From Tables
71
Section 3-3 - Filter and Sort a Table
72
Filtering Records
73
Changing Sort Order
74
Sorting Data on Multiple Columns
75
Removing Duplicates
95
Creating Charts and Graphs
  1. Excel 2013 Module 4
76
Section 4-1 - Utilize Cell Ranges and References in Formulas and Functions
77
Utilizing References - Relative - Mixed - Absolute
78
Defining Order of Operations
79
Referencing Cell Ranges in Formulas
80
Section 4-2 - Summarize Data with Functions
81
Utilizing the SUM Function
82
Utilizing the MIN and MAX Functions
83
Utilizing the COUNT Function
84
Utilizing the AVERAGE Function
85
Section 4-3 - Utilize Conditional Logic in Functions
86
Utilizing the SUMIF Function
87
Utilizing the AVERAGEIF Function
88
Utilizing the COUNTIF Function
89
Section 4-4 - Format and Modify Text with Functions
90
Utilizing the RIGHT - LEFT and MID Functions
91
Utilizing the TRIM Function
92
Utilizing the UPPER and LOWER Functions
93
Utilizing the CONCATENATE Function
  1. Excel 2013 Module 5
94
Section 5-1 - Create a Chart
96
Adding Additional Data Series
97
Switching Between Rows and Columns in Source Data
98
Using Quick Analysis
99
Section 5-2 - Format a Chart
100
Adding Legends
101
Resizing Charts and Graphs
102
Modifying Chart and Graph Parameters
103
Applying Chart Layouts and Styles
104
Positioning Charts and Graphs
105
Section 5-3 - Insert and Format an Object
106
Inserting Text Boxes
107
Inserting SmartArt
108
Inserting Images
109
Adding Borders to Objects
110
Adding Styles and Effects to Objects
111
Changing Object Colors
112
Modifying Object Properties and Positioning Objects
113
Course Close
EDUTAINMENT COURSE E-Learning
?Interactive and entertaining talk-show style format presented by industry leading experts.
USD 195
  • 07:02:23
    Hours of learning
  • Receive a Certificate of Excellence on successful completion
  • Presented by highly qualified, industry leading experts
  • 12 Months Access (Unless indicated otherwise)
  • 10-Day money-back guarantee
Request a Demo
© 2020 iCollege - All Rights Reserved Terms & Conditions Privacy Policy Affiliate Program
Back to Top