In this hands-on course, you’ll learn to prepare data efficiently with Power Query in Excel and Power BI. Explore the Power Query Editor to import, clean, and transform datasets; reshape information with tools like Pivot and Un-Pivot; and combine data from multiple sources using joins. You’ll also practice automating queries, using parameters, and optimizing workflows, giving you the skills to streamline data preparation for analysis and reporting.
Participants should have knowledge equivalent to our Excel Bootcamp.
Receive instruction from subject‑matter experts who bring proven government experience.
Courses that are regularly updated based on feedback and industry developments, ensuring versions are mapped to federal competencies.
The instructor was wonderful and so knowledgeable. The course materials were extremely relevant to what my job is. I feel like I can be better because of this class.
— 2025 student
Directly addressing the day-to-day challenges of federal employees.
Your trusted training partner, equipping public service professionals with the skills and knowledge to excel in their roles and drive meaningful impact.
Attend this course Live Online. Engage with expert instructors, ask questions, and get feedback on your exercises and projects.
At Graduate School USA, you’ll learn in small groups and receive personalized attention.
Get the same interactivity and access to the instructor as in-person students. There are no extra fees and we’ll work with you to ensure your remote setup is perfect.
Upon completion of this course, you’ll receive an official certificate testifying to your mastery of the curriculum. We’ll send you a link where you can download your certificate, share it online with your friends, post it to your professional network on LinkedIn, and view all your earned certificates. Congratulations on your achievement!
Shareable on
We offer a single free retake of the class within a year.
You can also access recordings of each session in your student portal within one business day of the session’s end. Recordings are available for one month after the session.
Since 1921, Graduate School USA has partnered with over 125 federal agencies and trained more than one million federal employees. Led by instructors with deep, real-world knowledge of federal regulations, policies, and practices, our private group programs are practical, mission-driven, and tailored to your agency’s objectives. We offer expertise across key federal domains—including human resources, financial management, acquisition and contracting, leadership, and more—to deliver training where and how your team needs it.
Complete this form and we’ll get back to you within 1 business hour.
