Tables and Formulas with Excel
What you will learn
Easily create, manage and filter tables to answer key questions of your data
Learn the IF, HLOOKUP, VLOOKUP and other functions for powerful capabilities
Easily aggregate data in Tables using Sum, Count, Average, Max and Min
Use Conditional Formatting to highlight data according to a range of conditions
Learn to use Data Bars, Color Scales and Icons in Spreadsheets
Use the SUMIF, COUNTIF and AVERAGEIF functions to easily calculate filtered data
Use Date formulas to calculate time / date intelligence
Use Text formulas to manipulate text entries
Course Gallery
Loading charts...
Comidoc Review
Our Verdict
The "Tables and Formulas with Excel" course succeeds in delivering a comprehensive overview of essential Excel functions, such as SumIF, Date, IF, VLOOKUP, HLOOKUP, and various Text formulas. The course's strong suit is its practical activities, providing learners with the opportunity to reinforce concepts through real-life application. With updates as recent as 2025, this course maintains its relevance in today's ever-evolving landscape of spreadsheet tools.\n\nWhile there are minor issues related to video quality and consistency between a few practical activity questions and their respective answers, these concerns do not detract significantly from the overall learning experience. Additionally, learners may find that the emphasis on date formulas might be excessive if they don't consider this aspect critical for their needs.\n\nThe course offers extensive value to those looking to enhance their Excel skills, especially since it caters to both beginners and advanced users seeking to deepen their understanding of essential Excel functionalities.
What We Liked
- Covers both basic and advanced Excel functions such as SumIF, Date, IF, VLOOKUP, and Text formulas
- Includes practical activities that reinforce the concepts taught in each section
- Well-structured course organized by topics, making it easy to follow and revisit specific areas
- Updated as recently as 2025, ensuring that the content remains up-to-date and relevant
Potential Drawbacks
- Some videos may have focus issues, impacting overall production quality
- There are discrepancies between some questions in practical activities and their corresponding answers
- Date formulas might not be as crucial for all learners, which could lead to an unbalanced focus for some
- Access to section 8's spreadsheet is missing from the practical material