Course Description
Initially, Microsoft Excel might appear daunting, yet it remains one of the most essential digital skills to acquire.
Excel's capabilities in data analysis, charting, and graphing simplify the comprehension of extensive data sets. Its tabular sheets streamline project management, time management, and habit tracking.
Whether using Microsoft Excel for Mac or Excel for Windows, this course will guide you from beginner to proficient user, unlocking the full potential of MS Excel 2021.
Modules Covered
Course 1: Microsoft Excel 2021: Introduction
This beginner-level Excel course introduces you to the fundamental operations and functionalities of Microsoft Excel. It consists of 34 online lessons, amounting to approximately 11-17 hours of study time.
Learning outcomes include:
- Basic Microsoft Excel operations, such as opening and saving a new file
- Manipulating and adjusting worksheets
- Data entry and cells
- Copying and formatting, including conditional formatting
- Creating tables
- Basic formulas
- Charts and instant data analysis
- Pictures and printing in Excel
- Customisation of settings
Course 2: Microsoft Excel 2021: Intermediate
The Microsoft Excel 2021 Intermediate course emphasises calculations, expanding on beginner knowledge with advanced skills in essential functions like series fills, sorting, and filtering. This online Excel course comprises 35 lessons, with a total study duration of 12-18 hours.
Learning outcomes include:
- Manipulating sheets across multiple workbooks
- Advanced copying, pasting, and formatting
- Using references in Excel functions
- Advanced conditional formatting
- Function library and function applications
- Cell errors and how to check them
- Data validation
- Filtering and sorting
- Finding, replacing, and removing specific data
- Splitting text into columns
- Flash fill
Course 3: Microsoft Excel 2021: Advanced
Microsoft Excel 2021 Advanced places a strong emphasis on creating charts and using macros. This online Excel course includes 29 lessons, with an estimated study time of approximately 9-15 hours.
Learning outcomes include:
- Quick data analysis using sparklines
- Creating and formatting charts
- Insertion of graphical elements such as shapes and SmartArt
- Use of review tools such as proofing, tracked changes, and comments
- Various workbook views
- Page setup
- Workbook protection
- Creating and using templates
- File saving and compatibility
- Macros
Course 4: Microsoft Excel 2021: Expert Tools
In the course, you will master techniques for data importing, pivot chart usage, and advanced functions essential for processing and analysing data in larger databases. This course comprises 19 lessons, totaling approximately 6-10 hours of study time.
Learning outcomes include:
- Advanced data validation and filters
- Database functions
- OFFSET function
- SUBTOTAL function
- Advances IF functions
- VLOOKUP and HLOOKUP functions
- INDEX and MATCH functions
- Importing external data
- Microsoft Power Query
- XML data
- PivotTable
Accreditation
Fully Accredited
This course is nationally accredited by Microsoft - Training and Certification Courses
Microsoft is a globally renowned company that needs little introduction. With a presence spanning over four decades, Microsoft has continuously innovated to redefine how we live, work, and connect through technology. Microsoft certifications are internationally recognised credentials that attest to an individual’s proficiency and technical expertise in Microsoft technologies.
Benefits
- Achieve proficiency in the latest version of Microsoft Excel.
- Enhance your data management skills and convert large amounts of unorganised data into valuable business assets.
- Present information effectively using Microsoft Excel's graph and table functions, ensuring clarity and ease of understanding.
- Boost efficiency – mastering MS Excel 2021 can save time by streamlining data entry and calculations.
- Optimise your productivity using Microsoft Excel to improve personal performance both at work and home through trackers and tables with automated functions.
- Delivery Method: Online
- Assessment Included
- Course Access: 12 months
- Join a community of over 615,000
Eligibility
Please note this is a paid qualification, therefore you will have to pay the course fee in order to start studying.
Is the MS Excel 2021 online course right for me?
Whether you're a student, self-employed, or part of a business, Excel is an invaluable tool for tracking and managing tasks and finances. Its diverse functions enable you to transform performance metrics, targets, and survey results into easily understandable data, and to visualise large datasets with visual aids.
