Go Ask Debbie
3 More Excel Tips to Save Time
As a follow up to my 3 Excel Tips to Save Time post, I've thought of 3 more tips that can help you save time in Excel.
top of page
Go Ask Debbie BLOG
Search
Go Ask Debbie
- May 24, 2021
- 2 min
Excel Macros for Productivity
Macros in Excel can tremendously help with your productivity!
Macros record steps you would conduct on a regular basis in Excel.
Go Ask Debbie
- Apr 26, 2021
- 2 min
Display or Hide Zero values in Excel
Sometimes you might not want zero (0) values showing on your worksheets, sometimes you need them to be seen. Whether your format...
Go Ask Debbie
- Mar 30, 2021
- 3 min
3 Excel Tips to Save Time
If you've been following me for any amount of time, you know I'm all about learning how to use your tools, like Microsoft Office, to save...
Go Ask Debbie
- Mar 8, 2021
- 1 min
Excel =SUM vs =SUBTOTAL
Do you know the difference between =SUM and =SUBTOTAL in Excel? Both provide totals, but when cells are hidden, the =SUM will provide the...
Go Ask Debbie
- Feb 2, 2021
- 2 min
Excel 2019 and Office 365 New Function =CONCAT
Many people have recently, or will be in 2021, upgrading to Excel 2019 or Office 365. And, I’m personally excited for some of the new...
Go Ask Debbie
- Jan 11, 2021
- 6 min
Excel Data Analysis
Data Analysis is all about telling a story so that someone can take action on the data.
Go Ask Debbie
- Dec 5, 2020
- 2 min
Excel Tutorial: Text to Columns
I've had so many people over the years ask, "I have data in a text file, but need to put it into Excel to analyze the data and get...
Go Ask Debbie
- Dec 1, 2020
- 1 min
Excel Tutorial: Remove Duplicates
Since Excel 2013, removing duplicates has now become such an easy task, I wanted to share it with you. So, when would you need to remove...
Go Ask Debbie
- Nov 25, 2020
- 3 min
Excel Slicers - How to Use them and Why
Did you know that Excel Pivot Tables can do so much more than just show your data and sum or count it? Are you saying, "Debbie, what are...
Go Ask Debbie
- Sep 29, 2020
- 2 min
How Can I use Excel to Track Projects?
Pivot Tables allow you to use Excel to summarize and analyze data.
Go Ask Debbie
- Sep 28, 2020
- 2 min
How to Use Pivot Tables in Excel
Pivot Tables in Excel help you summarize and analyze data very easily.
Go Ask Debbie
- Aug 21, 2020
- 3 min
How to Split Cells in Excel
Splitting data into separate cells in Excel is very easy and there's even a convenient Wizard!
Go Ask Debbie
- Apr 25, 2020
- 3 min
Excel =VLOOKUP to quickly find data
VLOOKUP is one of the most misunderstood functions in Excel. However, it really is simple and powerful when you learn the steps.
Go Ask Debbie
- Apr 10, 2020
- 1 min
How to Join Cells using Excel Concatenate
Merging cells in Excel is simple with the =CONCATENATE function.
Go Ask Debbie
- Apr 1, 2020
- 1 min
Excel Data Analysis - Pivot Tables
Pivot Tables and Pivot Charts are easy ways to analyze data using Excel. Learn how Excel uses your data to create Pivot Tables and Charts.
Go Ask Debbie
- Mar 19, 2020
- 1 min
Use Excel to Create a Map Chart
Easy to create Map Charts in Excel.
Excel 360 and 2019 now offer this awesome feature!
Go Ask Debbie
- Aug 4, 2018
- 1 min
Excel Tip: PivotTable Formatting
Janey, from Maine, asks, "When I'm working with PivotTables, I like to add specific formatting. But, when I update the PivotTable, my...
Go Ask Debbie
- Apr 3, 2018
- 1 min
Excel Tip: Multiply without using Formulas
Janet, of Phoenix asks, “I’m always forgetting how to type the formulas in Excel. Is there an easier way to multiply numbers without...
Go Ask Debbie
- Mar 9, 2018
- 1 min
Excel Rank Formula
Steve from Phoenix is looking for a way of ranking his sales representatives by revenue for a local company. Excel's Rank formula works...
bottom of page