Excel

Microsoft Excel is a spreadsheet programme and part of Microsoft Office. It is the industry standard programme used for spreadsheets. Using this programme you can create tables of information and values. The rows and columns can then be manipulated using equations, macros and formulas.

As well as the standard spreadsheet functions, Excel can also create graphs and charts using the information entered. It is used for statistical, engineering and financial needs amongst many other things. We provide Excel training courses at all levels in Bedfordshire, Buckinghamshire & Hertfordshire.

Courses Provided

0
0
0
0

Duration 1 day

£195

Group Booking Calculator

Course Microsoft Excel 2013 Level 1 – Introduction
Duration 1 day
Original Price Per Delegate 195
Number of Delegates
Discounted Price Per Delegate 195
Total Cost 195
Total Saving 0

COURSE OBJECTIVES:

At the end of this course, delegates will have an understanding of basic design techniques and layout of a spreadsheet table.

  • Identify basic worksheet and workbook concepts and terms
  • Enter & edit data
  • Modify the worksheet
  • Use functions to calculate and return values
  • Format cells to enhance the appearance of your worksheet
  • Use drawing features and other enhancements
  • Change the page set-up to define how the printed worksheet appears

WHO SHOULD ATTEND:
People who intend to create spreadsheets from scratch or improve existing spreadsheets.

EXPERIENCE NEEDED:
Delegates should have an understanding of any of the following operating systems: Windows VISTA, 7 and 8.  They should also be able to understand some basic maths.

COURSE CONTENTS:

1. Excel essentials

2. Formatting text & printing a document

3. Managing the worksheet

4. Formating the worksheet

5. Printing the worksheet/book

Duration 1 day

£195

Group Booking Calculator

Course Microsoft Excel 2013 Level 2 – Intermediate
Duration 1 day
Original Price Per Delegate 195
Number of Delegates
Discounted Price Per Delegate 195
Total Cost 195
Total Saving 0

COURSE OBJECTIVES:

At the end of this course, delegates will have advanced their knowledge of working with Spreadsheets.

  • Using multiple worksheets, workbooks and workspaces
  • Working with financial functions
  • Use advanced formatting techniques
  • Using the auditing tools to track information
  • Using charts to display financial data

WHO SHOULD ATTEND:
This course takes users to a high level of knowledge using financial topics available in Excel such as Financial functions, auditing and Charts.

EXPERIENCE NEEDED:
Delegates should have an understanding of any of the following operating systems: Windows VISTA, 7 and 8 or above. Delegates should have a good understanding of Microsoft Excel or alternatively should have attended our Introduction course.

COURSE CONTENTS:

1.  Using multiple worksheets and workbooks

2.  Charting

3.  Advanced functions

4.  Advanced formatting

Duration 1 day

£195

Group Booking Calculator

Course Microsoft Excel 2013 Level 2 – Intermediate
Duration 1 day
Original Price Per Delegate 195
Number of Delegates
Discounted Price Per Delegate 195
Total Cost 195
Total Saving 0

COURSE OBJECTIVES:

At the end of this course, delegates will have advanced their knowledge of working with Spreadsheets.

  • Creating, Maintaining, Filtering and using Subtotals in a List
  • Recording, Assigning and Using Macros
  • Creating and Using User Defined Functions
  • Performing “What If” Analyses
  • Working with Scenarios
  • Querying a Database
  • Importing and Exporting Files and Data
  • Protecting Data
  • Pivot Tables, Reports and Charts.
  • Other Advanced Business Analysis Tools

WHO SHOULD ATTEND:
This course takes users to a high level of knowledge using financial topics available in Excel such as Financial functions, auditing and Charts.

EXPERIENCE NEEDED:
Delegates should have a good understanding of Microsoft Excel or alternatively should have attended our Intermediate course.

COURSE CONTENTS:

1.Working with lists

2.Working with macros and user defined functions

3.Using basic analysis tools

4.Using advanced tnalysis Tools and external data

5.Using business analysis tools

Duration 2 day

£450

Group Booking Calculator

Course Microsoft Excel 2013 – Additional
Duration 2 days
Original Price Per Delegate 450
Number of Delegates
Discounted Price Per Delegate 450
Total Cost 450
Total Saving 0

COURSE OBJECTIVES:

At the end of this course, delegates will learn how to use macros to automate processes and also be able to edit macros.

  • Record / run macros
  • Write code manually
  • Perform loops, controls and error handling
  • Create UDF functions and add-ins
  • Create user forms and sheet controls
  • Use events

WHO SHOULD ATTEND:
Excel users who, at intermediate or advanced level, want to learn how to speed up and automate their work (or other users’ work) in the application using macros.

EXPERIENCE NEEDED:
Delegates should have a good grounding in Excel (any version) and be familiar with absolute verses relative cell referencing, functions and formula syntax and sheet linking. Familiarity with the macro recorder would be an advantage.

COURSE CONTENTS:

1.  Introduction and the Macro Recorder

2.  Objects and dialog boxes

3.  Creating and editing macros with VBA

4.  Introduction to controls

Sun Mon Tue Wed Thu Fri Sat
1
Away
Away
Aug 29 – Sep 4 all-day
 
2
3
4
Busy
Busy
Sep 4 all-day
 
5
Busy 7:30 am
Busy
Sep 5 @ 7:30 am – 6:00 pm
 
6
Busy 7:00 am
Busy
Sep 6 @ 7:00 am – 6:00 pm
 
7
Busy 7:00 am
Busy
Sep 7 @ 7:00 am – 6:00 pm
 
8
Busy 10:00 am
Busy
Sep 8 @ 10:00 am – 11:00 am
 
9
10
11
Busy 7:30 am
Busy
Sep 11 @ 7:30 am – 6:00 pm
 
12
Busy 10:00 am
Busy
Sep 12 @ 10:00 am – 11:00 am
 
13
Busy 7:30 am
Busy
Sep 13 @ 7:30 am – 5:30 pm
 
Busy 3:30 pm
Busy
Sep 13 @ 3:30 pm – 4:30 pm
 
14
Busy 7:30 am
Busy
Sep 14 @ 7:30 am – 6:00 pm
 
15
Busy 7:30 am
Busy
Sep 15 @ 7:30 am – 6:00 pm
 
16
Busy 3:30 am
Busy
Sep 16 @ 3:30 am – 4:00 am
 
17
Busy 6:30 pm
Busy
Sep 17 @ 6:30 pm – 7:00 pm
 
18
Busy 8:30 am
Busy
Sep 18 @ 8:30 am – 5:00 pm
 
19
Busy 8:30 am
Busy
Sep 19 @ 8:30 am – 5:00 pm
 
20
Busy 7:00 am
Busy
Sep 20 @ 7:00 am – 6:00 pm
 
21
Busy 7:30 am
Busy
Sep 21 @ 7:30 am – 6:00 pm
 
22
Busy 7:00 am
Busy
Sep 22 @ 7:00 am – 6:00 pm
 
23
24
25
Busy 12:00 am
Busy
Sep 25 @ 12:00 am – Sep 29 @ 11:59 pm
 
26
27
28
Tentative 7:30 am
Tentative
Sep 28 @ 7:30 am – 6:00 pm
 
29
30

Use the calendar to see booking availability. Please advise us of any preferred dates (preferably 2 weeks notice) in the message if you have one.

Your Name (required)

Your Email (required)

Subject

Your Message

Contact KITT Consultancy today for a professional, no-obligation audit and see how we can help make your Microsoft Office applications work better for you.

prince2
mos
mcp
LPI
fsb
bcc
Logo12