Start date: 10 May 2022
Duration: 10th & 11th May (9:30am - 12:30pm)
Location: Online - Live Webinar
Certificate: N/A
Cost: €69 for Members (€89 for Non Chamber Members)
Course code: N/A
Programme overview
Excel is the most in commonly used and in demand tool for making sense of data. When you can harness that power, you will be a sought after employee. If you run a business, being proficient in Excel can help you see your business in a completely different light.
This workshop looks at some of the more advanced tools in Excel and some of those tools in greater depth. Important functions such as V Lookup, Pivot tables and IF statements are covered in some detail and there are many invaluable short cuts and best practice included in the sessions.
Learning Outcomes
- Create a PivotTable
- Create a PivotChart
- Create a Macro
- Audit Worksheets
- Protect Worksheets and Workbooks
- Use Consolidation
- Apply Conditional Formatting
- Apply Data Validation
- Import and Export information
Who Is This Course For?
This course is perfect if you have an understanding of excel level 2 and would like to progress to a more advanced level
Modules
Modules
Session 1
Overview – Tips & Tricks
Customise Excel
Formula – Best Approach
Functions
- Stats
- Date
- Test
Freeze Panes
Formatting
Audit Options
Sub-Totals
Data Functions
IF Statements
VLOOKUPS
Drop-Down Lists
Session 2
Advanced Filter
Macros
Consolidation
Import / Export
Pivot Table
Pivot Charts
Reports
Conditional Formatting