Struggling to manage and analyze data efficiently can hinder productivity and decision-making. In this course, Mastering Excel Functions, you’ll learn to harness the full power of Excel to streamline your workflows and uncover insights. First, you’ll explore foundational functions like SUM, AVERAGE, and IF to manipulate data effortlessly. Next, you’ll discover advanced data analysis techniques with VLOOKUP, INDEX-MATCH, and PivotTables. Finally, you’ll learn how to automate repetitive tasks using macros. When you’re finished with this course, you’ll have the skills and knowledge of Excel needed to efficiently manage, analyze, and report data.
Author Name: Doru Catana
Author Description:
Audacious Leap, the digital marketing agency I founded has created and run hundreds of projects in dozens of industries ranging from notebook manufacturers in Australia, to bikes in Dublin Ireland, iOS apps and lawyers in Canada, real estate & stationery in the US, tennis supplements in France and business consulting in the Netherlands, I decided to share my experience from both successful and not-so-successful campaigns in the form of a series of marketing courses. All my courses are based on e… more

Table of Contents

• Orientation
  6mins
• Foundations of Excel Functions
  17mins
• Working with Data
  23mins
• Decision Making and Logical Operations
  12mins
• Mastering Lookup and Reference
  26mins
• Advanced Math and Custom Function Creation
  13mins
• Advanced Function Applications in Data Analysis
  15mins
• Beyond Functions
  5mins