-
Excel - Intermediate Level
Date and Time
Wednesday May 25, 2022
9:30 AM - 12:30 PM ISTWed 25th and Thur 26th May 2022
9:30 to 12:30pm each dayLocation
Live Instructor-Led Webinar
Fees/Admission
Chamber Members 100 euro
Non-Members 150 euro
*Fingal Chamber members must log in to be eligible for member-only rates and options.
For details on how to access the Member Information Centre, please click here.Website
Description
Please ensure you have a laptop/computer screen and an additional screen connected as this will assist you greatly in the training.
Microsoft Excel is a useful tool for generating spreadsheets from a number of data sources. Using calculations and functions, users can easily manage any type of data including budgets, financial data, statistical data, reports, charts, graphs and small lists. The Intermediate Excel 2016 / 365 training course is ideal for those with a working knowledge of Microsoft Excel and demonstrates how to work more efficiently with workbooks and enhance the appearance of the data in the spreadsheets.
Day 1- Create an IF Function
- Nest AND, OR and IF Functions
- Use the PMT Function
- Use the VLOOKUP Function
- Use the HLOOKUP Function
- Create Named Cells
- Create Named Ranges
- Create drop down lists
- Sort Data
- Create a Custom Sort
- Filter Data
- Advanced Filter
- Subtotal Data
- Create a Column Chart
- Create a Pie Chart
- Modify Chart Options
Tell a Friend
-
Advancing Business Together.