Explore Computer Tips, Magic Tricks, and more!

Explore related topics

Use Excel CONVERT Function to change values from one measurement type to another. Get free Excel workbook.

Excel date picker tool - makes worksheet calendars too

Excel Date Picker Tool

If you’d like a quick and easy way to add dates in a worksheet, you can use this handy date picker tool, from Jim Cone.

How to Sort and Filter Data in Microsoft Excel: Excel Database Overview

Track Contacts, Collections, and Other Data with an Excel Database

This step by step tutorial shows you how to create a database in Excel. The tutorial covers entering data, creating the database, and using the built in sorting and filter tools.

7 Ways to Sum in Excel http://blog.contextures.com/

7 Ways to Sum in Excel

What was the first function that you learned in Excel – if you can remember that far back? I’ll bet it was the SUM function. There’s an AutoSum button on the Ribbon that makes.

Extract Data from Drop down List Selection in #Excel

Creating a Drop Down Filter to Extract Data Based on Selection

Excel INDIRECT function - named range data

How to Use Excel INDIRECT Function (Examples + Video)

In this tutorial, learn how to use Excel INDIRECT Function. INDIRECT function returns the reference specified by the text string. It is a volatile function.

Tweet Tweet   One of the keyboard shortcuts that I use most often in Excel allows you to quickly move around big spreadsheets by jumping to the start, end, top or bottom of the table. It is also the basis for some of the most repeated VBA Macro code snippets that I use. There are …

Tweet Tweet One of the keyboard shortcuts that I use most often in Excel allows you to quickly move around big spreadsheets by jumping to the start, end, top or bottom of the table. It is also the basis for some of the most repeated VBA Macro code snippets that I use. There are …

Enter forecast and actual amounts in this Excel template; see variance, and YTD totals

Get this free Excel workbook to enter budget forecast amounts and actual amounts. Formulas show year to date amounts and calculate variance

Different Drop Down Lists in Same Excel Cell

Different Drop Down Lists in Same Excel Cell

You can use data validation to create drop down lists in Excel. With a bit of Excel magic, you can create dependent drop down lists, so the selection in one drop down controls what.

Microsoft Excel VLOOKUP Tutorial for Beginners - Office Excel 2003, 2007, 2010 - YouTube

Teaches you how to use a VLOOKUP function within Excel This video goes over common mistakes and shows how to fix them.

Tom’s Tutorials For Excel: Blinking Cells and Flashing Objects

Tom’s Tutorials For Excel: Blinking Cells and Flashing Objects

Learn how to use multiple criteria in Excel COUNTIF and COUNTIFS function #Excel #ExcelTips #ExcelFunctions

How to Use Multiple Criteria in Excel COUNTIF and COUNTIFS

In this tutorial, learn how to use multiple criteria in Excel COUNTIF and COUNTIFS functions. Explained with practical examples.

Pinterest
Search