Skillshare
Skillshare Logo

Excel: Top 10 Excel Formulas to Work Smarter 

  • Offered bySkillshare

Excel: Top 10 Excel Formulas to Work Smarter
 at 
Skillshare 
Overview

Duration

3 hours

Mode of learning

Online

Schedule type

Self paced

Difficulty level

Intermediate

Official Website

Go to Website External Link Icon

Credential

Certificate

Excel: Top 10 Excel Formulas to Work Smarter
 at 
Skillshare 
Highlights

  • Skills Covered: Spreadsheets, Microsoft Excel, Microsoft Office, Business Analytics
  • Learn Microsoft Excel tips and tricks
  • Learn from Leila Gharani, Excel Instructor & Business Consultant
Details Icon

Excel: Top 10 Excel Formulas to Work Smarter
 at 
Skillshare 
Course details

More about this course
  • This top 10 Excel formulas Course introduces you to the most useful functions that will save you time on the job. You will work faster. You will work smarter.

Excel: Top 10 Excel Formulas to Work Smarter
 at 
Skillshare 
Curriculum

Advanced Excel: Top 10 Formulas to Work Smarter

Formula 1 - SUMIFS, COUNTIFS, AVERAGEIFS to Account for Exceptions

Formula 2 - IF (Nested Functions) Because Data Analysis is Often Not Simple

Formula 3 - IFERROR for Credible Reports

Formula 4 - VLOOKUP & HLOOKUP For Dynamic Lookups

Formula 5 - INDEX & MATCH for Flexible Lookups

Formula 5 - INDEX & MATCH for Complex Real-Cases

Formula 6 - The Most Useful Text Functions

Formula 6 - Advanced TEXT functions

Formula 7 - Excel's Top Date Functions

Formula 8 - OFFSET for Dynamic Calculations

Formula 9 - FREQUENCY, SMALL & LARGE to Organize and Rank

Formula 10 - SUMPRODUCT For the Gurus

Other courses offered by Skillshare

– / –
12 hours
Beginner
– / –
20 hours
Beginner
– / –
8 hours
– / –
– / –
2 hours
– / –
View Other 109 CoursesRight Arrow Icon
qna

Excel: Top 10 Excel Formulas to Work Smarter
 at 
Skillshare 

Student Forum

chatAnything you would want to ask experts?
Write here...