Course Content

◊ Understanding The Excel Window.
◊ Performing Calculations With Functions And Formulas
◊ Calling On Help.
◊ Opening& Navigating Through A Worksheet.
◊ Creating, Saving And Printing Worksheets.
◊ Editing A Worksheet.
◊ Changing The Look Of A Worksheet.
◊ Formatting And Manipulating Data.
◊ Quick Data Entry Techniques. ◊ Introduction To Graphs

Course Outline

This course focuses on quick ways to get started with Microsoft Excel. Packed with shortcuts and useful exercises the tutor guide’s delegates from a standing start through formulas and functions. Upon course completion you will have an appreciation of the layout and structure of the Microsoft Excel screen, gain a complete understanding of ‘quick’ editing techniques for data entry and filling formulas, seen how to create worksheets to compile sales figures, create purchase orders, bank statements and petty cash analysis. How to enhance those worksheets giving them a professional finish.

Who Should Attend

This course is suitable for complete beginners to Excel and also because of the ‘quick tips’ for anyone who is self-taught.

Duration

1 Day (Usually 9.15 for 9.30 Start to 4.30)

Course Content

◊ Lookup Functions
◊ Data Tables
◊ Database Features
◊ Review Of Excel Fundamentals,
◊ Building 3 Dimensional Worksheets,
◊ Worksheet Templates.◊ Protection& Security,
◊ Grouping Worksheets,
◊ Introduction To The ‘If’ Function.
◊ Group And Outline Functions,
◊ Building Graphs And Using Trend Line

Course Outline

Building on your existing knowledge of Excel this course includes formulas that link worksheets together and linking workbooks. Getting Excel to make decisions using the ‘If’ function and conditional formatting, You’ll learn how to create templates for commonly used worksheets and protect data using the security features. You will gain an insight into data tables and using excel look up features to automate worksheets. This course will also enable you to create, build and customise graphs including plotting trend lines

Who Should Attend

This course is suitable people who have attended the Introduction course or have sufficient knowledge and understanding of the basics of Excel

Duration

1 Day (Usually 9.15 for 9.30 Start to 4.30)

Course Content

◊ Pivot Tables
◊ Macros
◊ Advanced ‘If’ Statements.
◊ Count Functions,
◊ Data Consolidation,
◊ Goal Seeking.
◊ Data Projection Using ‘What If’ Scenarios,
◊ Data Tables,
◊ Database Advanced Filters.
◊ Using Outlining To Handle Large Worksheets,
◊ Importing Data
◊ Configuring Web Queries

Course Outline

This course focuses on advanced methods of data management. You will learn how to summarise large workbooks, use analysis tools to forecast figures based on a range of scenarios and use consolidation to bring together information. You will gain a complete understanding of the database features. Learn how to apply filters and sort data into key elements. Find out how you can utilise advanced ‘If’ statements and macros to automate repetitive or tedious tasks.

Who Should Attend

This course is suitable people who have attended the Intermediate course or have good knowledge and understanding of Excel

Duration

2 Day (Usually 9.15 for 9.30 Start to 4.30) Note: One Day Version is Also Available

Duration

if you...

- Are self trained on Excel so far
- Not Sure which level would suit
- Have a number of delegates with varying knowledge
- Need a more flexible solution....

We can advise you on all the topics available in Excel and where you might use them. You can then make an informed decision as to which topics are relative to your organisation.

Usually a few simple questions will determine the level that each delegate is at but it is always possible on the day to adjust or fine tune this. Refresher or booster sessions can be utilised to bring delegates to a point where they can attend a more advanced level.

The best way is to contact us for a free consultation where we can point you in the right direction.