Excel Formulas for Absolute Beginners

In this course we’ll be learning about excel formulas and have a lot of fun while we are at it. 

This course is for Beginners who are just starting with Excel formulas and hopefully, by the end of course gain enough knowledge to be able to use formulas in their day-to-day activities.  We will start with Cell References, and then move on to different types of formulas, functions such as Logical functions, text Functions and Lookup functions.  All the topics have associated Excel Workbook resources containing sample problems to solve, puzzles, games and real-world practice questions to practice on.

To conclude, work on a mini-project to build a dashboard for an imaginary software development firm.

Happy Learning!

--- **Overall Course Rating:** 4.53 **Recent Reviews Summary:** **Pros:** - **Engaging Content for Beginners:** Many users appreciated the course's ability to engage and interest beginners, with several highlighting its fun and interactive elements. - **Creative Tests and Exercises:** The creative tests after each section were praised for their well-thought-out nature and for enhancing the learning experience. - **Clear Instructions:** Users found the instructions provided to be clear and concise, which aided their understanding of the exercises. - **Informative and Informal Teaching Style:** The teaching style was commended for being both informative and conversational, making complex concepts easier to grasp. - **Comprehensive Coverage of Basic Functions:** Some users mentioned that the course covered what they believed to be the most commonly used basic functions, which is a strong point for practical application. - **Great Practice Opportunities:** The hands-on exercises were described as cool and fun, offering great practice opportunities for learners. - **Resourceful and Interactive:** The course was noted for being resourceful and interactive, making it an enjoyable learning experience. **Cons:** - **Instructor Absence Issues:** At least one user expressed disappointment due to the absence of the instructor, which affected their experience negatively. - **Formula Verification Glitches:** Several users reported issues with formulas not being verified correctly in versions of Excel other than English, which could lead to confusion and frustration. - **Technical Glitches in Videos:** Some users encountered technical glitches such as stalling and repeating video loops, which disrupted their learning experience. - **Incomplete Content Concerns:** A few users pointed out that some sections seemed incomplete, with the instructor discussing formulas without showing how to use them, leading to a confusing learning path. - **Pass/Fail Indicators Not Functional:** Some tasks were designed based on specific dates, which became problematic as the spreadsheets were in read-only format and could not be altered to accommodate date changes. - **Misleading Resource Module Numbers:** The mismatch between lesson and resource module numbers could confuse actual beginners, making navigation more difficult. - **Missing Solutions in Exercises:** A significant issue was the lack of solutions provided for the exercises, which left some users frustrated and unable to verify their work or learn effectively from their mistakes. - **Complex Formula Testing:** While the quizzes and in-spreadsheet exercises were helpful, they did not always reveal the formula being tested, especially when it came to more complex formulas, leading to an incomplete learning experience. - **Repetitive Content:** One user noted that a particular module (Absolute and Relative Referencing) contained a repetitive video, suggesting it should be divided into two shorter videos to improve the learning experience. **Additional Feedback:** - **Interesting and Engaging for Teachers in Schools:** The course was likened to how teachers in schools should approach teaching basic functions, with one user expressing gratitude for the engaging presentation. - **Room for Improvement in Instruction Detail:** Some users suggested that lessons could be longer than 1-3 minutes and that certain instructions within lessons could be more detailed. - **High Potential with Addressable Issues:** Users recognized the high potential of the course but also highlighted specific issues that, if addressed, would significantly improve the learning experience. **Final Takeaway:** The course offers a fun and engaging way to learn Excel for beginners with its interactive and resourceful content. However, it falls short in areas such as instructor presence, formula verification glitches, incomplete content presentation, and the lack of solution guidance for exercises. With improvements in these areas, the course could be an even more valuable tool for users looking to master the basics of Excel.