Computer Tutoring Logo

Cost Calculator

Training delivery
Number of students?
Laptop hire?
Offsite training?

Course price: £ *
Price per head:
£ .

Duration:
1 Day

* Price is exclusive of VAT.

Tell Me More

Live online Face to face
First name:

Last name:

Email:

Tel:

Location:

Number of students:
First NumberPlusSecond Number  = 

Please enter the answer to prove that you are human and not a machine.
I would like to receive software tips and special offers

Testimonials

Handelsbanken

I am very impressed with the training. My access skills are very much self taught and I was unsure about whether the level of the course would be right. The training was delivered in a really clear manner and at the right pace. Thank you very much to Richard for the course. I would thoroughly recommend it.

Blaby District Council

"I found the training session really interesting as I use Access daily and had no idea on how much it actually can do. Simon is a fantastic trainer and takes his time explaining all the background so you get to understand better, he is thorough and has the patience of a saint. I would highly recommend anyone considering this training to consider going booking Simon and his team."

British Antarctic Survey

"Our bespoke training was really good and invaluable. We learnt a great deal about Microsoft Access and databasing techniques. Both aspects are so important to our work. Simon, our trainer, was a real expert and he made the two days interesting and enjoyable. Thank you so much"

Pepsico

"Only a small group so really great training interaction. Well prepared and friendly, made what could of been a slightly dull topic enjoyable."

"Very good. I have never used Access before but feel confident that I will be able to set up and manage databases going forward."

Microsoft Access 2010 Training Course Advanced Leicester

Leicester Advanced Microsoft Access 2010 Course Overview

Advanced Microsoft Access 2010 Training Course training course Leicester

Leicester boasts a multicultural atmosphere and is famous for its association with King Richard III.

1st Floor, Gateway House
Grove Business Park
Enderby
Leicester
LE19 1SY
United Kingdom

The centre at Grove Park is conveniently located immediately off the junction with the M1 and M69 Motorways. The central location provides an ideal base for not just Leicester companies but also national businesses looking for an accessible UK base. Leicester City Centre is a 10 minute drive and the motorways are less than 5 minutes away. A great venue for your Advanced Microsoft Access 2010 Training Course.

Alternatively if you live in and around Leicester and wish to have your training on-site the we can provide all the equipment, included laptops and projector, required. All we ask is that you provide a little space for the trainer to set up.

There are many other computer training courses in Leicester. Please take the time to look through them.

Course Duration: 1 Day

Complete Course Outline

Getting Around Excel 2013

  • The Ribbon
  • Quick Access Toolbar
  • Galleries
  • Dialog Box Launcher (Back to 2003)
  • Using Help
  • Rows, Columns & Cells
  • The Formula Bar
  • Button Drop Down Lists
  • The Cell Reference Box
  • Context Tabs & Menus (Mini Toolbar)

File Management - finding files and fast

  • Creating a New File
  • Using Built-in Templates
  • Opening & Closing a Workbook
  • Saving a Workbook
  • Recent Workbooks & Places

Entering Information

  • Entering Data including the correct entry method for dates
  • Selecting Data
  • Adjusting Column Width & Row Height
  • Using Auto fill
  • Copy and Pasting Data
  • Moving Quickly around a Work Sheet (Using Keyboard)
  • Inserting, Deleting Rows & Columns
  • Find & Replace
  • Spell Checker

Microsoft Excel Formulas

  • Simple Excel Formulas
  • Using Cell References
  • Operator Preference
  • Functions
  • Linking Between Worksheets
  • Linking Between Workbooks
  • Basic Error Checking
  • Change Calculation Options

Formatting let's get our sheets looking smart

  • Formatting Numbers
  • Font Size & Colour
  • Fill Colour
  • Borders
  • Cell Alignment
  • Text Wrapping
  • Cell Styles
  • The Decimal Point
  • Format Painter

Printing

  • Choosing what to print
  • Margins
  • Selecting the print area
  • Printing a large spread sheet give you control over your pages

Working with Different Views

  • Zooming In & Out
  • Split View
  • Freeze Panes
  • View Side by Side
  • Page Layout View
  • Page Break Preview
  • Gridlines, Headings & Formula Bar
  • Add Custom Views