-
Excel - Intermediate Level
Date and Time
Wednesday Apr 14, 2021
9:30 AM - 12:30 PM ISTWednesday and Thursday 14th and 15th April 2021
9:30 to 12:30pm each dayLocation
Webinar
Fees/Admission
Chamber Members 100 euro
Non-Members €150
*Fingal Dublin 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
Wednesday and Thursday 14th and 15th April 2021
9:30 to 12:30pm each day
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 2013 / 2016 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.
Excel Intermediate ? Level 2 (1 Day) Y N Topic Y N Topic Create an IF Function Sort Data Nest AND, OR and IF Functions Create a Custom Sort Use the PMT Function Filter Data Use the VLOOKUP Function Advanced Filter Use the HLOOKUP Function Subtotal Data Create Named Cells Create a Column Chart Create Named Ranges Create a Pie Chart Create drop down lists Modify Chart Options 
