Must Know Excel Formulas and Functions
Learn how to use some must-know formulas and functions in Excel
Office Productivity,Microsoft,Excel
Lectures -3
Duration -1.5 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
More and more, your company is asking you to do some things with Excel spreadsheets that may leave you challenged or even overwhelmed.
Maybe someone else worked on a spreadsheet, and then they moved on, and now you are in charge of that spreadsheet.
That is called inheriting a spreadsheet. That is what it is actually called. But inheriting a spreadsheet is not as fun as inheriting a million dollars.
Maybe there are some formulas in the spreadsheet that you don’t understand. Or maybe your company is asking you to do certain tasks, and you know there must be a way to get those tasks done, but you don’t know how to actually do it.
Do you struggle with Excel formulas? Do calculations take a long time, and you know there must be a better way to accomplish things in Excel, but you don't know where to turn? Then this course is for you. This course will show you the most popular functions and formulas in Excel and how to use them very efficiently. This webinar will make you more productive in Excel.
Topics:
- Basic Math formulas
- Autosum and relative references
- Absolute references
- Range names
- Linking sheets and workbooks
- If, and, or, and the nested if functions
- Countif, Sumif, Averageif, Countifs, and Sumifs functions
- Vlookup and Hlookup functions
- Match and Index functions
- Date/time functions and calculations
- Text functions
- Tracking formulas
Goals
What will you learn in this course:
- Learn Excel formulas and Functions
Curriculum
Check out the detailed breakdown of what’s inside the course
Full Course
2 Lectures
- Preview 00:42 00:42
- Full Course 01:54:54 01:54:54
Instructor Details
Thomas Fragale
eCourse Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe nowOnline Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now