Microsoft Excel Intermediate Training Course - 1 day (Instructor-led lessons) for employers and staff

Minimum Quantity: 6

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.

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

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

Who is this training for?
Our Microsoft Excel course is suitable for those users who have a basic working knowledge of Excel spreadsheets, and want to acquire further knowledge to consolidate their skills and have a greater understanding of utilising the relevant features and functions within Microsoft Excel.

Prerequisites A basic working knowledge of Microsoft Excel is required.

At the end of this course, you will acquire further knowledge on Microsoft Excel, you will be able to use the relevant features and functions within Excel.
You will have the ability to use it's more sophisticated tools, which will allow you to complete your tasks and analyse your data more quickly.
You will be able to gather, structure & present data so that it looks impressive, polished and professional.

  • Handle Small and Big Data Better with Excel.
  • Having Advanced Excel Knowledge Increases Employee Value.

What will you learn on this Excel Intermediate Training Course?

1. Working with Large Worksheets
2. Working with Multiple Worksheets and Workbooks
3. Working with dates
4. Conditional formulas and formatting
5. List Management
6. Documenting and Auditing
7. Using Templates

Subject areas covered are listed in detailed in the Curriculum tab above.

Course Level: Level 2

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

Course Duration: 1 day (Instructor-led lessons)

Classroom Size: 6 candidates

Teaching Hours
Monday to Friday - 9:30am to 5pm
Saturday and Sunday - 10:30am to 6pm

  • We will tailor our courses to suit your availability.
  • Further options on course schedule and availability are listed in the Select Option tab above.
  • We will provide you with a structured lesson plan, course exercises, tutor notes and helpful tips.

Price: £150.00 per person (To provide a quality service, we've limited the classroom size to 6 candidates).

Ordering services from our website and how it works?

Once you have discussed your learning requirements and your availability with you teacher and you are ready to start learning, you will need to book your training session(s) here.

In the Select Option... tab above, you will find our course schedule list, choose your course schedule by clicking on it, enter the numbers of candidates enrolled for example 6 in the Hrs text box, you will then need to click on ADD TO BASKET button on the right-hand side.

You will now need to complete your billing detail(s), all the boxes with asterisk * will need to be completed or your booking form will not be processed and once you have completed your billing detail(s) you will need to tick the box to accept our terms and conditions else your checkout will not be processed. The other box is optional (mailing list, latest news and offers).

Once you have click CHECKOUT NOW! :

Our payment gateway "WORLDPAY" will then process your transaction and if successful you will receive an email of the confirmation of the transaction and invoice of service(s) purchased.

If you face any issues, call us on 020 8907 5522 and we will walk you through it.

We are available from 9am to 9pm (Monday to Friday).

Payment Methods:

  • Credit or Debit Card
  • Email PayByLink (Invoiced Payment)

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

Additional Information:

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.

Services: Online classes, On-site group training, Home tuition.

Course Syllabus

Subject areas covered:
1. Working with Large Worksheets
2. Working with Multiple Worksheets and Workbooks
3. Working with dates
4. Conditional formulas and formatting
5. List Management
6. Documenting and Auditing
7. Using Templates

Module: Working with Large Worksheets

  • Viewing options
  • Adjusting zoom
  • Using Freeze Panes
  • Using Split Window
  • Hiding and displaying data
  • Hiding rows and columns
  • Creating an outline
  • Printing large worksheets
  • Page Break preview
  • Working with page breaks
  • Printing multiple sheets

Module: Working with Multiple Worksheets and Workbooks

  • Using multiple worksheets
  • Navigating between sheets
  • Moving and copying sheets
  • Linking worksheets
  • Creating 3-D formulas
  • Consolidating data
  • Linking workbooks
  • Creating a formula to link workbooks
  • Using the Paste Link option
  • Maintaining links

Module: Working with dates
Entering date functions
TODAY function
NOW function
Date and time formats
Using dates in formulas

Module: Conditional formulas and formatting

  • The IF function
  • Conditional formatting
  • Based on a cell value
  • Based on a formula
  • Identifying cells with conditional formatting
  • Copying conditional formats

Module: List Management

  • Working with lists
  • Structure of a list
  • Sorting and filtering lists
  • Simple sorting
  • Sorting by multiple columns
  • Using AutoFilter
  • Advanced filtering
  • Using custom filter
  • Using Advanced Filter
  • Adding subtotals to a list

Module: Documenting and Auditing

  • Comments
  • Viewing, adding, editing and deleting comments
  • Auditing features
  • Tracing formula errors
  • Protection
  • Protecting a worksheet
  • Protecting cell ranges

Module: Using Templates

  • Using Built-in templates
  • Accessing and using Excel's templates
  • Creating and managing templates
  • Creating, using and modifying a custom template file

Helpful Tips
To benefit from our Excel intermediate training, learners must have good working knowledge in these basic areas;

  • Understand Spreadsheet and its component for example cells, rows, columns, tabs, pages, charts) and their layout.
  • Able to enter data into existing spreadsheet, create new spreadsheet, insert information into single cells, clear cells, edit cell contents, replicate data, find and replace, add and delete rows and columns.
  • Able to store and retrieve files and use Save, Save As, Find, Open and Close commands.
  • Able to summarise and interpret information for example totals and summary information, sorting and display order, lists, tables, graphs and charts.
  • Able to use Formulas to add, subtract, divide and multiply using simple arithmetic formulas.
  • Able to use common Functions such as Sum, Average and Round to meet calculation requirements.
  • Able to use Format Cells for numbers, currency, percentages, number of decimal places, font and alignment, borders and shading.
  • Able to use Format Rows and Columns to adjust height, width, borders and shading.
  • Able to use different chart or graph for example pie chart, bar chart or single line graph.
  • Able to Format charts and graphs for example title, chart type, axis titles, and legend.
  • Able to use Page Layout for size, orientation, margins, page numbers, date and time.
  • Able to check spreadsheet information for accuracy of numbers, formulas and any text, accuracy of results and suitability of charts and graphs.

Services: Remote Learning, Online Classes, On-site Group Training.

Course Delivery Location: Our online tutorial services are delivered using Cisco or Zoom 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.

I pass my first course in accounting and really looking forward for the next one. My teacher Swapnil was very helpful and knowledgeable, ready to answer questions and help with technical difficulty. Really recommend this service for comprehensive courses.

Alexandra Abd-Allah, Google Review, Brent

Took this 5 week Bookkeeping course and learned a lot in that time. The teacher I had named Mr. Swapnil was very good with his teaching. He explained the work in a way that was easy to understand. I definitely recommend.

Maureen Broadbelt, Google Review, Hammersmith

My experience with the book keeping course was a really great one it was easy to follow, the pace was brilliant for learning, I can not complain about anything I mean even the tutor swapnil ararat nati was great down to earth, very understanding, with personal situations that made logging…

Rose Keal, Google Review, Ealing

The trainer Swapnil ararat nati was really down to earth and understanding and presented the accounting course really well in a that was easy to follow

Snakehunteryami Keal, Google Review, Ealing

Great course, I gained a lot of real life skills and have a genuine understanding of what was covered. The course structure is very easy to follow with every session downloadable. The class leader Swapnil Arafat was an immense help. His understanding was great so really helps you…

SAMUEL GHEBREMESKEL, Google Review, Barnet

These guys are brilliant, they go the extra mile to assist you to get a qualification or a job.

Delroy, Harlesden

Completed my Ascentis qualification at Level 2 for 10 units, Angela has been brilliant.

Vivian, Willesden Green

Gregory is a very good biology and physics teacher for GCSE and A Level students.

JH Cai, Hackney

Booked some biology revision lessons for my son to prepare him for his GCSE biology examination, Greg has been a wonderful teacher, my son enjoyed his revision lessons. Thank you Gregory!

Stephenie, Oval

I needed help with my smartphone and they organised a trainer who was patient with me and helped me understand the many bells and whistle on my smartphone. After a couple of lessons I am able to use my smartphone with confidence.

Linda, Google Review

Excellent tuition agency with good maths teacher.

Daniza Lindeman, Google Review

I had Microsoft Excel and Word course and i enjoyed a lot. The tutor was very professional and addressed every details which i required for my job. I can not thank enough. Keep up the great job

Lina Hasmucrai, Google Review

Customised Curriculum Ltd are a great company for beginners to gain IT skills and progress within the tech industry. They provide excellent support and resources for anyone who want to learn mobile applications on IOS and Android.

Paras Shah, London

I wanted to learn a little about computer programming, just the basics. CC were absolutely wonderful. My tutor was patient, fun and, above all, extremely knowledgeable and professional. I have no hesitation in recommending this company, and look forward to using them again in the very near future.

Jim Morrissey, Google Review

Great professional tutors for science and maths! Everything is smooth and swift from booking and communication. Highly recommended for anyone wanting to tutor their children.

Priteshb, Google Review

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

JC Chou, Stanmore

Our organisation used Customised Curriculum to improve our staff's IT skills in using Excel spreadsheet. We were provided with a professional trainer, resources and support.

Ameet Radia, Simpson Reid Property Consultants, Google Review

We had to persevere as no maths tutors were available to provide home tuition because of the pandemic and they organise online maths tuition for my daughter and she is happy. Thank you.

Ashok Varma, Kingsbury

Booked Maths GCSE & A level lessons for my daughters. Excellent tuition and support. I am very happy with my children's progress.

Murali Krishna, Google Review, Wembley

Speak to Joe or Ronnie on how you can enrol on government fully funded IT courses. Professional training company with many fully funded accredited courses!

Michael, Harrow on the Hill

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


Good dedicated tutors for maths lessons, booked them for my son and daughter's gcse and a level maths tuition.

Kirpal Singh, Wembley

Excellent professional service for you to achieve results.

Cindy Mart, Sudbury

"Customised Curriculum were absolutely amazing in helping me with my Excel skills, James was so patient with me and what I learned enable me to go for a better job".

Sarah Smith, London

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.

Jean, Harrow

Booked a few GCSE biology lessons for my daughter with Gregory, and he was brilliant, in tutoring my daughter in the areas she was lagging behind.

Emma, Hatch End