Excel Advanced (£55) - Intermediary (£44) - Beginner (£33) - Training

£55.00
Qty

Once you have discussed your learning requirements with your Microsoft Office trainer please select your Availability when making your booking here from the Select Option tab below. More information can be found under the Course Locations tab below. If you have a question or a query, call us today. We're here to help.

We only recruit educators who have a teaching qualification and a degree in their subject specialism and who have the necessary skills and experience in delivering lessons to learners on regular basis.

We have stringent recruitment policy in place for our teachers' vacancies. We check and verify each teacher's credentials and interview them personally in stages before they can join our teaching team. Our teachers are fully qualified, highly experienced and specialised in helping people of all ages to reach their full potential.

Customers may request details of our educators prior to engaging our services.

We provide our customers with a free trial lesson. Book your free trial lesson to see how you get on with your teacher. And if you are not satisfied with our teachers, we will refund your booking fees.

Course Title: Excel Advanced Training (Go at your own pace)

Version: Designed for Excel 365, 2019, 2016, 2013 & 2010

Course Level: Level 3

Teaching Method: Online Tutoring using Cisco Webex as our online tutoring platform.

Hours: 1 hour

Tutor's Rate: £50 per hour

Service Fees: We charge customers a service fees of 10% percent for our services.

Who is this course for?
Our Excel advanced training course is for those with a good working knowledge of Excel spreadsheets and who want to progress to using the advanced features and functions within Excel.

Prerequisites An intermediary working knowledge of Excel is required. We are not responsible if you are unable to follow or benefit from the training if you do not have sufficient command of Excel.

Benefits
You will be able to consolidate your IT skills using Excel advance features and functions.

Helpful Tips
To benefit from our Excel advanced training course, learners must have good working knowledge in these intermediary areas;

  • Have a good understanding of spreadsheet structure and its components for example, cells, rows, columns, tabs, pages, charts, ranges, workbooks, worksheets, design and layout.
  • Able to enter and edit data for example inserting data into single and multiple cells, clearing cells, editing cell contents, replicating data, using find and replace, add and delete rows and columns; using absolute and relative cell references, adding data to a chart.
  • Understand numerical and other information such as numbers, charts, graphs, text, images
  • Able to store and retrieve data for example Save, save as, find, open, close, open CSV file in spreadsheet application, save spreadsheet file as CSV; templates.
  • Able to analyse and manipulate data for example, totals, sub-totals and summary data; sort and display order; lists, tables, graphs and charts; filter rows and columns.
  • Able to use Functions and Formulas for example Brackets, AUTOSUM, Count, Average and Round, Maximum and Minimum, and IF.
  • Able to Format cells for example numbers, currency, percentages, number of decimal places, font and alignment, shading and borders, date and time formats, and wrap text.
  • Able to Format rows and columns, height, width, borders and shading, hide, and freeze.
  • Able to Format charts and graphs and create chart type such as pie chart, bar chart, single line graph, area, column, x-y scatter, stock, radar, doughnut, surface and able to enter title, axis titles, legend, and change chart type, move and resize chart.
  • Able to use Page layout, for example size, orientation, margins, header and footer, page breaks, page numbers, date and time and adjust page set up for printing.
  • Able to check spreadsheet information for example accuracy of numbers, formulas and any text, accuracy of results, suitability of charts and graphs, reveal formulae, layout and formatting, validity and accuracy of analysis and clarity of overall spreadsheet.

We can help you with EXCEL at beginner or intermediary level, call us today and discuss your learning needs. We're to help.

Course Title: Excel Intermediary Training (Go at your own pace)

Version: Designed for Excel 365, 2019, 2016, 2013 & 2010

Course Level: Level 2

Teaching Method: Online Tutoring using Cisco Webex as our online tutoring platform.

Hours: 1 hour

Tutor's Rate: £40 per hour

Service Fees: We charge customers a service fees of 10% percent for our services.

If you have a question or a query, call us today. We're here to help.

Course Title: Excel Beginner's Training (Go at your own pace)

Version: Designed for Excel 365, 2019, 2016, 2013 & 2010

Course Level: Level 1

Teaching Method: Online Tutoring using Cisco Webex as our online tutoring platform.

Hours: 1 hour

Tutor Rate: £30 per hour

Service Fees: We charge customers a service fees of 10% percent for our services.

Payment Methods:

  • Credit or Debit Card
  • Email PayByLink (Invoiced Payment)
  • Telephone
  • Bank Transfer

If you have a question or a query, call us today. We're here to help.

Course Syllabus

Subject areas covered:
1. Formulas
2. Functions
3. PivotTables
4. Charts
5. Data Tables
6. Macros
7. Auditing
8. Tracking Changes

Module: Formulas

  • Display Formulas
  • Formulas that Produce Errors
  • Mixed Referencing
  • Custom Number Formats

Module: Functions

  • Date and Time Functions
  • LOOKUP Functions
  • Mathematical Functions
  • Statistical Functions
  • Text Functions
  • Financial Functions
  • Database Functions
  • Nested Functions

Module: PIVOT TABLES and PIVOT CHARTS

  • Using a PivotTABLE
  • Filtering a PivotTABLE
  • Grouping in PivotTABLES
  • Sorting in PivotTABLES
  • Creating a PivotCHART
  • Formatting a PivotCHART
  • Slicers
  • Timeline

Module: Data Tables

  • One Input Data Table
  • Two Input Data Table

Module: Macros

  • Using Macros
  • Recording a Macro
  • Running a Macro
  • Assigning a Macro to the Quick Access Toolbar

Module: Auditing

  • Tracking Precedents
  • Tracing Dependents
  • Tracing Errors
  • Data Validating

Module: Tracking Changes

  • Tracking Changes in a Worksheet
  • Shared Workbooks
  • Merging Workbooks

Course Delivery Location: Our online tutorial services are delivered using Cisco Webex as our virtual training platform and you can start learning in the comfort of your home without the need to travel.

If you have a question or a query, call us today. We're here to help.

David is a good mobile phone tutor, I learned a lot and now am confident in using what's app and skype, I am able to speak to my niece in Australia, which gives me so much pleasure.

Joan, Harrow

Excellent professional service for you to achieve results.

Cindy Mart, Sudbury

Customised Curriculum Ltd offers value for money, very happy with their services.

DR GOVINDA RAMDAS, Hampstead

Professional tutoring agency!

Michael, Harrow

Very good teaching agency with good teachers and resources provided. Reasonable rates, Highly recommended.

JC Chou, Stanmore