Gain Skills in Data Analysis with Excel. Pass the Microsoft 70-779 Exam. Grow Your Career with an Excel Certification.
InstructorBen YoungThe curriculum emphasizes Power Query for importing, appending, and merging files, which helps automate tedious data cleaning tasks.
Editorial course preview
This view highlights a concrete, legible example from the course presentation.
This image shows the Excel Power Query interface, specifically highlighting the 'From Database' submenu which includes options for connecting to SQL Server, Microsoft Access, Oracle, and other data sources.
Instruction utilizes relevant datasets to demonstrate functionality through practical, easy-to-follow examples.
This signal predates the displayed course update; the update may have addressed it, but the update label does not prove that it was corrected. One signal suggests occasional video blurriness and inconsistent microphone volume levels during specific sections.
One signal suggests occasional video blurriness and inconsistent microphone volume levels during specific sections. Note that these reviews were posted before the displayed update date, which does not prove a correction has been made.
The curriculum aligns well with the goals of data and business analysts preparing for specific Excel certification.
