Subscribe
Tutorial search

3 Special Excel Functions to Amaze You - Excel tutorial


Want to up your Microsoft Excel game? This article will show you how to master three functions that will bring your skillset to the next and make you an Excel Wizard!
Category: Excel > Functions - Difficulty:


More cool Excel tutorials:



GROUP and UNGROUP in Excel
GROUP and UNGROUP in Excel
Learn how to group and ungroup rows and columns so that you can easily hide or unhide the rows and columns you are interested in.
Difficulty:
TEXT Function
TEXT Function
Shows how to use the TEXT function in Excel to improve the formatting of joined cells e.g. Score= 0.4 to Score= 40%.
Difficulty:
End of Month function in Excel
End of Month function in Excel
The EOMONTH (end of month) function allows you to generate a month end date no matter what the original date (even taking into account leap years). Extremely useful when you want to report on standardized dates.
Difficulty:
Return the Weekday of a Date
Return the Weekday of a Date
This tutorial shows how to extract the weekday of any date by using the WEEKDAY function.
Difficulty:
Excel Date & Time Functions
Excel Date & Time Functions
Dates and times are stored as numbers in Excel and count the number of days since January 1st, 1900.
Difficulty: