Tutorialspoint

Celebrating 11 Years of Learning Excellence! Use: TP11

Excel Mastery : Advanced Formulas, Functions & shortcuts (Part1)

person icon Rohidas Kotkar

4.5

Excel Mastery : Advanced Formulas, Functions & shortcuts (Part1)

From Beginner to Pro: Conquer Excel with Advanced Formulas, functions & shortcuts

updated on icon Updated on Jun, 2025

language icon Language - English

person icon Rohidas Kotkar

category icon Office Productivity,Microsoft,Excel

Lectures -29

Resources -3

Duration -3 hours

Lifetime Access

4.5

price-loader

Lifetime Access

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

Discover Excel's 111 most indispensable functions covering a wide spectrum, from logical and mathematical operations to text manipulation, statistical analysis, financial calculations, and nested formulas. Whether you're performing complex data analysis, financial modeling, or simply formatting text, this comprehensive collection equips you with the essential tools to tackle diverse tasks efficiently, making Excel an indispensable tool for professionals across industries.

Excel's text manipulation functions, including LEFT, RIGHT, UPPER, LOWER, PROPER, SEARCH, and FIND empower users to efficiently extract, modify, and search for text within cells, facilitating precise data manipulation and analysis in spreadsheets. These functions streamline tasks such as text formatting, case conversion, and locating specific text strings, enhancing productivity and accuracy in Excel workflows.2

Logical functions such as IF, AND, OR, and NOT facilitate decision-making and conditional logic operations. Financial functions like PV, FV, NPV, and IRR aid in financial analysis, planning, and investment evaluation.

Statistical functions in Excel, including AVERAGE, MAX, MIN, and COUNT, provide essential tools for analyzing and summarizing data, enabling users to derive insights and make informed decisions based on numerical information.

Information functions such as ISNUMBER, ISBLANK, and ISTEXT help validate and analyze data types and properties, ensuring data accuracy and integrity. Compatibility functions like CONVERT and COMPLEX facilitate smooth data exchange across different systems and units, enhancing interoperability within spreadsheets.

Stop wasting time clicking!  Our 101 Excel shortcut course unlocks the secrets to lightning-fast work. Learn the techniques that Excel masters use and become a productivity powerhouse.

By the end, you'll be a master of formulas and functions, shortcut keys, and customizing every aspect of your spreadsheets to create professional, impactful reports.

Are you ready to unleash the full potential of Excel? Enroll now and join the ranks of the spreadsheet Jedi Knights!

Goals

  • Enable students to achieve more with less effort, less time, and less investment, maximizing productivity and efficiency in data management, and reporting tasks.
  • Advanced Formulas and Functions: Mastery of complex functions such as XLOOKUP, TEXT, INDEX-MATCH, IFERROR, VSTACK, COUNTIFS, and nested functions.
  • Work Smarter, Not Harder: Unleash the Power of Excel Shortcuts.
  • Advanced Data Visualization: Creation of interactive dashboards using Excel's features like slicers, timelines, combo charts, trendlines, and data validation.


Prerequisites

  • Access to Excel Software: Access to Microsoft Excel software (preferably the latest version like 2013, 2016, 2019, or Office 365 is essential.
  • Basic Excel Skills: Understanding of fundamental Excel concepts such as entering data, copying data, saving files, etc.
  • Consistency & willingness to Learn: Commitment to completing all course contents, and assignments, and actively participating in course activities is crucial for maximizing the learning experience.
  • Laptop or desktop.
Excel Mastery : Advanced Formulas, Functions & shortcuts (Part1)

Curriculum

Check out the detailed breakdown of what’s inside the course

Mindset and Scope of the course

1 Lectures
  • play icon Mindset and Scope of the course. 04:20 04:20

Mathematics and trigonometric functions

5 Lectures
Tutorialspoint

Lookup & Reference functions

4 Lectures
Tutorialspoint

Date and time

3 Lectures
Tutorialspoint

Logical and Financial

3 Lectures
Tutorialspoint

Text functions

3 Lectures
Tutorialspoint

Statistical functions

3 Lectures
Tutorialspoint

Information and compatibility functions

4 Lectures
Tutorialspoint

Excel Short-cut keys

3 Lectures
Tutorialspoint

Instructor Details

Rohidas Kotkar

Rohidas Kotkar

With over 12 years of experience, I'm a seasoned Advanced Excel trainer specialized in corporate environments. In excel, I am teaching advanced Excel functionalities, boosting productivity, and fostering efficient data-driven decision-making. My training approach to empowers professionals to harness Excel's full potential for success in today's competitive business landscape.

we are dedicated to taking your Excel skills to new heights and empowering you to become an Excel Pro. Whether you’re an Excel enthusiast looking to elevate your skills to an advanced level or a professional seeking to enhance your productivity, our coaching classes are tailored to meet your specific needs and goals.

Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515