Description

Microsoft Excel makes decision-making easy for management by enabling users to organize, evaluate, and validate data that is quantitative. Organizations can easily visualize the data with excel spreadsheets. Individuals can also improve their career prospects by learning how to use MS Excel.

This online curated course makes it easy to learn and use MS Excel and organize data using it conveniently. The course helps you walk through the basics and advanced functionalities of Excel. It gives quick hacks to the most common functions used on the platform. It also introduces learners to new ways of data analytics.

Even with little to no prior knowledge, learners will be able to conduct advanced operations on Microsoft Excel spreadsheets by the end of the course. That includes calculations, data analysis, maintenance, creating dynamic reports, and learning advanced Excel formulas.

By the end of the course you’ll be writing robust, elegant formulas from scratch, allowing you to:

  • Easily build dynamic tools & Excel dashboards to filter, display and analyze your data.
  • Create your own formula-based Excel formatting rules.
  • Join datasets from multiple sources with XLOOKUP, INDEX & MATCH functions.
  • Manipulate dates, times, text, and arrays.
  • Automate tedious and time-consuming tasks using cell formulas and functions in Excel (no VBA required!).
  • Pull real-time data from APIs directly into Excel (weather, stock quotes, directions, etc.).

We’ll dive into a broad range of Excel formulas & functions, including:

  • Lookup/Reference functions.
  • Statistical functions.
  • Formula-based formatting.
  • Date & Time functions.
  • Logical operators.
  • Dynamic Array formulas.
  • Text functions.
  • INDIRECT & HYPERLINK.
  • Web scraping with WEBSERVICE & FILTERXML