Jorge Fontainhas

1 follower
·
3 following
Jorge Fontainhas
More ideas from Jorge
Learn Excel IF Formula – 5 Tricks you Didnt know

Learn Excel IF Formula – 5 Tricks you Didnt know

The VLOOKUP function is designed to return only the corresponding value of the first instance of a lookup value. But there is a work-around to identify multiple matches. Although VLOOKUP is not used in these array formulas, they are easier to understand and troubleshoot. Return multiple values vertically Array formula in C8: =INDEX($C$2:$C$6, SMALL(IF($B$8=$B$2:$B$6, ROW($B$2:$B$6)-MIN(ROW($B$2:$B$6))+1, “”), ROW(A1))) Enter the formula as an array formula or use this regular but mo...

These 10 tips will help you do data entry faster and more accurately so you have time to do things that are more fun and fulfilling! Read on to discover our Top 10 Excel Data Entry tips

Insert Checkboxes In Excel 2010

Excel provides very useful Form Controls which enable users to create a control & operate several things simultaneously. You can add Buttons, checkboxe

Totals In Excel With No Formulas!

Easy totaling in Excel is not restricted to Pivot Tables.

Windows 10 Has a Secret Start Menu. Here’s How to Open It.

There is a lot involved with article marketing, but gaining this knowledge can lead to great success. Tips That Will Help You Make Money Through Article Marketing.

Tutorial 6 of 8 - Slicers in Excel - EASY Excel Tutorial

This section explains the basics of Excel. It is good to know the basic terminology explained in this section before you start using Excel.

How to Master Microsoft Office Excel

Whether you're a college student or city dweller, most of us have workspaces and offices much smaller than we'd like. Here's how to get the most from your workspace, no matter how small it is.

Excel Formulas: 10 Formulas That Helped Me Keep My Job - Advanced Excel Tips & Tricks

kolorpencil: 7 Solutions That Have Helped Me Keep My Baby Away From Diaper-Related Skin Problems