Course

Excel for Beginners: Advanced Functions

Coursera Project Network

This 1-hour, project-based course, "Excel for Beginners: Advanced Functions," is designed to introduce learners to more-advanced spreadsheet functions using Excel on the Web. The course covers advanced conditional functions and reference functions in a hands-on manner, making it applicable to other spreadsheet programs like LibreOffice Calc and Google Sheets.

  • Learn to manage data more easily using advanced conditional functions like COUNTIF and COUNTIFS.
  • Create conditional data by combining basic arithmetic with logic into functions like SUMIFS and AVERAGEIFS.
  • Quickly search and obtain specific values in tables with reference functions like VLOOKUP, XLOOKUP, INDEX, and MATCH.

Certificate Available ✔

Get Started / More Info
Excel for Beginners: Advanced Functions
More Business Essentials Courses

Representante de desarrollo de ventas de Salesforce

SV Academy & Salesforce

Develop essential skills for a lucrative career in technology sales with this comprehensive course, perfect for beginners and experienced retail sales professionals...

Introduction to Negotiation: A Strategic Playbook for Becoming a Principled and Persuasive Negotiator

Yale University

This course offers a strategic playbook for becoming a skilled negotiator, emphasizing principled arguments and uncovering underlying interests. Students engage...

What is Compliance?

University of Pennsylvania

This course explores the multifaceted impact of compliance on businesses and organizations, emphasizing the importance of ethical and robust compliance programs...

Introduction to SAFe: Navigating Scaled Agile Framework

Board Infinity

Embark on a journey through the intricacies of the Scaled Agile Framework in the "Introduction to SAFe: Navigating Scaled Agile Framework" course, designed...