When autocomplete results are available use up and down arrows to review and enter to select. Touch device users, explore by touch or with swipe gestures.

# Microsoft excel formulas

## Collection by Bjarki Guðmundsson • Last updated 4 days ago

183
Pins
•
24
Followers

To make a workable and practical drop down list in Excel we need to get a sorted unique data for from the data range that is unsorted and has duplicates. An...

Following are the tricks you can do with the features Excel tables offer. Following list is in no particular order. I think all of them are handy that every excel user must know to make his/her work more easy. As there are more than 20 tricks you can perform with tables, the whole article has […]

101 Advanced Excel Formulas & Functions Examples | Learn the most popular Excel formulas & functions like VLOOKUP, INDEX, MATCH, IF, SUMPRODUCT, COUNT, SUMIF & more!

If you have several excel sheets to work on and all the sheets share exactly the same data with exactly the same format. Than instead of copying and pasting the same data on different sheets we have a much better way for you do to do this in Excel. Have the workbook open, press and […]

In this tutorial, I cover all the possible ways you have to recover unsaved Excel FIles, as well as some precautions you can take to avoid losing your work

0:38

Excel Upskillin🎢 (@rapid_upskillin) has created a short video on TikTok with music original sound. | #learnexcel #excelformarketers #exceltips #edutok #edutoktech #foryou #digitalmarketingexpert #learnontiktok #microsoftexcel #productivity #wfh | @rapid_upskillin

Excel conditional functions are part of almost every worksheet. The logical test functions help us carry out different operations easily. While discussing SUMIF we learnt to sum the values based on one criteria i.e. date. However, what if we want to sum up the values not only on the basis of date but also the […]

Here you will find a detailed tutorial on 100+ Excel Functions. Each function is covered in detail with a practical Examples and Video.

SWITCH Formula in Excel - Learn how to evaluate multiple conditions in Excel in just a few steps! I will show you in this free tutorial...

In this tutorial we will learn how to format Data labels in Excel Charts to make them dynamically change their colors. And also how to insert any symbols in ...

Learn how to Create a Scroll Bar in Excel. A useful feature when you want to show a dynamic scrollable list to save space on you worksheet.

Learn how to easily insert a watermark in Excel Worksheets. It could be a company logo or a WIP/Draft mark to show report status

Free download a cheat sheet with 100+ common Microsoft Excel Formulas and Functions for beginners for their daily use.

Creating a KPI Dashboard in Excel to identify companies based on their performance. It also enables users to deep-dive into individual company's performance

In this VLOOKUP tutorial learn how to switch between multiple LOOKUP data ranges based on criteria using IF function and apply VLOOKUP on different ranges

Excel has many different styles of charts and graphs inbuilt and one can make them with a single click. A great convenience to have. But for charts and graphs convenience is required, merited and appreciated if its easy for the user to understand. As humans progressed, same way their expression and the manner to present […]