Master pivot tables, formulas, macros, vba, data analysis and learn how to land your first job as an Excel expert!
InstructorJuan E. GalvanCovers essential functions including lookup, conditional, and statistical operations alongside data modeling with PowerPivot.
Early lessons utilize case-based examples and a suitable pace that supports absolute beginners.
Editorial course preview
These 4 complementary views highlight concrete, legible examples from the course presentation.
This introductory module covers an overview of Microsoft Excel, the data analyst industry, job opportunities, salaries, and various Excel functions.
This slide outlines the intermediate section of the course, covering essential skills such as data visualization, databases, pivot tables, functions, and formulas.
This slide introduces the section on Excel Macros and VBA, outlining key topics such as the VBA language, code structure, loops, macros, and user forms.
This course section provides a full introduction to starting a career as an Excel Programmer, covering resume creation, freelancing, personal branding, and networking.
Free
The transition to programming can feel overwhelming or lack step-by-step detail in certain automation segments.
Some practical exercises may not be fully functional for learners using the Mac version of Excel.
The course aligns well with beginner goals, though Mac users may encounter practical limitations.