top of page
Go Ask Debbie BLOG
Search


Excel Shortcuts Uncovered: Effortlessly Streamline Your Workflow Like a Pro
Excel is a powerful tool that can sometimes feel daunting, especially when you're dealing with complex calculations or large sets of...
0 comments


Mastering Excel Formulas for Optimal Business Productivity
Unleashing the Power of Excel In today's fast-paced business landscape, maximizing productivity is essential for success. One tool that...
0 comments

Excel: Create a Pivot Chart from Pivot Table
In this tutorial, I show you how to easily create a Pivot Chart from an existing Pivot Table.

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.
0 comments


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.
0 comments

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...
0 comments

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...
0 comments

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...
0 comments

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...
0 comments

Excel Data Analysis
Data Analysis is all about telling a story so that someone can take action on the data.
0 comments

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...
0 comments

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...
0 comments


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...
0 comments


How Can I use Excel to Track Projects?
Pivot Tables allow you to use Excel to summarize and analyze data.
0 comments


How to Use Pivot Tables in Excel
Pivot Tables in Excel help you summarize and analyze data very easily.
0 comments

How to Split Cells in Excel
Splitting data into separate cells in Excel is very easy and there's even a convenient Wizard!
0 comments

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.
0 comments


How to Join Cells using Excel Concatenate
Merging cells in Excel is simple with the =CONCATENATE function.
0 comments


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.
0 comments

Use Excel to Create a Map Chart
Easy to create Map Charts in Excel.
Excel 360 and 2019 now offer this awesome feature!
0 comments
bottom of page