![\"Holidays](\"https:\/\/exceltheatre.com\/blog\/wp-content\/uploads\/2022\/01\/holidaysoverexcel01.jpg\" "\\"Holidays")
<\/a><\/p>\nExcel Tips and Tutorials<\/h3>\n
If you’re stuck on an Excel problem, check the tutorials on my Contextures site \u2013 you might find an answer there.<\/p>\n
Start with these popular tutorials<\/strong>, or go to the full index on the Excel Tips page<\/a>.<\/p>\n Excel, Key Skills<\/a><\/p>\n How to Count Specific Cells<\/a><\/p>\n How to Do a VLOOKUP<\/a><\/p>\n Create a Pivot Table<\/a><\/p>\n Next, check out what’s new on my Contextures site.<\/p>\n Here are the latest tutorials:<\/strong><\/p>\n Copy & Paste Problems<\/a><\/p>\n Interactive Dynamic Filter<\/a><\/p>\n Show Totals with Excel FILTER Function<\/a><\/p>\n Cluster Stack Pivot Chart<\/a><\/p>\n Remove Duplicates – Number Problem<\/a><\/p>\n Fix Conditional Formatting Extra Rules<\/a><\/p>\n Change Excel calculation options<\/a><\/p>\n Sum or Count Based on Date Range<\/a><\/p>\n Drop Down List – Top Items<\/a><\/p>\n If you’re looking for examples, you’ll find Excel workbooks on most of the Excel tutorial pages.<\/p>\n For even more sample files, go to the Excel workbooks page<\/a>, where there are more than 200 files for you to select from.<\/p>\n If you like to learn Excel through videos, here’s my latest one.<\/p>\n In an Excel pivot table, you can use the % Running Total calculation, to show the current running total amount, divided by the grand total. For example, see what percentage of total sales come from the top 3 products. Watch this video to see the steps.<\/p>\n And visit my Contextures site for more Pivot Table Running Total examples<\/a>, and to get the sample file for this video.<\/p>\nLatest Excel Tutorials<\/h3>\n
Excel Files<\/h3>\n
Latest Video: Analyze Top Product Sales<\/h3>\n