Call us:01943 870 638
Excel Courses
Excel Training
NEW! INTRO TO EXCEL ARTIFICIAL INTELLIGENCE
AI skills are in demand! This instructor led course will show you how Artificial Intelligence (AI) is having a big impact on how we use Microsoft Excel. By using the AI tools in this course, you will be able to prepare data, create formulas, automate tasks and provide data-driven insights. We’re entering the era of Excel and AI and it’s changing the game.
EXCEL LEVEL 1: WORKSHEET FUNDAMENTALS
Solid Excel spreadsheet skills are essential in today’s business world. Learn the basics of Excel spreadsheets with this comprehensive introductory course. Gain confidence and develop skills that can be transferred immediately to the workplace. Prerequisites: Basic keyboard and mouse skills.
| Excel application window | Add borders and shading to a worksheet |
| Enter labels and values into a worksheet | Sort the records of a list |
| Enter a formula into a worksheet | Filter the records of a list |
| Adjust column width and row height in a worksheet | Excel tables |
| Open a new workbook | Insert comments into a worksheet |
| Use the spelling checker | Split the worksheet window into panes |
| Use an Excel template to create a workbook | Freeze the worksheet window |
| Automatically fill a range | Hide rows and columns of a worksheet |
| Copy and move cells | Change the page setup for a worksheet |
| Automatically compute a row or column total | Preview a worksheet |
| Insert and delete rows and columns | Insert a manual page break into a worksheet |
| Realign cell entries | Print selected worksheet entries |
| Reset font options for cell entries | Use Excel functions (SUM, AVERAGE, MAX, MIN and COUNT) |
| Reset the number format of cell entries |
EXCEL LEVEL 2: MANAGING DATA
Master popular Excel functions. Learn how to manage your data efficiently and present it effectively using Excel's visualization tools. Intermediate level course. Prerequisites: Excel 1 or introductory level skills.
| Find and replace a specific entry in a worksheet | Insert sparklines |
| Create and apply a style | Insert a new worksheet in a workbook |
| Apply conditional formatting to a worksheet | Delete a worksheet from a workbook |
| Use options in the paste special dialogue box | Enter a formula to link related worksheets in a workbook |
| Use alignment options in the format cells dialogue box | Format multiple worksheets in one operation |
| Use the IF, SUMIF and COUNTIF functions | Use the VLOOKUP and XLOOKUP functions |
| Use the PMT and FV functions | Create a new workbook template |
| Use the DATE and NOW functions | Insert a diagram into a worksheet |
| Plot a chart | Insert a hyperlink into a worksheet |
| Modify and enhance a chart | Linking Excel to other applications |
| Enter an absolute cell reference into a formula |
EXCEL LEVEL 3: ANALYSING DATA
Spot patterns and trends in your data and gain an insight into Excel's powerful business intelligence features. Also covers Excel's security features. Advanced level course. Prerequisites: Excel 2 or intermediate level skills.
| Restrict cell entries to specific numbers, dates, or times | Create a workspace |
| Restrict cell entries to specific entries in a list | Add subtotals to worksheet data |
| Create a custom number format | Group and outline data |
| Define a range name | Create a PivotTable report |
| Use a range name in a formula | Reset the summary function in a PivotTable report |
| INDEX MATCH vs XLOOKUP functions | Create a PivotChart report and Dashboard |
| Use the DSUM and DAVERAGE functions | Perform data analysis using scenarios |
| Trace precedents in a worksheet | Import data into excel |
| Trace dependents in a worksheet | Export excel data to other applications |
| Trace errors in a worksheet | Use the data consolidation feature |
| Watch and evaluate formulas in a worksheet | Protecting excel files, workbooks and worksheets |
| Consolidate data from multiple workbooks |
EXCEL LEVEL 4: MACROS AND VISUAL BASIC
Become a true Excel power user with this introduction to macros and Visual Basic. Learn to automate repetitive tasks and customise the Excel environment. Prerequisites: Excel 3 or advanced level skills.
| Configure macro security settings | Edit a personal macro |
| The Macro Recorder | Include relative cell references in a macro |
| Record workbook macros for cell operations | Add a macro button to the ribbon |
| Run a workbook macro | Create macros using the Visual Basic Editor |
| Display macro instructions | Create a user-defined function |
| Edit a workbook macro | Respond to user input |
| Add a macro button to a worksheet | Create a user form |
| Record personal macros to automate workbooks | Debug a macro |
| Run a personal macro | Using ChatGPT |
Competitive Pricing
Each course lasts one day.
Participants will receive a manual and completion certificate.
Participants will receive a manual and completion certificate.