Microsoft Excel 2013 Online Course

Excel 2013 Online Courses in South Africa

This 2KO Excel 2013 course provides students with the knowledge and skills that are needed to use the Microsoft Excel 2013. 2KO International delivers consulting services, in the IT and Business space, as well as being a training provider for IT certification and user level courses. Training can be any combination of bespoke, classroom and online learning. from the comfort of home or work. Our MOS Excel 2013 training course provides students with the knowledge and skills that are needed to use the advanced software features, and integrate the Office programs with other software. When you pass the Excel 2013 Exam 77-420, you achieve Microsoft Certified Application Specialist (MOS) status in Excel 2013. The Microsoft Certified Application Specialist Certification, (MOS) recognizes business professionals who have demonstrated expertise in Microsoft Office 2013.

 

 

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