UDEMY
UDEMY Logo

Advanced Excel - Top Excel Tips & Formulas 

  • Offered byUDEMY

Advanced Excel - Top Excel Tips & Formulas
 at 
UDEMY 
Overview

Develop insightful reports and become more efficient and valuable assets to their teams and organizations

Duration

7 hours

Total fee

599

Mode of learning

Online

Official Website

Go to Website External Link Icon

Credential

Certificate

Advanced Excel - Top Excel Tips & Formulas
 at 
UDEMY 
Highlights

  • Earn a certificate after completion of the course
  • 30-Day Money-Back Guarantee
  • Full Lifetime Access
  • Access on mobile and TV
  • 8 downloadable resources
Read more
Details Icon

Advanced Excel - Top Excel Tips & Formulas
 at 
UDEMY 
Course details

Who should do this course?

You currently use Microsoft Excel and want to improve your skills

You want to be sure you have the Excel knowledge necessary to officially call yourself "advanced"

You are a student, planning to take on a job that requires sound Excel knowledge

You are a financial analyst who uses Excel on a daily basis and would like to learn if there is more to it than you currently know

What are the course deliverables?

Be a Confident & Advanced Microsoft Excel user
Able to solve complex problems in Excel
Learn new techniques and formulas to tackle tasks faster and better in Excel
Apply the right tools for a given task instead of going to your go-to tools and making them work for every situation
Reduce complexity of your spreadsheets

More about this course

This course is designed to elevate users’ Excel skills beyond the basics, focusing on advanced techniques and formulas to boost productivity, data analysis, and decision-making

It equips learners with the knowledge to handle complex datasets, create sophisticated reports, and automate tasks using Excel’s powerful features

 

Advanced Excel - Top Excel Tips & Formulas
 at 
UDEMY 
Curriculum

Introduction Scope and Excel Files

Advance Excel Inroduction and Scope 

Course Outline for Quick Reference
 

Top 10 Excel Tips to Save You Time

Become Faster with Excel's Keyboard Shortcuts
Master the Simpler Tasks: Part 1
Master the Simpler Tasks: Part 2
Quickly Navigate Larger Files
Extended - Unhide Hidden Names with VBA
Use Protection Appropriately
Test Your Knowledge - Top 5 Tips (Don't Skip)
Improve Presentation with Customized Number Formatting
Solve Problems With Goal Seek
Tip Use Excel PivotTables for Super Fast Analysis
 

Top 10 Excel Formulas for Quick & Dynamic Analysis

SUMIFS, COUNTIFS, AVERAGEIFS to Account for Exceptions
IF (Nested Functions) Because Data Analysis is Often Not Simple
IFERROR for Credible Reports
VLOOKUP & HLOOKUP For Dynamic Lookups
INDEX & MATCH for Flexible Lookups
INDEX & MATCH for Complex Real-Cases
The Most Useful Text Functions

 

Formula Combinations for Real Cases 

YTD Calculations - SUM, SUMPRODUCT & OFFSET 
3 Ways to Lookup within Boundaries: SUMIFS, SUMPRODUCT & NDEX
Sum Alternate Columns based on Selection - SUMIFS & INDEX
Sum Alternate Columns - SUMPRODUCT

 

Wrap Up

Final Words
SPECIAL BONUS: Discover Exciting Offers!

 

 
Faculty Icon

Advanced Excel - Top Excel Tips & Formulas
 at 
UDEMY 
Faculty details

Leila Gharani
Leila Gharani is a Microsoft MVP (Most Valuable Professional) dedicated to helping you create outstanding tools and reports in Excel & Google Sheets. Her courses are for those who want to shine at work, accelerate their careers and achieve more in less time.

Other courses offered by UDEMY

549
50 hours
– / –
3 K
10 hours
– / –
549
4 hours
– / –
599
10 hours
– / –
View Other 2344 CoursesRight Arrow Icon
qna

Advanced Excel - Top Excel Tips & Formulas
 at 
UDEMY 

Student Forum

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