Microsoft Excel Complete Course - Beginner, Intermediate & Advanced

What's included:

• Fully Online Recorded Microsoft Excel Class
• CPD Accredited
• Free certificate
• 24/7 access to the course for Lifetime
• Online support
• No hidden fees

Course Link : Microsoft Excel Complete Course - Beginner, Intermediate & Advanced- CPD Certified

Did you know over 800 million people have Microsoft Excel on their computers, but most don't know how to use it! This might be because Microsoft Excel can come across as being a little awkward with first-time users. Enrol in this Level 3 CPD accredited course to use Microsoft Excel confidently and get to a point where using Excel will be as natural as rolling out of bed in the morning.

Microsoft Excel training is a must in the modern-day workplace. So many jobs require you to have Microsoft Excel skills, and proficiency in it will make you a better candidate for any job position. Our course will give you a complete grasp of Microsoft Excel to enhance your professional career.

Microsoft Excel is much more than just a simple tool for data management and calculation. It is a demanding business tool for most firms. Learning Microsoft Excel can open up a world of possibilities for you. Our course is designed by experts in such a way that it will benefit both beginners and advanced learners. You will learn from top to bottom about Microsoft Excel and get ahead of your competitors. If you are looking for a Microsoft Office Specialist Excel certification course, then all you need to know is entirely about Microsoft Excel from scratch. So what are you waiting for?

Enrol in the Microsoft Excel course today!

Working knowledge of Microsoft Excel is vital for most office-based professionals today, and stronger skills can open the door to jobs, promotions, and leadership opportunities.

Learning Outcomes:

• Understand Excel 2019’s new features.
• Perform basic and advanced calculations.
• Modify and format worksheets efficiently.
• Manage and print workbooks professionally.
• Use essential Excel functions effectively.
• Analyze data using charts and PivotTables.
• Work with multiple worksheets and workbooks.
• Utilize Lookup functions for data retrieval.
• Automate tasks and streamline workflows.
• Create sparklines and map data visually.
• Forecast trends and plan with Excel templates.
• Share and protect workbooks securely.

Disclaimer:

This is an online course with pre-recorded lessons. You will get access to the Microsoft Excel course within 48 hours after your enrolment.

Course Curriculum

Module 1: Microsoft Excel 2019 New Features

• Introduction to new functions like TEXTJOIN, IFS, and SWITCH.
• Exploring new chart types and enhanced visuals.

Module 2: Getting Started with Microsoft Office Excel

• Understanding the Excel interface and ribbon.
• Creating and saving workbooks.

Module 3: Performing Calculations

• Entering and editing formulas.
• Using built-in functions for calculations.

Module 4: Modifying a Worksheet

• Inserting, deleting, and moving data.
• Using find and replace, and spell check.

Module 5: Formatting a Worksheet

• Applying styles, themes, and conditional formatting.

Module 6: Printing Workbooks

• Setting print areas and page layouts.

Module 7: Managing Workbooks

• Working with multiple worksheets and workbooks.

Module 8: Working with Functions

• Exploring logical, text, date, and financial functions.

Module 9: Working with Lists

• Sorting and filtering data.

Module 10: Analyzing Data

• Using data analysis tools like Goal Seek and Scenario Manager.

Module 11: Visualizing Data with Charts

• Creating and customizing various chart types.

Module 12: Using PivotTables and PivotCharts

• Summarizing and analyzing data effectively.

Module 13: Working with Multiple Worksheets and Workbooks

• Linking data across sheets and consolidating information.

Module 14: Using Lookup Functions and Formula Auditing

• Implementing VLOOKUP, HLOOKUP, and auditing tools.

Module 15: Sharing and Protecting Workbooks

• Collaborating with others and securing data.

Module 16: Automating Workbook Functionality

• Recording and editing macros.

Module 17: Creating Sparklines and Mapping Data

• Visualizing trends and geographical data.

Module 18: Forecasting Data

• Using forecasting tools to predict future trends.

Module 19: Excel Templates

• Utilizing and creating templates for efficiency.