Are you looking to master Microsoft Excel and supercharge your productivity? Join our 10 Week Certified course, taking you from Beginners, to Intermediate and on to Adcanced in just 10 short weeks.

1.5 hour sessions with a Microsoft Certified Professional with 25+ years of Global Experience.

Our comprehensive Excel course is designed to transform you into a spreadsheet wizard, whether you're a beginner or looking to advance your skills.

In this hands-on course, you'll learn the ins and outs of Excel, from basic data entry and formatting to advanced functions and data analysis. Discover the power of formulas, create stunning charts and graphs, and automate repetitive tasks with ease. You'll even delve into the world of macros to become an Excel automation pro.

Our experienced instructor will guide you through real-world scenarios, ensuring you not only learn Excel's features but also understand how to apply them to your job, business, or personal projects.

Join us and gain the skills that employers value, giving you a competitive edge in today's data-driven world.

What You'll Learn:

Master the Excel interface and essential functions.
Analyze data and create insightful reports.
Automate tasks with macros and VBA.
Collaborate efficiently and share your work.
Unlock the full potential of Excel for your career.

10 Week Microsoft Excel Course

Name: 10 Week Microsoft Excel Course
SKU: 364215375135191

SKU: 364215375135191

€250.00

€200.00

Quantity

NO CROME BOOKS
Must have a laptop for the duration of the course, with Microsoft Excel software downloaded.

All sessions come with take away tasks and there is an alloted 30 minutes at the start of every session to create, design and put your new learning into practice.
Basic Excel Functions:

Creating, saving, and opening Excel workbooks.

Navigating the Excel interface and ribbon.

Entering and formatting data.

Using basic mathematical functions (e.g., SUM, AVERAGE, MAX, MIN).

Data Manipulation:

Sorting and filtering data.

Working with rows and columns (inserting, deleting, hiding).

Using find and replace.

Cell Formatting:

Formatting text and numbers.

Applying cell borders and shading.

Conditional formatting for data visualization.

Formulas and Functions:

Writing and editing formulas.

Using common Excel functions (e.g., IF, VLOOKUP, HLOOKUP, INDEX, MATCH).

Creating named ranges.

Data Analysis:

Creating and interpreting charts and graphs (e.g., bar charts, pie charts, line graphs).

Data validation and drop-down lists.

PivotTables and PivotCharts for data summarization.

Data Management:

Importing data from external sources.

Data consolidation and merging.

Data protection and security (password protection, permissions).

Working with Multiple Sheets and Workbooks:

Managing multiple worksheets.

Linking data between worksheets and workbooks.

Using 3D references.

Advanced Excel Features:

Macros and automation using VBA (Visual Basic for Applications).

Solver for optimization problems.

Advanced charting and data visualization techniques.

What-If Analysis and scenarios.

Collaboration and Sharing:

Sharing workbooks and collaborating in real-time.

Tracking changes and comments.

Excel Online and cloud-based collaboration.

Data Analysis Tools:

Data analysis add-ins like Data Analysis ToolPak and Power Query.

Tips and Tricks:

Time-saving shortcuts and Excel productivity tips.

Best practices for efficient spreadsheet design.

Customization:

Customizing the Excel environment (ribbon, Quick Access Toolbar).

Creating and using templates.

Data Export and Reporting:

Exporting data to other formats (e.g., PDF, CSV).

Creating professional reports and dashboards.
My name is Clare Bendandi. I am a certified Microsoft expert and long time practitioner in the field of IT and software programming.
I have taught many colleagues in the business industry how to use the Microsoft programmes to make their work easier, faster and more efficient.
These programmes optimise your productivity at work, enable you to get that higher position in a company and support you in keeping your busy day better organised.

I am clear and conscise with instruction, I think better with my hands, so my courses are always practical and I love Pink.
Bring your computer and come and join me.

10 Week Microsoft Excel Course

Requirements

Full Course Syllabus

About the Trainer