This course consists of three main parts with multiple lessons in each.
- 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
- Spelling, Theasurus, Find and Replace
- 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
- Fix Workbook Linked In SharePoint
- 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
- Data Tools
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.
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.