Category: Excel®
How to Unlock Specific Cells in Excel
When using a shared document you may only want to allow specific cells to be changed. Here are some steps to help you keep certain cells unlocked while the rest of the document is protected. Step 1: Select the cell(s) you would like to leave unlocked. Step 2: Go to…
Read More
Using the Excel Pivot Table Grouping by Month to View Data Differently
PivotTables have some useful "hidden" features that can make interpreting your data even easier. One such feature allows you to view data by date groupings (such as month, quarter, even week and hour of day). By grouping within the PivotTable itself, you avoid constantly changing your source data and creating…
Read More
Excel 2013: How to Create a PivotTable from Multiple Sheets
Once you become a PivotTable fan, you will start to see lots of uses for this powerful analysis tool. But what can you do when the data you want to use is in separate tables in multiple sheets across your workbook? Excel 2013 introduced a method – called the Data…
Read More
How to Add Calculated Fields to a PivotTable in Excel
PivotTables are great tools for grouping, summarizing and totaling information from raw data. Once you have created a table, then you are ready to get even more out of your information by using the summarized data in additional formulas or calculations. The way Excel does this is through Calculated Fields.…
Read More
Dressing Up Your PivotTable Design
Once you have a PivotTable created, you may find that Excel's default formatting is bland at best, unreadable at worst. Here are five formatting options you can adjust when you need to get a PivotTable ready for a presentation or report, but don't need to create something as visually elaborate…
Read More
Searching for Data in Excel
Are you looking for the "peanut butter and chocolate" of workplace efficiency: how to combine the power of Macros with the convenience of search? As of Office 2013, Excel does not provide an easy way to include a variable search term in the execution of a series of tasks recorded…
Read More
Microsoft Quick Tip: Visualize Your Data in an Excel Bubble Chart
Microsoft opened the door additional functionality through apps in Office 2013. If you want to create visual impact for your data in charts and graphics, there are numerous apps or add-ins to meet your need. For more on add-ins, check out our post: Three Excel Chart Add-Ins to Create Unique Charts…
Read More
Tips for Creating Perfect Pivot Tables with a Macro
Once you've harnessed the power of PivotTables, you probably find yourself looking for ways to use them all the time. The same is true of macros – convenient shortcuts that make your life easier! But have you tried to combine the two? Unless you are turning the exact same format…
Read More
Creating a Graph with Mutiple Data Series in Excel Without a PivotChart
One of the most powerful advantages of a chart is its ability to show comparisons between data series, but you'll need to spend a little time thinking about what you want to show and how to organize it for excellent communication. Let's look at the ways that Excel can display…
Read More
A Great Way to Create an Excel Micro Timer
Professionals who are used to organizing their lives in Excel at some point wish Excel could include a timer to help keep track of common tasks. Tasks like tracking time spent on specific projects or monitoring hourly rate. A quick look, however, reveals that – unless you are an accomplished…
Read More