This course is designed for beginners and professionals who want to build a strong foundation in Microsoft Excel. Participants will learn how to confidently navigate Excel, format worksheets professionally, work with formulas and functions, manage data efficiently, and apply practical productivity techniques used in modern workplaces.

Learning Outcomes

Understanding the Excel Interface

• Navigating the Excel environment
• Understanding ribbons, tabs, and toolbars
• Working with worksheets and workbooks
• Entering and editing data
• Saving and managing files

Formatting and Presentation

• Formatting cells, rows, and columns
• Adjusting fonts, colours, borders, and alignment
• Applying number formatting
• Formatting dates and percentages
• Using cell styles and themes

Keyboard Shortcuts and Productivity

• Essential Excel keyboard shortcuts
• Navigating efficiently using the keyboard
• Copying, pasting, and moving data quickly
• Using autofill and flash fill
• Improving workflow and productivity techniques
• Using AutoSum

Using Formulas

• Performing basic calculations
• Understanding formula structure
• Applying formulas across worksheets
• Understanding formula errors
• Extracting and manipulating text data
• Combining text
• Understanding Excel date formatting
• Working with days, months, and years
• Performing date calculations

Cell Referencing

• Relative vs absolute cell references
• Using fixed references in formulas
• Copying formulas correctly
• Understanding how formulas behave when dragged

Data Cleaning

• Splitting data into multiple columns
• Working with delimiters
• Cleaning imported datasets
• Preparing data for analysis
• Identifying and removing duplicate records
• Using sorting and filtering tools
• Applying conditional formatting
• Maintaining clean datasets

Course Dates & Duration

Please note that as per terms and conditions, LEAD Training Services reserves the right to alter course dates, times and venue in exceptional circumstances beyond its control.

A 10-15 minute break will be allowed every hour during which students can also take this opportunity to submit further questions or comments to the trainer.

Course Delivery Mode

This course will be delivered via live online webinars.  The course trainers will be visible on screen via a professional webinar platform, through which students can follow the trainer presenting live, whilst also using a PowerPoint presentation and sharing other resources as necessary.

Students will be able to interact with the trainer by sending questions or comments through the same webinar platform.

Our student support team will assist all students with simple instructions on how to access the webinar online.  A support line will also be made available to communicate with a student support officer in case of technical difficulties encountered during the live webinar.

LEAD Training Services is a Higher Education Institute, licenced by the Malta Further and Higher Education Authority (MFHEA), having licence number 2013-FHI-021.