Due to demand Spreadsheet Interaction Limited is running some additional one-day Excel courses in The Portlaoise Enterprise Centre – Beginners Excel (Thursday, March 22) and Intermediate Excel (Thursday, April 19).
If you are new to Excel or returning to the workforce, you could learn Excel from scratch on the Beginners course.
For those of you who are more experienced, upskill to Intermediate level in Excel’s 3 core aspects – formulas & functions for calculations; graphs to visualise your numbers and pivot tables which is Excel’s fully integrated data analysis summary tool.
There is no need to bring along a laptop on the day as computers are provided by the centre in its excellent computer training room. Maximum class size is 8 people.
The trainer, Martin Loughman, is a certified Microsoft Excel spreadsheet expert whose company Spreadsheet Interaction Limited designs and delivers high-quality Excel training programmes to groups across the country.
The beginner will learn all about:
Cells | Data Types | Cell References | Formulas | Data Ranges | Functions | SUM | AVERAGE | COUNT | Ribbon | Backstage | Quick Access Toolbar | Worksheets | Workbooks | Cell Selection & Navigation | Basic Editing | Insert Rows & Columns | Delete Rows & Columns | Hide Rows & Columns | Data Fill | Absolute v. Relative Cell References | Formatting | Dialog Box Launcher | Paste Special | Format Painter | Autofit Column Width | Filtering | Sorting | Freeze Panes | Set Print Titles
On the intermediate course you can learn the following skills:
Core Aspect 1 (Formulas & Functions) – IF | VLOOKUP | SUMIF | IFERROR | MID | DATE | Name Manager | Custom Number & Conditional Formatting | Linking workbooks | Official Table || Core Aspect 2 (Graphs / Charts) – Chart setup | Chart elements | Data Series | y value axis | x category axis | Chart Types, Layouts & Styles | Sparklines || Core Aspect 3 (Pivot Tables) – Pivot Table set up | Normalised Data | Fields v. Items | Nesting | Formatting
Contact Martin on 087 4310927 or email firstname.lastname@example.org
Watch the videos