Learn 14 Advanced Formulas in Excel
Learn advanced time saving formulas in excel and also learn how to create dynamic data
Updated on Nov, 2023
Language - English
Duration -1 hours
Welcome to Microsoft Excel Course. Here you will learn a lot of things right from scratch. Learn How to open a file, save a file, then slowly move on to the advanced topics like How to create Dynamic Data, Using Choose, Workday, Networkday, Index, Match, Proper and more.
As we all know that Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android, iOS and iPadOS. It features calculation or computation capabilities, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.
Following Formulas are covered:
UPPER function changes all text to CAPITALS
LOWER function changes all text to lower case
PROPER function changes the first letter in each word to upper case and all other letters to lower case – Generally this is useful for fixing names.
TRIM function removes all spaces from text except for single spaces between words.
INDEX function returns a value or the reference to a value from within a table or range. There are two ways to use the INDEX function: If you want to return the value of a specified cell or array of cells, see Array form. If you want to return a reference to specified cells, see Reference form.
MATCH function searches for a specified item in a range of cells, and then returns the relative position of that item in the range.
WORKDAY returns a number that represents a date that is the indicated number of working days before or after a date (the starting date).
More Formulas like- NETWORKDAY, CHOOSE, AVERAGEIFS, COUNTIFS, SUMIFS.INTL and more....
Let's learn microsoft excel.
What will you learn in this course:
- Learn Index and Match Formulas
- Dynamic Table Creation Covered
- SUMIFS, COUNTIFS, AVERAGEIFS Included
- Learn Advanced Formulas in Excel
- Learn How to save time using excel
- Handle complex excel tasks with ease with Workday and Networkday Formulas
What are the prerequisites for this course?
- No prior experienced required. Learn Everything From Scratch
Check out the detailed breakdown of what’s inside the course
- UPPER-LOWER 04:27 04:27
- PROPER-TRIM 05:38 05:38
- Combined Formula 02:06 02:06
- VLOOKUP Limitation 03:48 03:48
- INDEX-MATCH 08:48 08:48
- Practice 1 03:49 03:49
- SUMIFS 05:54 05:54
- AVERAGEIFS-COUNTIFS 04:06 04:06
- Practice 2 02:41 02:41
- WORKDAY.INTL 05:01 05:01
- NETWORKDAY.INTL 02:35 02:35
- Presenting Data 02:27 02:27
- Dynamic Data 09:05 09:05
I have expertise in Linux,Ethical Hacking,Cloud Computing,Hardware and Networking. I have 6+ years of Teaching Experience. I am a Ex Senior Trainer at one of India's top Computer Institute. I have many Certifications to prove my knowledge- RHCSA,RHCE,Openstack,Hybrid Cloud Storage,EC-COUNCIL CEH, CCAS CEH, CompTIA Strata, Virtualization, CHNA and many more other Certifications
User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.
Our students work
with the Best
Related Video CoursesView More
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video CoursesSubscribe now
Master prominent technologies at full length and become a valued certified professional.Explore Now