Using Excel Vlookup function

Excel Tip: Need to lookup a value? It’s easy with VLOOKUP! Use VLOOKUP when you need to find data in a table or a range by row. For example, look up an employee’s tax rate in a tax table as shown in the screen shot below.

In its simplest form, the VLOOKUP function says:

=VLOOKUP(What you want to look up (SALARY), where you want to look for it (a table I named Taxtable), the column number in the range containing the value to return (the second column in the table), return an Approximate or Exact match – indicated as 1/TRUE, or 0/FALSE) (TRUE in this case because I don’t want an exact match). The exact formula is displayed in the screenshot.

Contact me at sharon_daniel@att.net for support on the VLOOKUP function. Whether you need Excel tutoring, advice on cleaning up your Excel data, creating formulas or solving formula issues, count on me!

excel Line Charts

Excel Tip: When creating line charts, change the default starting number from 0 to one closer to the data range. The line charts in the screen shots below are for the same data. Notice how flat the left line chart is with a starting point of 0. The right line chart shows more variation because I changed the starting point to 60.

Contact me at sharon_daniel@att.net for support on Excel charts. Whether you need Excel tutoring, advice on cleaning up your Excel data, creating formulas or solving formula issues, count on me!

Pivottable slicers

Take your PivotTables to a new level by using Filters and Slicers to analyze data! Slicers provide buttons that you can click to filter PivotTables. You can narrow the scope of what you want to review.

Contact me at sharon_daniel@att.net for support on taking your PivotTables to the next level. Whether you need Excel tutoring, advice on cleaning up your Excel data, creating formulas or solving formula issues, count on me!