Master Excel Advanced Functions and Analytics
Master advanced Excel functions and analytics to transform data into meaningful business insights. This course teaches you how to build intelligent formulas, analyze large datasets, create dynamic reports, and develop interactive dashboards using advanced Microsoft Excel features. You will progress from logical, information, date, text, lookup, and reference functions to advanced data management, PivotTables, What-If Analysis, and modern data visualization techniques. Designed for professionals, analysts, and business managers who want to move beyond basic spreadsheets, this course provides p
Skills you'll learn
We may earn a commission if you enroll through our links — it never affects the price you pay.
Similar courses
Data Visualization and Communication with Tableau
One of the skills that characterizes great business data analysts is the ability to communicate practical implications of quantitative analyses to any kind of audience member. Even the most sophisticated statistical analyses are not useful to a business if they do not lead to actionable advice, or if the answers to those business questions are not conveyed in a way that non-technical people can understand. In this course you will learn how to become a master at communicating business-relevant implications of data analyses. By the end, you will know how to structure your data analysis proj
All levels
Data Visualization
In the era of big data, acquiring the ability to analyze and visually represent “Big Data” in a compelling manner is crucial. Therefore, it is essential for data scientists to develop the skills in producing and critically interpreting digital maps, charts, and graphs. Data visualization is an increasingly important topic in our globalized and digital society. It involves graphically representing data or information, enabling decision-makers across various industries to comprehend complex concepts and processes that may otherwise be challenging to grasp. DSCI 605 Data visualization serves as t
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
Data Visualization
This course will teach you how to make more effective visualizations of data. Not only will you gain deeper insight into the data, but you will also learn how to better communicate that insight to others. You will learn new ways to display data, applying some fundamental principles of design and human cognition to choose the most effective way to display different kinds of data. This course not only teaches you how to use popular applications like Tableau to connect to data warehouses to extract and visualize relevant data, but also teaches you how Tableau works so you can use the same techniq
All levels