Microsoft Excel
Part 2

Contact Us
Feed Back Form
E-Mail Us

Tel:
024 7637 2073

To return to the Microsoft Excel Course Index please Click Here

A.K.Solutions: Microsoft Excel Part 2 Course Content
Auto fill / Custom Lists / Auto formula / Styles / Charts / Lookup formula / Range names in formulae / Pivot reports / Macros / Database tables / Data sorts / Data entry forms / Conditional logic / Date calculations / Nesting functions.

• Data entry shortcuts

  • Proper use of ranges and the Active Cell

  • Navigating ranges during data entry

• Use of Autofill

  • Numbers, Text and Dates

  • Custom Lists

• Useful tips with Autosum

  • Summing up Rows and Columns simultaneously

  • Extending ranges with keyboard controls

• Table formatting shortcuts

  • Use of an Autoform

  • Preventing an Autoform overwriting existing formatting

• Formatting Styles

  • What are they?

  • Setting up a style

  • Modfying a style

  • Using a saved style elsewhere in the workbook

• Creating Charts and Modifying their properties

  • Changing the data series

  • Modifying the 3D view of charts

  • Drawing your own graphics

  • Adding Text / Labels / Values

  • Editing a Chart

  • Formatting / Changing Colours

  • Resizing / Moving / Copying

• Lookup tables

  • Hlookup versus Vlookup

  • Using named Ranges within formulae

  • Exercises using lookup tables

  • Setting the nearest match argument

  • Order of data in a lookup table

• Pivot Reports

  • Creating a Pivot Report

  • Rules for creating

  • Setting up the layout

  • Modifying a layout

  • Recalculating / refreshing a pivot report

  • Setting up multiple pivot reports

• Macros, an introduction

  • What is a Macro

  • Recording a Macro

  • Why is it a good idea to learn some VBA?

  • Limitations to modifications possible without VBA knowledge

• Database tables

  • Data Forms / Search Criteria

  • Data Sorts

  • Conditional Logic formulae

  • More on Date Calculations

You may print this page by selecting File Print in your Browser Window

Before taking this course.  All candidates are advised to have a good working knowledge of Excel basics such as having an understanding of Functions and Formulae which are covered in  Microsoft Excel Part 1

To contact A.K.Solutions:- enquiries@aksolutions.co.uk

E-Mail Us

Contact Us
Feed Back Form

Tel:
024 7637 2073

Copyright © 1994 - 2006 A.K.Solutions. All rights reserved.   Revised: January 13, 2006.