The VLOOKUP and HLOOKUP functions, together with INDEX and MATCH,  are some of the most useful functions in Excel. Note: The Lookup Wizard feature is no longer available in Excel. Here's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE) In this example, B2 is the first argument —an element of data that the function needs to work.

Discover how to convert numbers into English words in an Excel spreadsheet using the SpellNumber sample function.

Add a shared mailbox to Outlook mobile. Open a shared Mail, Calendar or People folder in Outlook for Mac. Learn how to open a shared mailbox in Outlook. Shared mailboxes let a group of users view and send email, and share a calender, and open a contact list from a common mailbox.

Help keep your PC up to date with the latest free service packs and updates for your version of Windows. Download a free language pack to see Windows in the language of your choice. Download more apps for your Windows tablet or computer here.

If you have tasks in Microsoft Excel that you do repeatedly, you can record a macro to automate those tasks. A macro is an action or a set of actions that you can run as many times as you want. When you create a macro, you are recording your mouse clicks and keystrokes.