Beginners | Intermediate | Advanced

Microsoft Excel Training for Individuals and Companies

Onsite, Online & Weekend Excel Training Courses by DEEPAK SHARMA

Instructor-led Excel courses in London, UK-wide, live online or at your offices.

Receiving Excel training will allow your employees to streamline their tasks and focus on more vital company projects. This excel training course is a wonderful fit for your firm, with a brilliant instructor and custom-made curriculum. With affordable fee structures, this excel training course is one of the greatest on-site and off-site programmes in London.

Designed to cater to different levels of learners, your employees can choose from beginner, intermediate or advanced excel course.

Call/WhatsApp

+44 744 0030 334

Request a Quote

Eleonora Sara SedikEleonora Sara Sedik
13:20 05 Nov 22
I am glad I chose Deepak over the other teachers for my Excel course.I am amazed by the value provided by him.He is an excellent tutor, very patient and explains everything precisely step by step at your own pace.I would highly recommend him to anyone interested in learning Excel.
Neeraja NairNeeraja Nair
19:38 26 Oct 22
I would definitely recommend Deepak if you’re starting out with excel, or even if you just want to brush up your excel skills! He’s very patient, non judgmental, and above everything very knowledgeable. His classes are reasonable, and he caters to both individuals and corporates. Highly recommended!
CJ OkonkwoCJ Okonkwo
08:19 05 Jul 22
Deepak was very patient and understanding going through the basic principles in depth to ensure I understood each part of what I was learning. I will be back for the advance course and will totally recommend him for any seeking a one on one excel lessons.
Dorota MezykowskaDorota Mezykowska
08:00 23 May 22
Deepak is a great teacher: calm, professional with ability to teach. As we all know you can be keen to learn but who&how teach you matters a lot. His attitude is great, his Excel advanced knowledge is excellent.Highly recommended!
Mina NozariMina Nozari
19:47 27 Apr 22
Deepak was very professional. He is an expert in the field and helped me out a lot. He is 100% a great tutor not only for students but professionals at other fields who need to improve the excel skills. He is very patient and explains everything thoroughly. I recommend him highly.
js_loader

01.

Beginners Excel Training

For complete beginners, this course covers all the basics of Excel.

  • Inputting data & using dates
  • Cell referencing & formulas
  • Using fonts, colours & borders
  • Printing your spreadsheet

02.

Intermediate Excel Training

Develop your Excel skills & learn to use more advanced features.

  • Creating & formatting charts.
  • Using conditional formatting
  • Intermediate-level formulas
  • Creating & filtering data tables

03.

Advanced Excel Training

Become a poweruser mastering Excel’s most powerful tools & functions.

  • Using logical functions
  • VLOOKUP, HLOOKUP & INDEX
  • Creating & editing Pivot Tables
  • What-if Analysis

Why Choose Us

Qualified Expert

Flexible Schedule

Practice Sheets

Affordable Package

Applied Concepts

Customized Course

Essential Excel Skills that a Marketing Professional should have

Excel is a fantastic tool for a variety of marketing activities. The two most important applications I have for Excel are as a research tool and, maybe more obviously and fundamentally, for data analysis and reporting.

One of the most often questions I get is, “What Excel skills are most important for marketers to learn?” With that in mind, here are some essential tips to assist you, as a marketer, improve your Excel skills.

  • VLOOKUP/HLOOKUP Function

This incredible feature is ideal for connecting and comparing different collections of data. Generally, this formula returns a value from the second table if a particular value from one table exists in the first section of another table. It can be used, for example, to see if new terms you want to use are already in an account, or to compare two distinct time frames.

VLOOKUP stands for vertical look-up, as in gazing down a column of data cells vertically. HLOOKUP, on the other hand, stands for horizontal look-up across a horizontal row.

  • Pivot Tables

MS Excel’s pivot tables are a very useful and effective tool. A pivot table categorises tabular data, making it easier to analyse vast datasets and identify relevant trends. Your data can be analysed, summarised, searched, and presented using them. Only when you can review and deduce relevant trends from data is it useful. Pivot Tables are specifically designed to assist you in doing so.

  • Creating Charts

When marketing data must be presented graphically, I frequently see tables used to deliver it to important stakeholders. Even with large datasets that are difficult to define, conditional formatting can be used to add some visual signs to tabular data as a minimum. In any event, if you’re not working with a large dataset, you should look for any opportunity to visually represent your data.

  • Conditional Formatting

It applies a given format to a range of cells and then modifies the formatting automatically based on the cell values.

For example, if you have sales data from various marketing campaigns such as TV, print ads, digital marketing, outdoor advertising, and so on, each channel will be assigned a different colour, and the value corresponding to that channel will automatically have its cell in that colour, without any manual formatting.

  • COUNTIF and SUMIF

COUNTIFS allows you to easily slice your data and count the number of cells inside a given region that fulfil the specified criteria.

Another option for extracting specific data is to use the SUMIFS function. SUMIFS works in a similar way as COUNTIF, but instead of counting the data, it sums it up for you. You can use SUMIFS to define several conditions.

Let's Discuss Your Requirements

We offer all of our Excel training courses onsite, as well as online.

Our remote Excel courses cover the same content as our onsite in-person courses and run over Zoom.