Automate Excel Data with Power Query and Lookups
Automation in Excel isn’t just about saving time—it’s about building reliable, transparent systems that scale with your data. In this intermediate-level course, you’ll learn how to use Power Query to clean and transform recurring datasets, and how to apply advanced lookup formulas to design dynamic, flexible reporting tools. Through short videos, readings, and guided practice, you’ll import real financial data, automate cleansing steps, and document your logic for audit and reuse. Then, you’ll build a lookup-driven template that retrieves statement lines instantly when users select a fiscal y
Skills you'll learn
We may earn a commission if you enroll through our links — it never affects the price you pay.
Similar courses
Apply Data Analytics with Minitab for Business Decisions
By the end of this course, learners will be able to apply statistical data analytics techniques using Minitab and Excel, interpret business data through descriptive and inferential methods, evaluate relationships using correlation and ANOVA, and support data-driven business decisions through real-world case studies. This course provides a practical, industry-focused introduction to data analytics using Minitab, designed for learners who want to move beyond theory and develop job-ready analytical skills. Learners will explore core statistical concepts such as descriptive statistics, hypothesis
All levels
AI-First Professional Skills
By the end of this course, you'll be able to tell your career story clearly, make sense of data without a background in analytics, learn new skills faster with AI as your tutor, and walk into interviews and tough conversations already prepared. This course is built for complete beginners — no prior AI experience needed. Instead of abstract theory, every concept is paired with a short, practical demonstration you can try yourself, covering the real tasks professionals face every day: resumes, LinkedIn profiles, spreadsheets, learning plans, interview prep, and negotiations. Rather than teachin
All levels
UiPath Automation Explorer
Offered by UiPath in partnership with Coursera, the Automation Explorer course is designed to help you build automation development skills from the ground up—no prior programming or RPA experience required. Start your journey by exploring the UiPath Business Automation Platform and creating your first automation in UiPath Studio. Learn to work with variables, arguments, and control flow to bring logic to your processes. Then, advance to automating real-world tasks using Excel and modern UI elements. This beginner-to-intermediate course is built on UiPath Studio 2022.10 and includes updates a
All levels
Excel Skills for Business: Intermediate I
Spreadsheet software remains one of the most ubiquitous pieces of software used in workplaces across the world. Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio. In the United States alone, millions of job advertisements requiring Excel skills are posted every day. Research by Burning Glass Technologies and Capital One shows that digitals skills lead to higher income and better employment opportunities at a time when digital skills job are growing much faster than non-digital jobs. In this second course of our Excel specializat
All levels