Telephone: 0208 942 5724
Email: info@aspecttraining.co.uk
Open: 09:00a.m. to 17:30p.m. Monday to Friday

Microsoft Excel Introduction/Intermediate

Duration: 2 Days

Overview:

Over the years, the king of all spreadsheet programs has grown from a fairly simple calculator into an application with the ability to perform highly complex operations. The problem for most is figuring out where to start and how each of the functions can be used. Books are great reference tools if you already know what you're looking for, but Aspect Training’s Excel training courses are where you'll really grasp the full potential of Excel quickly. With Aspect Training’s Microsoft Excel Introduction / Intermediate, you can acquire a working knowledge with just two days of Excel training.

Of course it takes more than two days of Excel training to get a complete understanding of this powerful program. This course will give you the platform on which to build your skills and lead to greater efficiency and productivity with Microsoft Excel

Many of today's managers require that new employees have some level of Excel training. If you're in the job market, Excel training is a C.V. line item you'll want to obtain. Courses are fast, inexpensive and can drastically increase your opportunities. The job market is fiercer today than ever and earning the position you desire means taking a proactive approach to skill building.

Prerequisites:

Delegates should have a familiarity with Microsoft Windows

Course Topics:

Excel Basics

Spreadsheet Terminology
Exploring the Excel Window
Opening and Navigating a Workbook
Closing a Workbook

Entering And Editing Data

Creating a New Excel Workbook
Entering and Editing Labels and Values
Entering and Editing Formulas
Saving and Updating A Workbook

Printing

Preparing To Print
Page Set up Options

Modifying A Worksheet

Moving a Copying Data
Moving and Copying Formulas
Using Absolute References
Inserting and Deleting Ranges

Using Functions

Entering Functions
Using Autosum
Using AVERAGE, MIN, MAX, and COUNT

Formatting Worksheets

Formatting Text
Formatting Rows and Columns
Number Formatting
Other Formatting Features

Creating Charts

Creating a Chart
Printing Charts

Web Features

Saving a Worksheet as a Web Page
Adding Hyperlinks
Sending a Workbook via Email

Using financial functions

Using the PMT and FV functions
Setting up a financial analysis table

Using logical functions

Using the IF and nesting IF functions

Using date/time functions

Using the DATE and NOW functions

Using lookup functions

Using the VLOOKUP and HLOOKUP functions

Linking worksheets within a workbook

Setting up related worksheets within a workbook
Moving the cell pointer from one worksheet to another
Copying data from one worksheet to another; editing the data
Entering a formula to link related worksheets
Formatting multiple worksheets in one operation
Moving and copying worksheets
Previewing and printing multiple worksheets in one operation

Linking multiple workbooks

Entering a formula to link multiple workbooks
Creating a workspace

Using Excel Internet features

Accessing the internet from Excel
Linking an Excel workbook to a web page, saving Excel data as a web page

Additional data entry and formatting techniques

Restricting cell entries to specific numbers, dates, times or entries in a list
Applying number formats to cell entries
Creating a custom number format
Applying conditional formatting to a worksheet

Working with a template

Creating a template; modifying the default template style
Basing a new workbook on a custom template

Auditing a worksheet

Tracing precedents, dependents and errors in a worksheet

Working with a database

What is a database?
Totalling database entries, filtering and sorting database records
Specifying a criteria range in a filter operation
Using a data form to enter database records
Querying an external database

Analysing data (Part 1)

Creating a pivot table report
Resetting a summary function in a pivot table report
Creating a pivot chart report, creating a pivot table report for the internet

Analysing data (Part 2)

Using the solver, outlining a worksheet
Additional data analysis topics

Importing and exporting data

Importing a text file into Excel
Importing an HTML file into Excel
Exporting Excel data into other applications

Using Excel workgroup features

Tracking changes and inserting comments in a worksheet
Accepting and rejecting proposed changes/reviewing comments
Protecting a shared or unshared workbook
Additional workgroup topics


Click Here for printer friendly version of outline

Ring 0208 942 5724 if you require further details or would like to book a training course

Aspect Training, 20 Coombe Road, New Malden, Surrey, KT3 4QE

© 2013 Aspect Training