Course Type
Learn online in your own time, and at your own pace via our eLearning platform.
Duration
11 hours worth of video learning broken down into bite-sized lessons.
Certification
Certificate of Completion & Virtual eLearning Badge
Course Type
Led by a live instructor, learn virtually (via Microsoft Teams) alongside a small group of other students.
Please Note
This Course Type is not currently offered in this region. Please register your interest for this Type of course.
If you’re looking for something more bespoke; if you need to educate a group of people; or if you’d like to schedule in some face-to-face, on-site training, please do contact us.
Microsoft eLearning Subscription
£12.75 GBP* per month
What's included:
- Licence for 1 user
- Access to this course
- Access to all other Microsoft eLearning courses
- No lock-in contracts
- Cancel your subscription at any time – see Terms & Conditions for details.
- Please note that once payment has been made you will receive an email to access the platform on the next working day.
*excludes VAT
Course Overview
This course consists of three main parts with multiple lessons in each.
Foundation
- Introduction to Excel
- Using Help
- Data Entry
- Selecting Data
- Clear and Delete
- Introduction to Formulas
- Introduction to Function
- Linking Between Sheets
- Relative and Absolute Cell Referencing
- Named Ranges
- Formatting
- Spelling, Theasurus, Find and Replace
Intermediate
- Conditional Formatting
- Sorting Data
- Filtering Data
- Format as a table
- Using Today and Now functions
- Using IF and Nested IF Functions
- Using the SUMIF and COUNTIF functions
- Using Networkdays function
- Database Function
- Pivot Tables
- Analyze Data
- Quick Analysis
- Protection
- Fix Workbook Linked In SharePoint
Advanced
- Using the SUMIFS and COUNTIFS functions
- Using Logical function AND,NOT and OR
- Using VLOOKUP and HLOOKUP functions
- Working Array Formulas
- Using Text function
- Create Subtotals
- Create Group and Outline
- Create Data Validation
- Formula Auditing
- Consolidated Data
- Custom Views
- Advanced Filters
- What if analysis Goal Seek
- What if analysis Solver
- What if analysis Scenario manager
- Templates
- Macros
- Data Tools
Customer Reviews
Rating: ⭐⭐⭐⭐⭐ (5/5)
"I recently completed the Microsoft Excel eLearning platform, a comprehensive course that takes users on a journey from foundational to advanced levels of proficiency in Excel. This well-structured and engaging course covers a myriad of topics, including Pivot tables, Analyzing data, Formula Auditing, custom views, advanced filters, Analysis, Macros, and more. As a participant, my feedback is overwhelmingly positive.
Before embarking on this course, I considered myself adept at using Excel. However, the eLearning platform proved to be a game-changer, expanding my knowledge and reshaping my understanding of Excel. The journey began with foundational topics, offering a solid base that not only reinforced my existing skills but also introduced me to nuanced aspects of Excel, such as linking between sheets and efficient data entry.
The intermediate section delved into the intricacies of Pivot tables, data analysis, and database functions. These modules were not just informative but provided practical insights that enhanced my ability to glean meaningful insights from complex datasets. The course seamlessly transitioned into the advanced level, unlocking a treasure trove of features like Formula Auditing, custom views, advanced filters, and the automation magic of Macros.
One of the standout features of the course was its practical approach to learning. Real-world applications and hands-on exercises allowed me to apply theoretical knowledge immediately, reinforcing the concepts in a practical context. This approach was particularly evident when learning to analyze data in depth and create insightful Pivot tables, skills that have proven invaluable in my professional tasks.
Moreover, the course enlightened me to the importance of data protection and introduced techniques on securing valuable information within Excel. This aspect was not only relevant but crucial in today's data-driven environment, adding an extra layer of proficiency to my skill set.
In conclusion, I wholeheartedly recommend the Microsoft Excel eLearning platform to anyone, regardless of their current proficiency level. The course offers a comprehensive, enjoyable, and transformative learning experience that goes beyond the conventional spreadsheet use. If you're looking to unlock the full potential of Excel and enhance your data management skills, this course is a must. I am truly grateful for the opportunity to expand my knowledge, and I am confident that others will find this eLearning journey as enriching as I did."
Who should attend?
No matter your level of experience or job role, anyone can attend this course.
Payment Options
This course can be purchased via our eLearning subscription.
Monthly and yearly payment plans are available.
Contact us for more information.
Need training for a group of people?
If you’re looking to train a small group, a whole team, or an entire company of employees, please get in touch as we’re able to offer discounts on multiples.
