Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Excel Formulas and Functions: Tips, Tricks, and Shortcuts
Rating: 4.8 out of 5(13 ratings)
2,772 students

Excel Formulas and Functions: Tips, Tricks, and Shortcuts

Master Excel Formulas and Functions with Essential Tips, Tricks, and Shortcuts to Boost Your Productivity.
Created byLogic Labs
Last updated 1/2026
English
English [Auto],

What you'll learn

  • Difference between Workbook and Worksheet
  • Create, Open, Save Workbook
  • Entering and Editing Data
  • Navigation and Selection
  • Formulas and Functions
  • IF Function
  • Min and Max Functions
  • Sum, Count and Average Function
  • Absolute and Relative Cell Referencing
  • LOOKUP, VLOOKUP and HLOOKUP Function
  • MATCH and INDEX Function
  • AutoSum and AutoFill and More

Course content

1 section • 28 lectures • 4h 14m total length

  • Navigation and Selection12:24

    Learn to navigate and select in Excel with keyboard shortcuts, jump to data edges, select rows or columns, insert or delete cells, and use go to, find, replace, and hyperlinks.

  • Create, Open, Save Workbook10:07

    Create, open, and save workbooks in Excel using a new blank workbook, templates, and save options. Learn keyboard shortcuts Ctrl+S and Ctrl+O, and save to OneDrive or this PC.

  • Entering and Editing Data14:13

    Learn to enter and edit data in Excel, including numbers, dates, times, and text. Then apply formatting, autofill, data validation, and basic copy/paste and undo.

  • Formulas and Functions15:17

    Master Excel formulas and functions, from basic sums and averages to text and date functions like today, concatenate, trim, and left/right/mid, with tips and shortcuts for beginners and intermediate users.

  • IF Functions5:54

    Master the Excel if function to perform logical tests and return value if true or value if false, explore its syntax and nesting up to seven, and apply real-world examples.

  • Sum Functions9:50

    Master the sum function in Excel to add numbers across a range of cells, use AutoSum for quick totals, and handle errors to produce accurate results.

  • Count Functions11:28

    Master the count function in Excel to tally numbers, dates, currencies, and text in a range, and explore count blank and count if with up to 255 arguments for criteria.

  • Average Functions5:21

    Master the Excel average function to calculate the average across a range using the formula bar or insert function, and use autosum to access related options while handling data errors.

  • Absolute and Relative Cell Referencing4:46

    Explore absolute and relative cell referencing in Excel, learn how to lock references with the dollar sign and F4, and apply mixed references for reliable formulas.

  • LOOKUP Functions10:28

    Explore how the lookup function searches a range and returns matching values, handling vertical and horizontal lookups and approximate matches to streamline data, prices, and item lookups.

  • VLOOKUP Functions14:19

    Explore the VLOOKUP function, learn its arguments (value, table array, column index, range lookup), and practice exact and approximate matches to retrieve prices and stock data.

  • HLOOKUP Functions11:28

    Learn to use Hlookup to perform horizontal lookups in Excel, detailing the lookup value, table array, row index, and range lookup for exact or approximate matches, with practical examples.

  • MATCH Functions7:07

    Master the match function in Excel to locate value’s position in a range using a lookup value, lookup array, and match type. Understand exact and approximate matches in sorted data.

  • INDEX Functions8:54

    Explore the index function in Excel to retrieve data from tables by selecting an array, rows, and columns, and compare it with Vlookup for dynamic, multi-criteria data retrieval.

  • AutoSum and AutoFill9:44

    Master AutoSum and AutoFill in Excel to quickly compute sums, averages, and other values by selecting ranges, using the alt or equal shortcut, and applying AutoFill across rows and columns.

  • Flash Fill6:21

    Master Excel Flash Fill to automatically split, combine, and transform data in seconds, from names and numbers to capitalization and formatting, streamlining data manipulation tasks.

  • Named Ranges8:23

    Discover how named ranges in Excel simplify formulas by replacing cell references with meaningful names, and learn to create, manage, and use them across worksheets with name manager.

  • Managing Named Ranges6:39

    Master named ranges in Excel to boost formula readability, reduce errors, and support an interactive dashboard and data visualization.

  • Applying Date and Time Formats4:48

    Apply date and time formats in Excel using built-in date and time formats, today and time shortcuts, and custom number formats to display day, date, and time.

  • Formatting Cells, Rows and Columns6:58

    Explore practical Excel formatting tips for cells, rows, and columns to create clean, organized, and professional spreadsheets, including autofit width, wrap text, and inserting or deleting columns and rows.

  • Format Painter7:11

    Learn to use the format painter in Excel to copy formatting across cells and worksheets, matching styles, colors, and conditional formatting rules quickly and consistently.

  • Working with Cells, Rows & Columns7:48

    Learn to work with cells, rows, and columns in Excel. Resize column widths and row heights, navigate with keyboard or mouse, and insert or delete cells, rows, or columns efficiently.

  • Alignment of Text9:03

    Master text alignment in Excel by applying left, center, and right alignments and vertical positions like top, middle, and bottom. Learn to merge and center to create headers and readability.

  • Create Filter3:05

    Master Excel filters for data analysis by sorting data, using top headers, and applying conditional filters such as greater than 500 to reveal insights.

  • Sorting Data6:52

    Learn to sort data in Excel with ascending and descending orders, sorting by name, gender, or department, using headers and custom lists for ordered results.

  • Drop Down lists9:35

    Master drop down lists in Excel by using data validations to limit entries, define a source, build a table, and create an interactive, error-reducing data entry form.

  • Charts & Graphs15:02

    Explore charts and graphs in Excel to visualize data; choose from column, line, pie, bar, scatter, and area charts, then customize data, titles, axes, colors, and labels for compelling visuals.

  • Headers and Footers11:04

    Master Excel headers and footers to enhance printed reports with page numbers, dates, and file names. Learn to insert, customize, and preview headers across pages.

Requirements

  • No Prior Excel Knowledge Required

Description

Take your spreadsheet skills to the next level with this practical and engaging course on Excel Formulas and Functions. Whether you are new to Microsoft Excel or looking to refine your abilities, this course will help you work smarter, faster, and more confidently.


Excel is one of the most powerful tools in the modern workplace, and mastering its formulas and functions can dramatically improve your productivity. By the end of this course, you’ll understand how to use Excel not just for basic tasks but for meaningful data analysis and problem-solving.


I will start with the foundational formulas every user should know, including SUM, AVERAGE, COUNT, and IF. These building blocks will give you the confidence to handle numbers, text, and logical operations with ease inside Microsoft Excel.


From there, you’ll dive into more advanced Excel functions such as VLOOKUP, XLOOKUP, INDEX, MATCH, and various date and text functions. Each concept is explained clearly, with step-by-step demonstrations that show you exactly how to apply them.


To help you work more efficiently, the course also includes powerful Tips, Tricks, and Shortcuts used by professionals every day. You’ll learn keyboard shortcuts, time-saving techniques, and smart methods that reduce repetitive work and streamline your spreadsheets.


Throughout the course, you’ll practice with real-world examples designed to mirror the types of challenges found in business, finance, marketing, human resources, and data management. These hands-on exercises will give you practical experience applying formulas and functions to real situations.


You’ll also discover how to troubleshoot formulas, avoid common errors, and build spreadsheets that are clean, organized, and easy to maintain. By understanding how Excel thinks and calculates, you’ll gain the confidence to solve problems quickly and effectively.


What You Will Learn

  • Master essential formulas like SUM, AVERAGE, COUNT, IF, VLOOKUP, HLOOKUP, and XLOOKUP

  • Work with text functions: LEFT, RIGHT, MID, CONCAT, TEXTSPLIT, TEXTJOIN

  • Use logical and conditional functions for smarter automation

  • Apply advanced formulas such as INDEX & MATCH, OFFSET, INDIRECT, FILTER, SORT, UNIQUE

  • Use date & time functions to manage schedules and timelines

  • Create dynamic data models using new Excel functions

  • Boost productivity with keyboard shortcuts and quick tricks

  • Solve real-world problems using formula-based techniques

  • Clean, reshape, and analyze data with formula-driven methods

  • Build professional, error-free spreadsheets with confidence


Why Take This Course?

  • This course takes a step-by-step, example-driven approach that ensures you truly understand how each formula works and when to use it. Instead of memorizing formulas, you will learn how to think in Excel—a skill that opens doors in almost every field.

  • With plenty of tips, keyboard shortcuts, and real-life exercises, you’ll become faster, more efficient, and more confident in Excel than ever before.


You’ll learn how to combine multiple functions to create powerful formulas that automate complex tasks. This ability to stack and integrate functions is what separates casual users from advanced Excel practitioners.


Whether your goal is to speed up your workflow, enhance your analytical skills, or impress employers with stronger Excel knowledge, this course provides everything you need. With a blend of formulas, functions, tips, tricks, and shortcuts, you’ll be equipped to work at a professional level.


Enroll today and unlock the full potential of Microsoft Excel. With the right tools and techniques at your fingertips, you’ll transform the way you work and gain valuable skills that can benefit any job, project, or career path.

Who this course is for:

  • Anyone who wants to master functions quickly and effectively
  • Students, professionals, and Excel beginners looking to improve their formula skills
  • Anyone dealing with business reports, data entry, or data organization
  • Job seekers preparing for interviews that require Excel knowledge

Report abuse