S. No.

Emp ID Name Prefix First Name Middle Initial Place Name

1 850297 Ms. Shawna W Las Vegas

2 412317 Drs. Elisabeth W Lexington

3 621375 Mrs. Briana C Munster

4 787549 Hon. Estella L Fairbanks

5 795934 Ms. Melinda L Stowell

6 159108 Mrs. Shanna U Herndon

7 330816 Ms. Jasmine J Ocoee

8 532002 Ms. Madge V Springfield

9 612850 Ms. Bethany Z Montgomery

10 265124 Ms. Tonia J Friant

11 369712 Mrs. Yesenia B Reisterstown

12 308617 Mrs. Aileen D Herman

13 766783 Mrs. Marta N Hoquiam

14 513011 Ms. Tara Y Sheldon

15 253588 Ms. Keri J Friendship

16 583924 Mrs. Adrienne H Burlingame

17 932453 Mrs. Beatriz I Arlee

18 721098 Ms. Isabel Q Tupelo

19 186102 Drs. Marcia N Victoria

20 893976 Ms. Beverly I Rossville

21 590579 Ms. Priscilla Z Fairview

22 297741 Ms. Lynn E Castleton

23 458320 Ms. Tessa D Austinville

24 136626 Ms. Carmela D Keystone Heights

25 201710 Ms. Karyn A Ardenvoir

26 722543 Ms. Lesa E Terre Haute

27 601071 Ms. Liz H Amherst

28 269523 Hon. Kendra X Beaman

29 310986 Drs. Maryellen R Tuckerman

30 602683 Ms. Alberta A Rochester

31 798646 Ms. Patsy N Atlanta

32 929791 Ms. Esperanza E Lexington

33 141326 Hon. Patricia C Easton

34 946835 Hon. Marjorie J Baldwin City

35 894936 Ms. Vivian T Hampden Sydney

36 381338 Ms. Miriam A Brady

37 185077 Ms. Nichole S Bangor

38 248449 Ms. Carlene E Houston

39 970502 Drs. Nora I Woolstock

40 166615 Mrs. Jayne O Norfolk

41 114425 Mrs. Doris G Blaine

42 676618 Drs. Tabatha C Steelville

43 257927 Ms. Agnes J Sugar City

44 144114 Mrs. Nancy P Cypress

45 593953 Drs. Tara A Zephyrhills

46 790389 Ms. Claudette W Omaha

47 825343 Mrs. Eileen A Oshkosh

48 587361 Hon. Rosario W Chattahoochee

49 430843 Ms. Karina J Centerville

50 398788 Ms. Alexandria Y Cooksville

51 166790 Ms. Margaret C Plant City

52 178602 Mrs. Kristina Q Merced

53 951857 Drs. Sherri T Saint Louis

54 633255 Hon. Yvette U Orviston

55 583282 Mrs. Carolina Y Sanford

56 421955 Ms. Sonia X Pearisburg

57 701223 Ms. Esmeralda P Shullsburg

58 122005 Hon. Candy K Wetumpka

59 461385 Mrs. Emma E Briggsville

60 842752 Mrs. Tommie B Wedowee

61 747200 Mrs. Janelle Q Falls Church

62 962851 Ms. Kathie E Santa Teresa

63 168829 Ms. Antonia H Fort Lauderdale

64 603575 Ms. Ophelia V Scottsdale

65 419075 Mrs. Hallie G Se Ree

66 224473 Ms. Adriana R Gordon

67 552582 Hon. Jana L Athens

68 908007 Mrs. Debra S Kossuth

69 505780 Drs. Ester Z Arendtsville

70 149904 Ms. Leanne R Brookton

71 780963 Mrs. Jami P Country Club Hills

72 175035 Ms. Ava L Fort Payne

73 358935 Ms. Anastasia Y Garrett Park

74 608832 Mrs. Sabrina O Duncan

75 509911 Ms. Kirsten Y Saint Louis

76 354363 Ms. Tabatha W Bagdad

77 191963 Ms. Deanne H Clarinda

78 695631 Mrs. Juanita O Seward

79 866051 Ms. Leann R Neelyton

80 316579 Mrs. Leanne Z Cordova

81 232661 Ms. Luz G Charleston

82 412201 Ms. Dina Q Monticello

83 158689 Ms. Lucile L Cabot

84 620634 Ms. Janna Y Madison

85 431841 Ms. Taylor K Sentinel

86 520702 Ms. Clarissa Z Melbourne

87 189557 Mrs. Claudine Y Farrandsville

88 702034 Mrs. Mitzi Y Jamesville

89 835545 Ms. Janie P Venango

90 326407 Mrs. Sophie F Mears

91 414967 Mrs. Bette Y Mc Elhattan

92 410300 Mrs. Dena Q Otter

 93 297502 Ms. Angelina D Hazard

94 725857 Ms. Shannon D Durham

95 641096 Mrs. Kerry C Oklahoma City

96 219020 Drs. Lana G Beaufort

97 363951 Drs. Frances D Merritt

98 287114 Ms. Joanna A Audubon

99 811489 Hon. Susanna R Springdale

100 162573 Hon. Ola T Dayton

101 836699 Mrs. Louella F Phoenix

102 798859 Drs. Deirdre N Indianapolis

103 458765 Ms. Kristina W Moorpark

104 316995 Mrs. Pauline J Niotaze

105 415004 Ms. Rosa P Appleton

106 559421 Ms. Reba O Columbia

107 959306 Ms. Shana O Edward

108 532285 Ms. Leann W Woodbridge

109 981925 Ms. Ebony B Otego

110 648118 Drs. Bobbie M Park Valley

111 278391 Ms. Jami N Max

112 556573 Ms. Aisha Z Montezuma

113 871770 Ms. Monique S Cardington

114 182719 Ms. Tammy D Dongola

115 761381 Ms. Nichole Z Wichita

116 740281 Ms. Lorna W Scranton

117 790008 Ms. Luann R Phoenix

118 825433 Mrs. Tara H Glenmoore

119 313864 Mrs. Debbie S Littleton

120 978745 Mrs. May R Leslie

121 807182 Mrs. Adeline R Niota

122 901775 Ms. Opal X South Ryegate

123 304721 Mr. Nathaniel Z Irons

124 520092 Mr. Lamont L Purcellville

125 483751 Prof. Reid F Pacoima

126 252938 Hon. Antoine H Canby

127 966375 Dr. Mathew O Van Nuys

128 707520 Mr. Bernardo L Knoxville

129 673049 Dr. Cole E Oklahoma City

130 300693 Mr. Tod N Patuxent River

131 913253 Mr. Carey B New Baltimore

132 959506 Mr. Arthur Q Dodson

133 290808 Mr. Josef S Sacramento

134 865628 Mr. Desmond R Fresno

135 432168 Hon. Jermaine S Welaka

136 463784 Mr. Scott H Bairoil

137 392678 Mr. Marcelino Y Little Rock

138 880704 Dr. Benjamin X Shungnak

139 350367 Mr. Rudolph P Shinnston

140 542826 Mr. Marcus D Bellerose

141 297059 Mr. Rufus S Adams Basin

142 874971 Mr. Roman R Lampeter

143 865495 Mr. Thurman J Eddyville

144 415161 Dr. Lemuel V Listie

145 279563 Mr. Clint A Blue Island

146 909337 Mr. Rich M Maysville

147 323914 Mr. German M Lakeview

148 971444 Mr. Elias X Oaks

149 145327 Mr. Erin M Farmington

150 597202 Dr. Frederic E Seligman

151 168824 Mr. Tanner T Michigan City

152 616665 Mr. Clarence I Macon

153 396135 Prof. German I Matthews

154 966525 Mr. Dion U Plainfield

155 362287 Mr. Cornelius V High Point

156 451972 Hon. Waldo I Wooton

157 993675 Hon. Damien Z Five Forks

158 807964 Mr. Curt Y Monticello

159 769123 Mr. Brenton N Green Camp

160 395792 Hon. Miguel W Kingfisher

161 232794 Dr. Forrest B Lee

162 946630 Mr. Duncan L West Palm Beach

163 141178 Mr. Adam X Potlatch

164 169763 Prof. Benjamin X Tribune

165 326358 Mr. Neil U Milton

166 901185 Mr. Jonathon M Silver Spring

167 264960 Dr. Brent J Adamsville

168 906870 Mr. Arnulfo M Auburn

169 160503 Mr. Nickolas Z Hanna

170 212917 Prof. Raymundo W Toast

171 337955 Mr. Jeremiah W Shauck

172 171553 Mr. Tanner I Anchorage

173 433510 Mr. Dorian A Canebrake

174 668717 Hon. Danial F Joyce

175 479832 Dr. Nelson H Glen Saint Mary

176 273645 Dr. Manuel J Peabody

177 266284 Hon. Dominic U Sumner

178 332802 Mr. Lowell M Potter

179 953967 Mr. Cornell G Woodhaven

180 581563 Prof. Jerome E Cobalt

181 925484 Mr. Elton L Lombard

182 328562 Mr. Stacy V Enterprise

183 759248 Dr. Rory V Templeton

184 158543 Mr. Greg S Turners Station

185 275491 Dr. Julian Y Lisbon Center

186 262843 Mr. Tyrone N Driftwood

187 963676 Mr. Bradley L Portland

188 745672 Dr. Emile A Mears

189 135089 Prof. Zachary G Fairbanks

190 169348 Mr. Aubrey T Osprey

191 976096 Mr. Carroll E Saint Martin

192 143898 Mr. Ricky C Mount Hope

193 749765 Mr. Brian S Orlando

194 877422 Hon. Nicholas T Pomona

195 155570 Mr. Colin G Conroe

196 191240 Mr. Salvador Q Huddy

197 404070 Prof. Aldo J Linton

198 192175 Dr. Bret J Vassar

199 825853 Hon. Dominic H Vancouver

200 597805 Hon. Marquis R Manchester

201 651120 Mr. Damon G Stacy

202 995242 Mr. Leonel K Isaban

203 839558 Mr. Teddy A Timblin

204 581261 Dr. Willis L Freeman

205 793523 Prof. Donovan O Monroe

206 346662 Mr. Garth I Phyllis

207 817037 Mr. Martin W Centre

208 648913 Mr. Irwin D Traverse City

209 924281 Mr. Reynaldo P Jamaica

210 474759 Mr. Johnny E Irwinville

211 144715 Mr. Earnest X Masardis

212 141086 Dr. Bernardo Q Hollywood

213 768457 Mr. Robby U Metaline

214 556491 Prof. Larry C Pliny

215 249180 Dr. Scot M Pocahontas

216 634658 Mr. Rolland D Jackson

217 513773 Prof. Jessie N Clearwater

218 781472 Mr. Isiah T Heber City

219 932425 Mr. Christoper Y Speaks

220 724235 Mr. Quentin J Chippewa Falls

221 871610 Mr. Kenton I Highland Park

222 491595 Prof. Ian O Huntsville

223 821474 Mr. Jasper F Greeley

224 206783 Hon. Brock X Gary

225 870463 Mr. Salvador S Riverdale

226 809491 Mr. Terence U Montevallo

227 924427 Mr. Dario O Torrance

228 886315 Dr. Valentin S Kingston

229 948512 Mr. Jared Q Dewittville

230 282037 Mr. Bruno M Killen

231 505758 Mr. Garland Q Kopperl

232 487100 Mr. Augustus E Napoleon

233 974444 Prof. Luther F Winthrop Harbor

234 829416 Mr. Jimmy C Biloxi

235 146825 Hon. Morton Q Kenton

236 603179 Mr. Andrew V Ohio City

237 344607 Mr. Gregg T Dartmouth

238 547420 Mr. Doug V Doe Hill

239 403674 Dr. Billy R Rhodelia

240 988937 Dr. Boyd L Mount Hamilton

241 937737 Mr. Roberto T Peoria

242 144235 Mr. Kris U Ballouville

243 287787 Mr. Joaquin B Barren Springs

244 625981 Mr. Jay R Oxford

245 863522 Mr. Dudley W Keokee

246 118236 Mr. Monroe D Norwood

247 855988 Hon. Christian G Sand Lake

248 737292 Mr. Luciano H Little Rock

249 596917 Mr. Ahmad B North Judson

250 130591 Prof. Kendrick V Nashua

251 579618 Hon. Demetrius Z Chantilly

252 240295 Mr. Ken P Jefferson City

253 846100 Mr. Earl O Niagara Falls

254 771425 Mr. Lewis T Hope

255 586207 Dr. Michel T Mascotte

256 252371 Mr. Dante Q Hannah

257 805103 Mr. Ron C Galion

258 856369 Mr. Dominick M Spring Green

259 318571 Prof. Emory N Milford

260 934285 Mr. Jeremy G Big Spring

261 149763 Dr. Dudley N Essex Fells

262 306185 Mr. Percy N Hasse

263 225090 Mr. Alfredo H Clover

264 562109 Mr. Stacy O Peoria

265 947334 Mr. Frankie Y Red Oak

266 798671 Mr. Adolph L Durham

267 770810 Mr. Craig W Sand Creek

268 255640 Mr. Stanley T Jolo

269 311079 Dr. Morgan C Hartline

270 713805 Mr. Adam I Ohatchee

271 664249 Mr. Floyd B Farwell

272 339483 Mr. Scott Q Rockford

273 155956 Mr. Sterling K Saint Anne

274 791119 Mr. Damon T Onego

275 798553 Prof. Mauricio A Lawrence

276 159472 Hon. Moses P Orlando

277 338556 Mr. Domingo S Littlefield

278 305556 Mr. Federico J Hart

279 915507 Mr. Kory X Buies Creek

280 141022 Mr. Rodger D Sacramento

281 528086 Mr. Bruce Z Detroit

282 177821 Mr. Derick N Mc Veytown

283 906797 Mr. Rico K Mineral City

284 941759 Prof. Shaun J Kansas City

285 463743 Mr. Guy C Castle Rock

Description of Practice Used
Instead of viewing the details for all items in a
pivot field, you can collapse and expand specific
items, or the entire pivot field. The Expand and
Collapse commands do not affect items that have
been filtered.
Select an item in column 1, and drop down list in
column 2 only shows related items. Excel 2003
tutorial, based on sorted list and OFFSET
function.
Use the Excel PMT function to calculate loan
payments based on interest rate, number of
payments, loan amount.
Video and detailed instructions show how to
create a box plot chart in Excel using a stacked
column chart and error bars.
Use Excel text box controls on the worksheet to
enter data. Link to cells, add manually or with
VBA.
Use the Excel IF function to test a value, then
show a result, depending if the test was TRUE or
FALSE.
Use Excel macros to automate tasks, to same time
and reduce errors.
Use INDEX and MATCH functions to find
distance between two cities. Conditional
formatting highlights selected mileage in lookup
table.

Enter current expenses in Scenario A, and

potential cost reductions in Scenario B. Formulas
calculate annual totals and differences.

Use the AVERAGE, AVERAGEA,

AVERAGEIF and AVERAGEIFS functions in
Excel to calculate the average for cell values, with
or without criteria.
Use the HLOOKUP function in Excel to find a
value in a horizontal list, and return another value
from the selected column.
Click a check box, or type an X, to show and hide
Excel chart data. No programmig required.
Click the scroll bar to change the ending date for a
pivot table report. Set the number of months to be
included. This technique from AlexJ uses one line
of programming, to refresh the pivot table.

Use ISFORMULA function in Excel 2013 to

check for a formula in a cell.
Use SendKeys method in Excel VBA code to
simulate keystrokes. Problems may occur if
wrong window is active.
Examine sample file that create custom tab on
Excel Ribbon. Add Ribbon Callback to macros
and test the buttons.
Sample code to modify Excel charts with VBA
programming.
In Excel, add a scroll bar, and click or drag to
select an end date for reports. No programming
required.
Macro changes all sparklines on the active sheet,
so they will show data, even if rows and columns
are hidden. Excel 2010 or later.
Select words from drop down list and chart shows
how frequently they were used in speeches, by
each political party

Code creates a list of formulas on each worksheet,

by inserting a new sheet for each list. Remove
formula list sheets by running the cleanup macro

When troubleshooting an Excel file, use color

code to mark cells with formulas, text, numbers,
data validation.
Step by step instructions for creating a panel
chart, with four sets of data, side-by-side, in a
single chart.
Links to Excel 2013 articles, from Microsoft and
other sources.
Convert amounts from one measurement unit to
another, such as feet to metres. Excel VBA clears
cells when new unit is selected.

Sample code from Professor Lee Townsend

creates a list of VBA procedures in a workbook,
and shows which procedures call others. Also lists
worksheet shapes and connected macros.
Use Excel VBA to enter project task start and stop
time, by double-clicking on a cell. Excel formulas
total the time per task, and overall total time.

Add Help buttons to a worksheet, and open a

UserForm to a specific page, to show relevant
help
Set weight loss goals and track weekly progress.
Dashboard summarizes your results and shows
target line.

Enter or update records on data entry sheet; drop

boxes; navigation buttons; mandatory cells.

Shorten a Data Validation list by using Advanced

Filter to extract a list of names that start with
selected letter; file contains macros to automate
list updates and filter.
Use Excel Pivot Table Report Filters to focus on
specific data in your pivot table.
Add single column and multiple column lists in
Excel ComboBox controls.
Excel tips in a set of very short videos, including
change hyperlinks to text, print all sheets, create a
quick pivot table and create a formatted Excel
Table.
Excel tips in a set of very short videos, including
move to edge of range, create list of dates, select
large range, rearrange data.
Excel tips in a set of very short videos, including
freeze panes, print comments and create a quick
series of numbers.
Create a detailed preparation schedule for holiday
meals. Enter details and Excel calculates start
times.
Yes, you might be an Excel Nerd if any of the
entries in the Contextures Blog giveaway sound
familiar. A humorous look at Excel, from those
who live there.
Use the Excel IF function to test a value, then
show a result, depending if the test was TRUE or
FALSE.
Set conditional formatting options when working
with pivot tables, to ensure the formatted range
updates correctly.
View two sheets in the same Excel workbook, at
the same time, by adding a new window. View
two workbooks as the same time. Copy a
worksheet and rename it. Copy a worksheet to a
different workbook.
Use the AVERAGE, AVERAGEA,
AVERAGEIF and AVERAGEIFS functions in
Excel to calculate the average for cell values, with
or without criteria.
Use ISFORMULA function in Excel 2013 to
check for a formula in a cell.
Use FORMULATEXT function in Excel 2013 to
show the formula contained in a cell.
Pivot charts on dashboard are connected to slicer
on separate sheet. Change the dashboard filter,
and all the connected charts change. Sample file
from AlexJ, Excel 2010 or later.
Use Excel RANK function to compare numbers;
show student with highest score; break ranking
ties.

An enhanced Concatenate function from Excel

MVP Rick Rothstein allows you to select a range
of cells, and specify a delimiter, such as a hyphen
or comma, to quickly and easily join the text
strings. Also, sample code to delete rows where a
specific word appears in the selected column, or
where the word does not appear.

Shorten a Data Validation list by using Advanced

Filter to extract a list of names that start with
selected letter; file contains macros to automate
list updates and filter.
Use Excel Pivot Table Value Filters to focus on
the top 10, bottom 10 or a specific portion of the
total values in your data.
Excel tips in a set of very short videos, including
move to edge of range, create list of dates, select
large range, rearrange data.

Excel tips in a set of very short videos, including

select a random name, change formulas to values,
show message, quickly name cells.

Click a numbered square and a macro reveals a

Christmas picture each day. Formulas show
current date and days till Christmas.
Yes, you might be an Excel Nerd if any of the
entries in the Contextures Blog giveaway sound
familiar. A humorous look at Excel, from those
who live there.
Video and detailed instructions show how to
create a box plot chart in Excel using a stacked
column chart and error bars.
Use Excel text box controls on the worksheet to
enter data. Link to cells, add manually or with
VBA.
Use the Excel IF function to test a value, then
show a result, depending if the test was TRUE or
FALSE.
Use INDEX and MATCH functions to find
distance between two cities. Conditional
formatting highlights selected mileage in lookup
table.

Enter current expenses in Scenario A, and

potential cost reductions in Scenario B. Formulas
calculate annual totals and differences.

Enter data on a worksheet, in multiple data entry

areas. Add new records, view and update existing
records.
Create an XML map to show RSS feeds from
blogs or websites, on an Excel worksheet.
Use formulas in Excel to create links and HTML
code for Amazon affiliate product links. Copy and
paste to blog or website.

Use combo boxes on an Excel UserForm, to make

data entry easier. Select from first combo box, and
related items appear in second combo box.

Click a check box, or type an X, to show and hide

Excel chart data. No programmig required.

Click the scroll bar to change the ending date for a

pivot table report. Set the number of months to be
included. This technique from AlexJ uses one line
of programming, to refresh the pivot table.

Use ROUND and other functions to round

numbers up or down in Excel.
Use ISFORMULA function in Excel 2013 to
check for a formula in a cell.
Use FORMULATEXT function in Excel 2013 to
show the formula contained in a cell.
Create a custom tab on Excel Ribbon that opens
when specific file is active. Modify macros to run
when Ribbon button is clicked.
With a pivot table calculated field, you can create
a formula to perform calculations on the total for
other fields in the pivot table. For example,
calculate a discount for orders that total more than
$100, or a bonus for sales reps who pass a target
amount.

When you add a field to the pivot table's Values

area, 11 different functions, such as Sum, Count
and Average, are available to summarize the data.
The summary functions in a pivot table are similar
to the worksheet functions with the same names,
with a few differences as noted in this article.

Shorten a Data Validation list by using Advanced

Filter to extract a list of names that start with
selected letter; file contains macros to automate
list updates and filter.

Excel tips in a set of very short videos, including

shortcuts to create a list of dates by week, enter
dates and times, customize the Excel 2007 status
bar and change the default number of sheets.

Excel tips in a set of very short videos, including

change hyperlinks to text, print all sheets, create a
quick pivot table and create a formatted Excel
Table.
Excel tips in a set of very short videos, including
move to edge of range, create list of dates, select
large range, rearrange data.

Excel tips in a set of very short videos, including

select a random name, change formulas to values,
show message, quickly name cells.

Excel tips in a set of very short videos, including

freeze panes, print comments and create a quick
series of numbers.
Click a numbered square and a macro reveals a
Christmas picture each day. Formulas show
current date and days till Christmas.
Record a macro to automate a task, show the
Developer tab on Ribbon, run the recorded macro.

Select an item in column 1, and drop down list in

column 2 only shows related items. Excel 2003
tutorial, based on sorted list and OFFSET
function.
Video and detailed instructions show how to
create a box plot chart in Excel using a stacked
column chart and error bars.
Use Excel text box controls on the worksheet to
enter data. Link to cells, add manually or with
VBA.
Use INDEX and MATCH functions to find
distance between two cities. Conditional
formatting highlights selected mileage in lookup
table.
Enter data on a worksheet, in multiple data entry
areas. Add new records, view and update existing
records.
Create an XML map to show RSS feeds from
blogs or websites, on an Excel worksheet.

Use combo boxes on an Excel UserForm, to make

data entry easier. Select from first combo box, and
related items appear in second combo box.

Click a check box, or type an X, to show and hide

Excel chart data. No programmig required.
Use ROUND and other functions to round
numbers up or down in Excel.
Use ISFORMULA function in Excel 2013 to
check for a formula in a cell.
Use SendKeys method in Excel VBA code to
simulate keystrokes. Problems may occur if
wrong window is active.
Create a custom tab on Excel Ribbon that opens
when specific file is active. Modify macros to run
when Ribbon button is clicked.
Examine sample file that create custom tab on
Excel Ribbon. Add Ribbon Callback to macros
and test the buttons.
Sample code to modify Excel charts with VBA
programming.
Enter forecast and actual amounts in this Excel
budget template; formulas calculate the year to
date variance.
In Excel, add a scroll bar, and click or drag to
select an end date for reports. No programming
required.

If 2 or more players have same rank, they split

points available for that rank, down to next
occupied rank. For example, if 3 players share
rank 1, they split total points for ranks 1, 2 and 3.

An enhanced Concatenate function from Excel

MVP Rick Rothstein allows you to select a range
of cells, and specify a delimiter, such as a hyphen
or comma, to quickly and easily join the text
strings. Also, sample code to delete rows where a
specific word appears in the selected column, or
where the word does not appear.

Excel template tracks golf scores. Excel functions

calculate annual totals, averages, best, worst
scores. Conditional formatting highlights par,
below par holes.
Use Excel Excel Conditional Formatting - Data
Bars to visually compare the values in a table,
with in cell bars.
Use Excel Pivot Table Value Filters to focus on
the top 10, bottom 10 or a specific portion of the
total values in your data.
Use Excel Pivot Table Report Filters to focus on
specific data in your pivot table.
Add single column and multiple column lists in
Excel ComboBox controls.

Excel tips in a set of very short videos, including

shortcuts to create a list of dates by week, enter
dates and times, customize the Excel 2007 status
bar and change the default number of sheets.

Excel tips in a set of very short videos, including

change hyperlinks to text, print all sheets, create a
quick pivot table and create a formatted Excel
Table.
Excel tips in a set of very short videos, including
freeze panes, print comments and create a quick
series of numbers.
Click a numbered square and a macro reveals a
Christmas picture each day. Formulas show
current date and days till Christmas.

Sample file from Excel MVPs, Kirill Lapin (KL),

with amendments by Hector Miguel Orozco Diaz.
Uses code to automatically create a pivot table
from multiple sheets in a workbook.

Yes, you might be an Excel Nerd if any of the

entries in the Contextures Blog giveaway sound
familiar. A humorous look at Excel, from those
who live there.
Select an item in column 1, and drop down list in
column 2 only shows related items. Excel 2003
tutorial, based on sorted list and OFFSET
function.
Use Excel macros to automate tasks, to same time
and reduce errors.
Use INDEX and MATCH functions to find
distance between two cities. Conditional
formatting highlights selected mileage in lookup
table.

Enter current expenses in Scenario A, and

potential cost reductions in Scenario B. Formulas
calculate annual totals and differences.

Enter data on a worksheet, in multiple data entry

areas. Add new records, view and update existing
records.
Set conditional formatting options when working
with pivot tables, to ensure the formatted range
updates correctly.
View two sheets in the same Excel workbook, at
the same time, by adding a new window. View
two workbooks as the same time. Copy a
worksheet and rename it. Copy a worksheet to a
different workbook.
Use the HLOOKUP function in Excel to find a
value in a horizontal list, and return another value
from the selected column.
Use ROUND and other functions to round
numbers up or down in Excel.
Use FORMULATEXT function in Excel 2013 to
show the formula contained in a cell.
Use SendKeys method in Excel VBA code to
simulate keystrokes. Problems may occur if
wrong window is active.
Examine sample file that create custom tab on
Excel Ribbon. Add Ribbon Callback to macros
and test the buttons.
Sample code to modify Excel charts with VBA
programming.
Pivot charts on dashboard are connected to slicer
on separate sheet. Change the dashboard filter,
and all the connected charts change. Sample file
from AlexJ, Excel 2010 or later.
In Excel, add a scroll bar, and click or drag to
select an end date for reports. No programming
required.
Use data tables to perform What If analysis in
Excel, using one or two variables.
Add or move pivot fields with the field list.
Adjust the field list width, sort order, layout and
position, for easier use.
Enter data on a worksheet, in multiple data entry
areas. Add new records, view and update existing
records.
Sample code from Jim Cone. Select a list on the
worksheet, and click arrows to scroll the list items
up or down.
Set conditional formatting options when working
with pivot tables, to ensure the formatted range
updates correctly.
Create an XML map to show RSS feeds from
blogs or websites, on an Excel worksheet.
View two sheets in the same Excel workbook, at
the same time, by adding a new window. View
two workbooks as the same time. Copy a
worksheet and rename it. Copy a worksheet to a
different workbook.
Use formulas in Excel to create links and HTML
code for Amazon affiliate product links. Copy and
paste to blog or website.

Use combo boxes on an Excel UserForm, to make

data entry easier. Select from first combo box, and
related items appear in second combo box.
Use ROUND and other functions to round
numbers up or down in Excel.
Use FORMULATEXT function in Excel 2013 to
show the formula contained in a cell.
Create a custom tab on Excel Ribbon that opens
when specific file is active. Modify macros to run
when Ribbon button is clicked.
Pivot charts on dashboard are connected to slicer
on separate sheet. Change the dashboard filter,
and all the connected charts change. Sample file
from AlexJ, Excel 2010 or later.
Enter forecast and actual amounts in this Excel
budget template; formulas calculate the year to
date variance.
Create an Excel pivot chart with keyboard
shortcuts. Unlink a pivot chart, and connect it to a
different pivot table. Save time by copying a
formatted chart, instead of starting from scratch.
In Excel, you can use MS Query to create a
Cartesian join between two tables. This will
connect all the items in table 1 with all the items
in table 2.

Use DSUM to calculate totals for a database that

is a named Excel Table, for Excel 2007 and later

Find the promo code and discount rate for the

selected product, based on the order date
Sample Excel VBA programming to change pivot
table report filters.
Fit wide Excel sheets onto one printed page in
width. Show headings rows on every printed
page.
Limit the total amount that is entered in an Excel
budget worksheet, by using data validation to
check the total. Create a custom message that
appears when the amount goes over budget. You
can also see the unbudgeted amount that is still
available, and adjust the entries if required
A coloured border separates dates in a list, and the
conditional formatting formula works even if
some rows are hidden.
Create a list of page fields that should be
automatically changed. Change any of the
specified page fields in a pivot table, and the same
selections are made in all other pivot tables that
contain that page field. Also changes the Multiple
Item Selection settings to match changed page
fields.

Examples of Excel List AutoFilter VBA

programming, for use with the List AutoFilters
found in named Excel tables (multiple allowed per
worksheet). Each named table is a ListObject, and
has its own AutoFilter property.
Simple task list and Gantt chart, uses the
WORKDAY formula to calculate days. File is in
Excel 2007 format, with no macros.
Create hyperlinks with drag and drop;
HYPERLINK function; stop or undo hyperlinks.
Select multiple items in List Box. Store selected
items on separate worksheet.
Use Excel RANK function to compare numbers;
show student with highest score; break ranking
ties.

If 2 or more players have same rank, they split

points available for that rank, down to next
occupied rank. For example, if 3 players share
rank 1, they split total points for ranks 1, 2 and 3.

With a pivot table calculated field, you can create

a formula to perform calculations on the total for
other fields in the pivot table. For example,
calculate a discount for orders that total more than
$100, or a bonus for sales reps who pass a target
amount.

When you add a field to the pivot table's Values

area, 11 different functions, such as Sum, Count
and Average, are available to summarize the data.
The summary functions in a pivot table are similar
to the worksheet functions with the same names,
with a few differences as noted in this article.
An enhanced Concatenate function from Excel
MVP Rick Rothstein allows you to select a range
of cells, and specify a delimiter, such as a hyphen
or comma, to quickly and easily join the text
strings. Also, sample code to delete rows where a
specific word appears in the selected column, or
where the word does not appear.

To run macros that you create, or commands that

you use frequently, and commands that aren't on
the Excel Ribbon by default, you can add icons to
the Excel Quick Access Toolbar. This video
shows you the easy steps to follow, using the
example of adding a macro icon to the QAT.

Excel template tracks golf scores. Excel functions

calculate annual totals, averages, best, worst
scores. Conditional formatting highlights par,
below par holes.
Excel pivot table subtotals are automatically
created when you add more fields to Row and
Column areas. Change summary function, create
multiple subtotals.
Create an Excel Data Validation drop down list
that allows users to add new items. New data
validation items will be automatically added to the
drop down list, and the list is sorted
alphabetically.
Use Excel Excel Conditional Formatting - Data
Bars to visually compare the values in a table,
with in cell bars.
Use Excel Pivot Table Value Filters to focus on
the top 10, bottom 10 or a specific portion of the
total values in your data.

Excel tips in a set of very short videos, including

shortcuts to create a list of dates by week, enter
dates and times, customize the Excel 2007 status
bar and change the default number of sheets.

Excel tips in a set of very short videos, including

select a random name, change formulas to values,
show message, quickly name cells.
UPDATE: Event code colours the filtered column
headings, when an AutoFilter is applied. Updated
to prevent unnecessary clearing of Undo stack,
per tip from Nigel Hunt.
Click a numbered square and a macro reveals a
Christmas picture each day. Formulas show
current date and days till Christmas.

Record a macro to automate a task, show the

Developer tab on Ribbon, run the recorded macro.

Sample file uses Data Validation and Advanced

Filter to extract a list of movies for selected
category or actor; file contains macros to
automate list updates and filter.

Sample file from Excel MVPs, Kirill Lapin (KL),

with amendments by Hector Miguel Orozco Diaz.
Uses code to automatically create a pivot table
from multiple sheets in a workbook.

Use data tables to perform What If analysis in

Excel, using one or two variables.
Select an item in column 1, and drop down list in
column 2 only shows related items. Excel 2003
tutorial, based on sorted list and OFFSET
function.
Use the Excel PMT function to calculate loan
payments based on interest rate, number of
payments, loan amount.
Video and detailed instructions show how to
create a box plot chart in Excel using a stacked
column chart and error bars.
Add or move pivot fields with the field list.
Adjust the field list width, sort order, layout and
position, for easier use.
Use Excel text box controls on the worksheet to
enter data. Link to cells, add manually or with
VBA.
Use Excel macros to automate tasks, to same time
and reduce errors.
Use INDEX and MATCH functions to find
distance between two cities. Conditional
formatting highlights selected mileage in lookup
table.
Enter current expenses in Scenario A, and
potential cost reductions in Scenario B. Formulas
calculate annual totals and differences.

Enter data on a worksheet, in multiple data entry

areas. Add new records, view and update existing
records.
Sample code from Jim Cone. Select a list on the
worksheet, and click arrows to scroll the list items
up or down.
Create an XML map to show RSS feeds from
blogs or websites, on an Excel worksheet.
Use formulas in Excel to create links and HTML
code for Amazon affiliate product links. Copy and
paste to blog or website.
Use the HLOOKUP function in Excel to find a
value in a horizontal list, and return another value
from the selected column.

Use combo boxes on an Excel UserForm, to make

data entry easier. Select from first combo box, and
related items appear in second combo box.

Click a check box, or type an X, to show and hide

Excel chart data. No programmig required.

Click the scroll bar to change the ending date for a

pivot table report. Set the number of months to be
included. This technique from AlexJ uses one line
of programming, to refresh the pivot table.

Use ROUND and other functions to round

numbers up or down in Excel.
Use SendKeys method in Excel VBA code to
simulate keystrokes. Problems may occur if
wrong window is active.
Create a custom tab on Excel Ribbon that opens
when specific file is active. Modify macros to run
when Ribbon button is clicked.
Examine sample file that create custom tab on
Excel Ribbon. Add Ribbon Callback to macros
and test the buttons.
Sample code to modify Excel charts with VBA
programming.
Enter forecast and actual amounts in this Excel
budget template; formulas calculate the year to
date variance.
In Excel, add a scroll bar, and click or drag to
select an end date for reports. No programming
required.

If 2 or more players have same rank, they split

points available for that rank, down to next
occupied rank. For example, if 3 players share
rank 1, they split total points for ranks 1, 2 and 3.

With a pivot table calculated field, you can create

a formula to perform calculations on the total for
other fields in the pivot table. For example,
calculate a discount for orders that total more than
$100, or a bonus for sales reps who pass a target
amount.

When you add a field to the pivot table's Values

area, 11 different functions, such as Sum, Count
and Average, are available to summarize the data.
The summary functions in a pivot table are similar
to the worksheet functions with the same names,
with a few differences as noted in this article.

To run macros that you create, or commands that

you use frequently, and commands that aren't on
the Excel Ribbon by default, you can add icons to
the Excel Quick Access Toolbar. This video
shows you the easy steps to follow, using the
example of adding a macro icon to the QAT.

Excel template tracks golf scores. Excel functions

calculate annual totals, averages, best, worst
scores. Conditional formatting highlights par,
below par holes.
Excel pivot table subtotals are automatically
created when you add more fields to Row and
Column areas. Change summary function, create
multiple subtotals.
Create an Excel Data Validation drop down list
that allows users to add new items. New data
validation items will be automatically added to the
drop down list, and the list is sorted
alphabetically.
Use Excel Excel Conditional Formatting - Data
Bars to visually compare the values in a table,
with in cell bars.
Use Excel Pivot Table Report Filters to focus on
specific data in your pivot table.
Add single column and multiple column lists in
Excel ComboBox controls.

Excel tips in a set of very short videos, including

shortcuts to create a list of dates by week, enter
dates and times, customize the Excel 2007 status
bar and change the default number of sheets.

Excel tips in a set of very short videos, including

change hyperlinks to text, print all sheets, create a
quick pivot table and create a formatted Excel
Table.
Excel tips in a set of very short videos, including
freeze panes, print comments and create a quick
series of numbers.
UPDATE: Event code colours the filtered column
headings, when an AutoFilter is applied. Updated
to prevent unnecessary clearing of Undo stack,
per tip from Nigel Hunt.

Record a macro to automate a task, show the

Developer tab on Ribbon, run the recorded macro.

Create a detailed preparation schedule for holiday

meals. Enter details and Excel calculates start
times.
Sample file uses Data Validation and Advanced
Filter to extract a list of movies for selected
category or actor; file contains macros to
automate list updates and filter.

Sample file from Excel MVPs, Kirill Lapin (KL),

with amendments by Hector Miguel Orozco Diaz.
Uses code to automatically create a pivot table
from multiple sheets in a workbook.

Use data tables to perform What If analysis in

Excel, using one or two variables.
Select an item in column 1, and drop down list in
column 2 only shows related items. Excel 2003
tutorial, based on sorted list and OFFSET
function.
Use the Excel PMT function to calculate loan
payments based on interest rate, number of
payments, loan amount.
Add or move pivot fields with the field list.
Adjust the field list width, sort order, layout and
position, for easier use.
Use Excel macros to automate tasks, to same time
and reduce errors.
Sample code from Jim Cone. Select a list on the
worksheet, and click arrows to scroll the list items
up or down.
Set conditional formatting options when working
with pivot tables, to ensure the formatted range
updates correctly.
View two sheets in the same Excel workbook, at
the same time, by adding a new window. View
two workbooks as the same time. Copy a
worksheet and rename it. Copy a worksheet to a
different workbook.
Use the AVERAGE, AVERAGEA,
AVERAGEIF and AVERAGEIFS functions in
Excel to calculate the average for cell values, with
or without criteria.
Use the HLOOKUP function in Excel to find a
value in a horizontal list, and return another value
from the selected column.
Use SendKeys method in Excel VBA code to
simulate keystrokes. Problems may occur if
wrong window is active.
Examine sample file that create custom tab on
Excel Ribbon. Add Ribbon Callback to macros
and test the buttons.
Sample code to modify Excel charts with VBA
programming.
Pivot charts on dashboard are connected to slicer
on separate sheet. Change the dashboard filter,
and all the connected charts change. Sample file
from AlexJ, Excel 2010 or later.
Enter forecast and actual amounts in this Excel
budget template; formulas calculate the year to
date variance.
In Excel, add a scroll bar, and click or drag to
select an end date for reports. No programming
required.
Use Excel RANK function to compare numbers;
show student with highest score; break ranking
ties.

If 2 or more players have same rank, they split

points available for that rank, down to next
occupied rank. For example, if 3 players share
rank 1, they split total points for ranks 1, 2 and 3.

An enhanced Concatenate function from Excel

MVP Rick Rothstein allows you to select a range
of cells, and specify a delimiter, such as a hyphen
or comma, to quickly and easily join the text
strings. Also, sample code to delete rows where a
specific word appears in the selected column, or
where the word does not appear.

To run macros that you create, or commands that

you use frequently, and commands that aren't on
the Excel Ribbon by default, you can add icons to
the Excel Quick Access Toolbar. This video
shows you the easy steps to follow, using the
example of adding a macro icon to the QAT.

Excel template tracks golf scores. Excel functions

calculate annual totals, averages, best, worst
scores. Conditional formatting highlights par,
below par holes.
Excel pivot table subtotals are automatically
created when you add more fields to Row and
Column areas. Change summary function, create
multiple subtotals.
Create an Excel Data Validation drop down list
that allows users to add new items. New data
validation items will be automatically added to the
drop down list, and the list is sorted
alphabetically.
Use Excel Excel Conditional Formatting - Data
Bars to visually compare the values in a table,
with in cell bars.
Use Excel Pivot Table Value Filters to focus on
the top 10, bottom 10 or a specific portion of the
total values in your data.
Use Excel Pivot Table Report Filters to focus on
specific data in your pivot table.
Add single column and multiple column lists in
Excel ComboBox controls.
UPDATE: Event code colours the filtered column
headings, when an AutoFilter is applied. Updated
to prevent unnecessary clearing of Undo stack,
per tip from Nigel Hunt.
Create a detailed preparation schedule for holiday
meals. Enter details and Excel calculates start
times.
Sample file uses Data Validation and Advanced
Filter to extract a list of movies for selected
category or actor; file contains macros to
automate list updates and filter.

Sample file from Excel MVPs, Kirill Lapin (KL),

with amendments by Hector Miguel Orozco Diaz.
Uses code to automatically create a pivot table
from multiple sheets in a workbook.

Yes, you might be an Excel Nerd if any of the

entries in the Contextures Blog giveaway sound
familiar. A humorous look at Excel, from those
who live there.
Use data tables to perform What If analysis in
Excel, using one or two variables.
Use the Excel PMT function to calculate loan
payments based on interest rate, number of
payments, loan amount.
Add or move pivot fields with the field list.
Adjust the field list width, sort order, layout and
position, for easier use.
Use the Excel IF function to test a value, then
show a result, depending if the test was TRUE or
FALSE.
Use Excel macros to automate tasks, to same time
and reduce errors.

Enter current expenses in Scenario A, and

potential cost reductions in Scenario B. Formulas
calculate annual totals and differences.

Sample code from Jim Cone. Select a list on the

worksheet, and click arrows to scroll the list items
up or down.
Set conditional formatting options when working
with pivot tables, to ensure the formatted range
updates correctly.
View two sheets in the same Excel workbook, at
the same time, by adding a new window. View
two workbooks as the same time. Copy a
worksheet and rename it. Copy a worksheet to a
different workbook.
Use the AVERAGE, AVERAGEA,
AVERAGEIF and AVERAGEIFS functions in
Excel to calculate the average for cell values, with
or without criteria.
Use formulas in Excel to create links and HTML
code for Amazon affiliate product links. Copy and
paste to blog or website.
Use the HLOOKUP function in Excel to find a
value in a horizontal list, and return another value
from the selected column.

Click the scroll bar to change the ending date for a

pivot table report. Set the number of months to be
included. This technique from AlexJ uses one line
of programming, to refresh the pivot table.

Use FORMULATEXT function in Excel 2013 to

show the formula contained in a cell.
Pivot charts on dashboard are connected to slicer
on separate sheet. Change the dashboard filter,
and all the connected charts change. Sample file
from AlexJ, Excel 2010 or later.
Use Excel RANK function to compare numbers;
show student with highest score; break ranking
ties.
With a pivot table calculated field, you can create
a formula to perform calculations on the total for
other fields in the pivot table. For example,
calculate a discount for orders that total more than
$100, or a bonus for sales reps who pass a target
amount.
When you add a field to the pivot table's Values
area, 11 different functions, such as Sum, Count
and Average, are available to summarize the data.
The summary functions in a pivot table are similar
to the worksheet functions with the same names,
with a few differences as noted in this article.

To run macros that you create, or commands that

you use frequently, and commands that aren't on
the Excel Ribbon by default, you can add icons to
the Excel Quick Access Toolbar. This video
shows you the easy steps to follow, using the
example of adding a macro icon to the QAT.

Shorten a Data Validation list by using Advanced

Filter to extract a list of names that start with
selected letter; file contains macros to automate
list updates and filter.
Excel pivot table subtotals are automatically
created when you add more fields to Row and
Column areas. Change summary function, create
multiple subtotals.
Create an Excel Data Validation drop down list
that allows users to add new items. New data
validation items will be automatically added to the
drop down list, and the list is sorted
alphabetically.
Excel tips in a set of very short videos, including
move to edge of range, create list of dates, select
large range, rearrange data.

Excel tips in a set of very short videos, including

select a random name, change formulas to values,
show message, quickly name cells.

UPDATE: Event code colours the filtered column

headings, when an AutoFilter is applied. Updated
to prevent unnecessary clearing of Undo stack,
per tip from Nigel Hunt.

Record a macro to automate a task, show the

Developer tab on Ribbon, run the recorded macro.

Create a detailed preparation schedule for holiday

meals. Enter details and Excel calculates start
times.
Sample file uses Data Validation and Advanced
Filter to extract a list of movies for selected
category or actor; file contains macros to
automate list updates and filter.
Use data tables to perform What If analysis in
Excel, using one or two variables.
Use the Excel PMT function to calculate loan
payments based on interest rate, number of
payments, loan amount.
Video and detailed instructions show how to
create a box plot chart in Excel using a stacked
column chart and error bars.
Add or move pivot fields with the field list.
Adjust the field list width, sort order, layout and
position, for easier use.
Use Excel text box controls on the worksheet to
enter data. Link to cells, add manually or with
VBA.
Use the Excel IF function to test a value, then
show a result, depending if the test was TRUE or
FALSE.
Sample code from Jim Cone. Select a list on the
worksheet, and click arrows to scroll the list items
up or down.
Create an XML map to show RSS feeds from
blogs or websites, on an Excel worksheet.
Use the AVERAGE, AVERAGEA,
AVERAGEIF and AVERAGEIFS functions in
Excel to calculate the average for cell values, with
or without criteria.
Use formulas in Excel to create links and HTML
code for Amazon affiliate product links. Copy and
paste to blog or website.

Use combo boxes on an Excel UserForm, to make

data entry easier. Select from first combo box, and
related items appear in second combo box.

Click a check box, or type an X, to show and hide

Excel chart data. No programmig required.

Click the scroll bar to change the ending date for a

pivot table report. Set the number of months to be
included. This technique from AlexJ uses one line
of programming, to refresh the pivot table.
Use ISFORMULA function in Excel 2013 to
check for a formula in a cell.
Create a custom tab on Excel Ribbon that opens
when specific file is active. Modify macros to run
when Ribbon button is clicked.
Enter forecast and actual amounts in this Excel
budget template; formulas calculate the year to
date variance.