Excel How Tos

Excel IF Formula Guide

Excel IF Formula

Sunbird Advisers has created a basic guide to an IF formula in Excel. For more information on how to create an IF formula for your spreadsheets click here.

An IF function is a great way of categorising your data.

If you would like to receive some other guides, please get in touch.

Excel VLOOKUP Formula Guide

Excel VLOOKUP Formula

Sunbird Advisers has written a basic guide to a VLOOKUP for beginners who want to learn how to use the formula and save so much time collating information from different worksheets. Click here to find out more.

A VLOOKUP function is a great way of collating information, for example if you have someone’s name and address in one worksheet, and their name and phone number in another, you might want to collate their name, address and phone number all in one spreadsheet. A VLOOKUP will enable you to do that.

Excel SUMIF Formula Guide

Excel SUMIF Formula

Sunbird Advisers has created a basic guide to a SUMIF formula in Excel. For more information on how to create a SUMIF formula for your spreadsheets click here.

A SUMIF function is a great way summing up data that meets a criterion.

If you would like to receive some other guides, please get in touch.

Want help with another formula?

Excel Formulas

Would you like help with another formula?

Please get in touch here for help.

Meet Your Instructor, Gina Cohen

Microsoft Excel, PowerPoint, Word, Outlook and Teams trainer and Spreadsheet Consulting specialist with eleven years experience in the Finance department at Morgan Stanley. Has been teaching and consulting since 2013.

Get In Touch

PHONE

07887 552 045

Gina Cohen
Scroll to Top