ADVANCED EXCEL
CERTIFIED COURSE

Learn how to think like Excel, and write powerful and dynamic Excel formulas from scratch.

Takeaway from the Course:

  • Automate, streamline, and completely revolutionize your workflow with Excel.

  • Master unique tips, tools and case studies that you won't find in ANY other course, guaranteed.

  • Explore fun, interactive, and highly effective lessons from a best-selling Excel instructor.

  • Get LIFETIME access to project files, quizzes, homework exercises, and 1-on-1 expert support.

  • Build Excel formulas to analyze dates, text fields, values and arrays.

Description:

  • It's time to show Excel who is the boss. Whether you are starting from square one or aspiring to become an absolute Excel power user, you've come to the right place.

  • This course will give you a deep understanding of the advanced Excel formulas and functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool. While most Excel courses focus on simply what each formula does, We teach through hands-on, contextual examples designed to showcase why these formulas are awesome and how they can be applied in a number of ways.

  • We will not train you to regurgitate functions and formula syntax; We will teach you how to THINK like Excel.

 

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

  • Easily build dynamic tools & Excel dashboards to filter, display and analyze your data.

  • Go rogue and design your own formula-based Excel formatting rules.

  • Join datasets from multiple sources with Excel's LOOKUP, INDEX & MATCH functions.

  • Pull real-time data from APIs directly into Excel (weather, stock quotes, directions, etc.)

  • Manipulate dates, times, text, and arrays.

  • Automate tedious and time-consuming tasks using cell formulas and functions in Excel .

__________

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

  • V Lookup

  • Index & Match

  • Tips & Tricks

  • Statistical functions

  • Formula-based formatting

  • Date & Time functions

  • Pivot Tables & pivot Charts

  • Array formulas

  • Macros & VBA

  • Excel Pro Tips for Power Users

__________

Eligibility:

  • Excel users who have basic skills but want to get really, REALLY good.

  • Anyone hoping to expand their analytics skill set, work more efficiently with data, and take their career to a new level.

  • Students looking for an engaging, hands-on, and highly interactive approach to Excel analytics training.

  • Excel users looking to build strong analytical thinking and business intelligence skills.

  • Anyone looking to pursue a career in data analysis or business intelligence.