Skip to main content
Imperial Tuitions
  • Home
  • Courses
  • Popular Courses
  • We Offer
  • Get Notified

Join us: to stay updated on new courses, discounts, free learning opportunities, and more

Join us to
Grow Skills,
together!

Get Updates

Imperial Tuitions

Expert-led IT tuition and online courses in programming, web development, databases, and career-focused technology skills.

Explore

  • Home
  • Courses
  • Popular Courses
  • We Offer
  • Get Notified

Information

  • Privacy Policy
  • Terms & Conditions

Contact

  • info.imperialtuitions@gmail.com

Questions about courses or enrolment? Email us anytime.

© 2026 Imperial Tuitions. All rights reserved.

Privacy·Terms
  1. Home/
  2. Courses/
  3. Microsoft Excel

Microsoft Excel

In today's fast-paced, technical business environment, numbers are everything. Much of our success hinges on how well we can manage the data - statistics, planning, reporting - that we encounter on a daily basis. We learn how we are doing and discover our next course of action by studying numbers. An incredibly powerful tool for doing this is Microsoft Excel.

Microsoft Excel is the standard spreadsheet application for both the business world and personal use. Imperial Tuitions course for Microsoft Excel will teach you basic to advanced features of Excel.

Whether you are new to Excel or an advanced user, Microsoft Excel course will cover what you need to know to become an Excel power user.

Course Prerequisites:

None

Course Snapshot

£25.00 / Hour

Level: BeginnerDuration: 20 HoursMode: Online / Virtual

What you will learn?

1. Excel Basics

  • An overview of the screen, navigation and basic spreadsheet concepts
  • Understand Excel terminology workbooks, worksheets, rows, columns, cells
  • Various selection techniques
  • Understanding the various mouse cursors
  • Working with Ribbon Tabs, Groups and Dialog Boxes
  • Standard and Contextual ribbons
  • Use the task pane
  • Understand and use the File Tab
  • Saving, File types, File compatibility (earlier versions)
  • Useful keyboard commands
  • Quick Access toolbar & Mini Toolbar

2. Entering Data

  • Various ways to Enter, Edit and Delete information (Text, Numbers, Dates)
  • Use Auto List feature
  • Date and Time are storage in Excel
  • Enter Dates and Times
  • Date/time formatting
  • Methods to Move and Copy data
  • Use the Fill Handle to copy data and create simple lists
  • Create series of information
  • Insert, Delete and Hiding Rows & Columns
  • Insert, Delete and Move Cells
  • Insert, Delete, Move and Copy Sheets
  • Various navigation techniques

3. Creating & Editing Formulae & Functions

  • Define Formulae
  • Create & Edit Formulae
  • BoDMAS : Mathematical Order
  • Copy & Move Formulae
  • Use Basic Functions - Sum, Average, Max, Min, Count, Counta
  • Use Autosum tool
  • Introduction to the Function Library
  • Reference a cell in other sheets
  • Understand Relative Referencing
  • Apply Absolute (Fixed) Referencing

4. Creating & Editing Formulae & Functions

  • Define Formulae
  • Create & Edit Formulae
  • BoDMAS : Mathematical Order
  • Copy & Move Formulae
  • Use Basic Functions - Sum, Average, Max, Min, Count, Counta
  • Use Autosum tool
  • Introduction to the Function Library
  • Reference a cell in other sheets
  • Understand Relative Referencing
  • Apply Absolute (Fixed) Referencing

5. Formatting and Proofing

  • Formatting of Cells with Number formats, Font formats, Alignment, Borders, Fill colours and Patterns
  • Quick formats and themes
  • Sheet tab formatting and Renaming
  • Copy and Clear Formats
  • Merging cells
  • Spell Check, Find & Replace and AutoCorrect

6. Printing and Page Setup

  • Page Orientation
  • Add Headers and Footers
  • Print a selection
  • Set a print area
  • Clear a print area
  • Shrink to Fit
  • Adjust page breaks within Page Break Preview
  • Repeat columns and rows
  • Print Gridlines
  • Save print settings

7. Multiple File & Large Workbook Tools

  • Split screen tool
  • Freeze panes
  • Arrange workbook windows
  • Zooming tools
  • GoTo tool
  • Name box navigation

8. Range Names

  • Concept and Purpose
  • Naming individual or range cells's
  • Deleting and amending named ranges
  • Using named cells/ranges in formulae

9. Conditional Functions & Formats and Date Calculations

  • Benefits and purpose
  • If Statements , Nested If
  • And, Or, Not
  • Combining If, And, Or, Not
  • Sumif , Countif
  • Conditional Formatting
  • Entering Dates and Times
  • Different date/time formats
  • How dates are stored
  • Calculating working days
  • Using the DAY(),MONTH(),YEAR() functions
  • Time calculations

10. Formulae Auditing

  • Formula Auditing Tools
  • Revealing Formulae
  • Tracing Precedents/Dependents
  • Goto Special

11. Worksheet Management & Linking

  • Linking sheets in the same file
  • Linking different Excel files
  • Using Edit, Links
  • Viewing different files at once
  • Saving a workspace
  • Viewing different sheets at once
  • Window Split
  • Data consolidation

12. Basic List Management

  • Sorting Data
  • Adding Subtotals
  • AutoFilter
  • Freeze Panes
  • Group and Outline
  • Data Form

13. Excel Charts / Graphs

  • Using the Chart Wizard
  • Editing and Formatting charts
  • Saving custom chart types
  • Setting a default chart type

14. Lookup & Information Functions

  • Vertical Lookup (Vlookup)
  • Horizontal Lookup (Hlookup)
  • Match and Index
  • IsText, IsValue, IsDate , IsErr, Is Error, IsNa

15. Advanced List Management

  • Advanced Filters
  • Using List Features
  • Dynamic Lists (Tables)

16. Pivot Tables

  • Using the Pivot Table Wizard
  • Changing the pivot table layout
  • Formatting
  • Grouping items
  • Inserting calculated fields
  • Pivot Table Options
  • Display and hide data in fields
  • Lay out reports directly on worksheet
  • Pivot Chart

17. What If Analysis

  • Scenarios
  • Goal Seek
  • Solver
  • Data Tables

18. Protecting & Sharing Files

  • Sharing a file
  • Tracking changes
  • Accepting or rejecting changes
  • Applying Data validation rules
  • Inserting comments

Courses you may also like

HTML & CSS

This HTML & CSS Course is designed for absolute beginners who want to learn how to build modern, responsive, and professional websites from scratch. The course starts with the fundamentals of web deve...

Intermediate

Duration: 16 Hours

Charges: £25.00 / Hour

Mode: Online / Virtual

Details

Prompt Engineering

This intermediate Prompt Engineering course is designed for learners who already understand basic prompting concepts and want to create more structured, efficient, and professional AI workflows. Stude...

Intermediate

Duration: 7 Hours

Charges: £25.00 / Hour

Mode: Online / Virtual

Details

Prompt Engineering

This beginner-level Prompt Engineering course is designed for anyone who wants to learn how to communicate effectively with AI systems like ChatGPT and other generative AI tools. Students will learn t...

Beginner

Duration: 7 Hours

Charges: £25.00 / Hour

Mode: Online / Virtual

Details

Structured Query Language (SQL)

This course is designed for absolute beginners who want to learn SQL from scratch and start working with databases confidently. Students will learn how to store, retrieve, filter, sort, and manage dat...

Beginner

Duration: 16 Hours

Charges: £25.00 / Hour

Mode: Online / Virtual

Details