A.K.Solutions:- Microsoft Excel Part 1

Tel:
024 7637 2073

To return to the Microsoft Excel Course Index please Click Here

A.K.Solutions: Microsoft Excel Part 1 Course Content
More than just a beginners course!
Designing a Workbook from scratch. Functions and Formulae. Absolute and Relative addressing. Multiple Worksheets, cross referencing formulae, numerous Tips and Tricks. Cell protection. Documenting formulae. Printing.

Introduction
- The Excel workspace
- Navigating the Workbook window
- Navigation tips within a Worksheet
- The formula bar
- Timesaving Tips and Tricks
- Cut / Copy and Paste shortcuts
- Working with Ranges
Formulae
- Examples of formulae
- Absolute and Relative Addressing
- Rules of BODMAS
- Date calculations
- Formatting results
- Use of formatting placeholders
Designing a Worksheet
- Naming the Worksheet
- Designing an Income Expenditure Worksheet
- Formatting the worksheet
- Testing the formulae
- Calculating percentages
Functions
- Using Excel Functions to simplify formulae
- How to find the function you require
- Use of Auto functions
Designing a Workbook
- Inserting / Naming / Copying / Moving / Deleting / Worksheets
- Use of multiple Worksheets
- Cross-referencing formulae
More on Formatting
- Setting Row and Column heights / widths
- Centering titles across multiple cells
- Use of Custom formatting
- Borders and Shading
- Aligning data in cells
And there's more
- Documenting formulae
- Setting up and Printing individual Worksheets
- Protecting Individual Cells / Worksheets / Workbooks

All is explained in an easy to understand way

By the end of the day you will have a good working knowledge of Microsoft Excel.

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

All candidates are advised to have a good working knowledge of Windows Part 1 before taking this course. For example a candidate should know how to Save / Retrieve documents and have basic Mouse / Keyboard skills.

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

E-Mail Us

Tel:
024 7637 2073