Is this your reality?
-
Do you feel overwhelmed or frustrated trying to use Excel because you don’t know where to start?
-
Have you ever created an Excel sheet but struggled with properly entering and organizing the data?
-
Does trying to write Excel formulas make your head spin?
-
Do you waste time hunting for data buried deep inside endless spreadsheets?
-
Can you create interactive visualizations beyond basic graphs?
-
Are you unable to forecast future outcomes based on current data?
-
Does consolidating data from multiple sources feel like a nightmare?
-
Are inefficiencies in Excel analysis delaying your team’s decision making?
-
Is your current Excel skillset limiting your strategic contributions overall?
-
Do you want to learn how to use advanced data analysis tools in Excel to gain insights and make better decisions?
-
Do you want to improve your overall proficiency in Excel and learn advanced features and techniques to enhance your productivity?
Take Your Excel Skills to the Next Level
These courses provide the tools & techniques to master a wide range of beginner to advanced Excel skills that enable more efficient and powerful data analysis and workbook automation.
Excel Level 1 will help you:
-
Get started with Microsoft Office Excel.
-
Perform calculations.
-
Modify a worksheet.
-
Format a worksheet.
-
Print workbooks.
-
Manage workbooks.
Excel Level 2 will help you:
-
Use the new features in MS Excel
-
Identify new charts to communicate the key message
-
Use a variety of functions to analyse business data
-
Sort and Filter Data in predefined Tables
-
Use data validation to control data entry
-
Use the key functions of Pivot tables.
Excel Level 3 will help you:
-
Use the new features in MS Excel
-
Create Dashboards using Camera Tool.
-
Understand and use new Functions in Excel
-
Create Tables, use PivotTable, PivotCharts & Slicers.
-
Use PowerPivot to analyse large data sets
-
Understand Data analysis and Business intelligence features in Excel
-
Use advanced Data Analysis functions in DAX
-
Automate some Tasks using Macros/VBA
At a glance
Audience
Professionals across various roles and industries who are involved in or affected by project management and execution.
Format
-
2 x 2.5-hours, instructor-led online sessions or 5 hours face to face
-
One-on-one 60-minute personal coaching session with a skilled facilitator
What's Included
-
Comprehensive Learning Guide and Resource Manual: Individual Virtual Learning Guide with training content to refer to, whenever you want.
-
Ongoing support: WorkingSm@rt Helpdesk, no matter where you work.
-
LearningLink: Our monthly productivity e-newsletter to keep you updated.
Units
-
Part 1: Prepare 1a. Idea (Objectives + Boundaries) 1b. What (Structure + Data + Transparency) 1c. Who (Team + Stakeholders) 1d. Meeting (Frequency + Notes).
-
Part 2: Strategy 2a. How (Actions + Sequence) 2b. Plan (Who & When) 2c. Options (Complex Projects) 2d. Analysis (Actions & Resources)
-
Part 3: Action 3a. Do It (Execute + Allocate Time) 3b. Update (Progress on Actions) 3c. Supervise (+ Anticipate + Correct)
-
Part4: Communicate 4a. Team (Messaging) 4b. External (Email Transparency) 4c. Stakeholders (Report) 4d. Lessons (Publish Results)
What you will learn
Excel Level 1
This course is best suited for beginner or novice users, or those with limited time to develop efficient foundational Excel skills from the ground up. Learn how to prepare and present spreadsheets systematically and professionally and to rapidly build visually-appealing outputs for printing or publishing.
Excel Level 2
This course is for users who want to build upon their foundational knowledge and master more advanced spreadsheet capabilities for robust data analysis and reporting. This includes learning pivot tables, lookup functions, database tools, chart creation, and other analytical features to extract deeper insights.
Excel Level 3
This workshop is intended to help all users get up to speed quickly on the advanced features of Excel. We will cover using Excel online, worksheet Automation, auditing and error checking, data analysis and presentation, working with multiple workbooks and exporting and sorting data
What our graduates say about this course
Making Excel Work
Call us on
+353 (0) 1 584 6376
Team uses for Planner & Teams
Our WorkingSm@rt with Microsoft Excel course is designed to support users at all levels, from beginners to advanced. This practical, internationally delivered programme equips participants with the tools and techniques to organise, analyse, and present data efficiently and with confidence.