Ms Office Excel Intermediate 2013 Sat Training Course Course: Introduction

This course is intended for all users of Excel. This course incorporates some new features and connectivity options in efforts to make collaboration and production as easy as possible. Also included are advanced formulas, data analyzing, tables, data charts, graphics and enhancing workbooks.

Ms Office Excel Intermediate 2013 Sat Training Course Course :Course Outline

1. Introduction
Creating advanced formulas
Apply range names

2. Tables
Create and modify tables
Sort and filter data
Use subtotal and database functions to calculate

3. Visualising data with charts
Create charts
Modify and format charts
Create a trend line
Create advanced charts

4. Inserting graphics
Insert and edit graphics
Layer and group graphics
Add and edit SmartArt

5. Enhancing workbooks
Customise workbooks
Manage themes
Create and use templates
Protect files
Preparing a workbook for multiple audiences

6. Auditing worksheets
Trace cells
Invalid data and formula errors
Evaluate and monitor formulas
Create a data list outline

7. Multiple workbooks
Consolidate data
Link cells in different workbooks
Merge workbooks
Managing large workbooks
Format and rename worksheet tabs
Edit and monitor worksheets

Ms Office Excel Intermediate 2013 Sat Training Course Course: Course Duration

1 day/s

Who should attend: Ms Office Excel Intermediate 2013 Sat Training Course Course

This course is intended for intermediate users of Microsoft Excel.

**Quote does not include Any Exam Fees (if applicable)

IMPORTANT ACTION: Do Not Wait To Improve Your Skills.  

Book Now By Completing Online Booking Form / Customised Proposal or Obtain Approval For Your Already Received Customised Proposal