Excel Black Friday Shopping List Template

This template was created so you can have the best game plan when going into Black Friday. It can be used for new or seasoned Black Friday shoppers.

Here is how the table works:

  • Column A has your date/time. Be sure to enter AM or PM so that when you filter you have the most accurate information.
  • Column B has the Store in which you will be attending to purchase your item.
  • The Item to be purchased can be found in Column C.
  • The Price to the corresponding item is in Column D.

Excel Black Friday Shopping Template - Image 1

There are some examples in the template to show you exactly how it works. In order to add more rows than what the table shows, simply hit tab in the last cell (currently D37) to add another row to the table. You can also right click in the table and select insert, Table Rows Above.

Excel Black Friday Shopping Template - Image 2

The best part about this table is that you can filter on Date/Time to see where you should start based on what time a store opens. You can also sort on Store, Item and Price depending on what you would like your plan of attack to be. There is a Total at the bottom of the table that will show you approximately how much you would spend if you bought the items on your list (this doesn’t factor in tax information). If you would rather not see the total you are more than welcome to delete this row. Good luck and have a safe and enjoyable shopping experience!

PRYOR+ 7-DAY FREE TRIAL


Experience 7-days of unlimited learning, then reap the benefits from a year of training at one low price. No credit card. No commitment. Individuals and teams.


Choose a Seminar and Save $10:

Microsoft<small><sup>®</sup></small> Excel<small><sup>®</sup></small> Basics

Microsoft® Excel® Basics

LIVE ONLINE SEMINARS

May. 24

Eastern Time Zone

May. 25

Central Time Zone

Jun. 1

Central Time Zone

Jun. 6

Eastern Time Zone

Jun. 7

Central Time Zone

Jun. 9

Pacific Time Zone

Jun. 13

Central Time Zone

Jun. 15

Central Time Zone

Jun. 16

Eastern Time Zone

Jun. 20

Central Time Zone

Jun. 21

Pacific Time Zone

Jun. 23

Eastern Time Zone

Jun. 28

Eastern Time Zone

Jul. 6

Pacific Time Zone

Jul. 7

Central Time Zone

Jul. 11

Eastern Time Zone

Jul. 12

Central Time Zone

Jul. 14

Central Time Zone

Jul. 18

Pacific Time Zone

Jul. 20

Central Time Zone

Jul. 21

Eastern Time Zone

Jul. 25

Eastern Time Zone

Jul. 26

Central Time Zone

Jul. 27

Central Time Zone

Aug. 1

Pacific Time Zone

Aug. 3

Central Time Zone

Aug. 4

Eastern Time Zone

Aug. 9

Central Time Zone

Aug. 11

Central Time Zone

Aug. 15

Eastern Time Zone

Aug. 16

Central Time Zone

Aug. 18

Pacific Time Zone

Aug. 23

Central Time Zone

Aug. 25

Pacific Time Zone

Aug. 29

Eastern Time Zone

Aug. 31

Central Time Zone

Sep. 7

Central Time Zone

Sep. 12

Central Time Zone

Sep. 13

Pacific Time Zone

Sep. 15

Eastern Time Zone

Sep. 19

Central Time Zone

Sep. 21

Central Time Zone

Sep. 22

Eastern Time Zone

Sep. 26

Pacific Time Zone

Sep. 27

Central Time Zone

Sep. 29

Central Time Zone

Microsoft<small><sup>®</sup></small> Excel<small><sup>®</sup></small>: Beyond the Basics

Microsoft® Excel®: Beyond the Basics

LIVE ONLINE SEMINARS

May. 25

Eastern Time Zone

May. 26

Central Time Zone

Jun. 2

Central Time Zone

Jun. 7

Eastern Time Zone

Jun. 8

Central Time Zone

Jun. 10

Pacific Time Zone

Jun. 14

Central Time Zone

Jun. 16

Central Time Zone

Jun. 17

Eastern Time Zone

Jun. 21

Central Time Zone

Jun. 22

Pacific Time Zone

Jun. 24

Eastern Time Zone

Jun. 29

Eastern Time Zone

Jul. 7

Pacific Time Zone

Jul. 8

Central Time Zone

Jul. 12

Eastern Time Zone

Jul. 13

Central Time Zone

Jul. 15

Central Time Zone

Jul. 19

Pacific Time Zone

Jul. 21

Central Time Zone

Jul. 22

Eastern Time Zone

Jul. 26

Eastern Time Zone

Jul. 27

Central Time Zone

Jul. 28

Central Time Zone

Aug. 2

Pacific Time Zone

Aug. 4

Central Time Zone

Aug. 5

Eastern Time Zone

Aug. 10

Central Time Zone

Aug. 12

Central Time Zone

Aug. 16

Eastern Time Zone

Aug. 17

Central Time Zone

Aug. 19

Pacific Time Zone

Aug. 24

Central Time Zone

Aug. 26

Pacific Time Zone

Aug. 30

Eastern Time Zone

Sep. 1

Central Time Zone

Sep. 8

Central Time Zone

Sep. 13

Central Time Zone

Sep. 14

Pacific Time Zone

Sep. 16

Eastern Time Zone

Sep. 20

Central Time Zone

Sep. 22

Central Time Zone

Sep. 23

Eastern Time Zone

Sep. 27

Pacific Time Zone

Sep. 28

Central Time Zone

Sep. 30

Central Time Zone

Advanced Microsoft<small><sup>®</sup></small> Excel<small><sup>®</sup></small>-Macros, PivotTables, Charts and More

Advanced Microsoft® Excel®-Macros, PivotTables, Charts and More

LIVE ONLINE SEMINARS

May. 23

Central Time Zone

Jun. 3

Central Time Zone

Jun. 8

Eastern Time Zone

Jun. 14

Eastern Time Zone

Jun. 16

Central Time Zone

Jun. 22

Central Time Zone

Jun. 23

Pacific Time Zone

Jun. 27

Eastern Time Zone

Jul. 6

Central Time Zone

Jul. 12

Pacific Time Zone

Jul. 13

Eastern Time Zone

Jul. 18

Central Time Zone

Jul. 19

Eastern Time Zone

Jul. 28

Eastern Time Zone

Jul. 29

Central Time Zone

Aug. 2

Eastern Time Zone

Aug. 9

Pacific Time Zone

Aug. 12

Central Time Zone

Aug. 17

Eastern Time Zone

Aug. 18

Central Time Zone

Aug. 22

Central Time Zone

Aug. 25

Eastern Time Zone

Aug. 31

Pacific Time Zone

Sep. 9

Central Time Zone

Sep. 14

Eastern Time Zone

Sep. 15

Pacific Time Zone

Sep. 19

Central Time Zone

Sep. 27

Eastern Time Zone

Sep. 28

Central Time Zone

Related Excel® Articles

PRYOR+ 7-DAY FREE TRIAL


Experience 7-days of unlimited learning, then reap the benefits from a year of training at one low price. No credit card. No commitment. Individuals and teams.

Categories