PowerBI Data Analyst - Create visualizations and dashboards from scratch
Learn EDR Internals: Research & Development From The Masters
Overview
Google, IBM & Meta Certificates – 40% Off
One plan covers every Professional Certificate on Coursera.
Unlock All Certificates
Master Microsoft Excel from beginner to advanced level in this comprehensive 4.5-hour course designed for both newcomers and experienced users seeking to enhance their spreadsheet skills and efficiency. Begin by exploring Excel's interface and learning optimal navigation techniques to build a solid foundation. Progress through calculating data using essential formulas and functions, then advance to intermediate skills including data sorting, filtering tools, and time-saving techniques for managing large datasets. Discover how to create compelling visual representations of your data through charts and sparklines, along with professional presentation strategies. Dive deep into Excel's powerful Pivot Table functionality to analyze and summarize complex data sets effectively. Advance to sophisticated features including XLOOKUP functions essential for modern Excel workflows, complex database functions for advanced data manipulation, and an introduction to Macros for automating repetitive tasks and streamlining common Excel operations.
Syllabus
Excel Advanced Tutorial
Excel Intermediate Tutorial
Excel Beginner Tutorial
Taught by
Learnit Training
Reviews
5.0 rating, based on 2 Class Central reviews
Showing Class Central Sort
-
Starting as HR Generalist with passion for data analysis. This course has been a major transformation to my HR analyst career. I leant a lot Thank you.
-
I really like this course because it help me to know about Microsoft excel from beginner to advanced I recommend this course to everyone who wants to study in computer science department