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 blend 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