Practical Excel for the Intrepid Beginner

In this course, Excel MVP, author, and trainer Oz du Soleil provides a hands-on approach to mastering Excel fundamentals. Instead of overwhelming you with comprehensive interface tours or isolated demonstrations, Oz teaches through practical examples that solve real problems. Begin by building your understanding of the core purpose of Excel and quickly progress to using powerful tools like IF statements, Sort, and Filter functions to organize and analyze data. Learn how to nest basic formulas for more complex calculations, create meaningful summaries of your data, and properly work with text and numerical values. Practice building informative charts and develop good Excel habits as you learn. Each lesson provides detailed, step-by-step solutions that reinforce concepts and build your confidence. By focusing on practical applications, this course ensures you develop a solid foundation of skills that you can immediately apply to your own projects.

Learning objectives
Understand Excel's fundamental purpose and capabilities.
Master the essential trio of IF statements, Sort, and Filter functions.
Create nested formulas to solve multi-step problems.
Build effective data summaries and reports.
Properly manage text and numerical data types.
Construct clear, informative charts.
Develop efficient Excel habits that save time and prevent errors.