Tony PHillips

Featured in: Favicon

msn.com

yahoo.com

howtogeek.com Favicon

jdsupra.com Favicon

newsbreak.com Favicon

governance-intelligence.com

Articles

The PIVOTBY Function vs PivotTables: Which Should You Use in Excel?

2 days ago | howtogeek.com | Tony PHillips |Tony Phillips

Excel's PIVOTBY function and PivotTables both summarize and reorganize data, allowing for detailed analysis by grouping and aggregating your figures. However, despite their similar names, the methods for using them differ hugely. Using Excel's PIVOTBY Function The PIVOTBY function is a dynamic array function in Excel that uses a formula to group rows and columns of data to generate tabular summaries of your data. Let's look at some of its main features and characteristics.
I Always Name Ranges in Excel, and You Should Too

6 days ago | howtogeek.com | Tony PHillips |Tony Phillips

By default, Microsoft Excel's cells are named by their column-row references, like A1 or B2. However, you can assign a more specific name to a cell or range of cells to improve navigation, make formulas clearer, and save time in the long run. Why You Should Always Name Ranges in Excel You might be familiar with bookmarks in Microsoft Word, which are invisible way-points in specified locations of a document that you can jump to whenever you need to.
How to Make Your Excel Spreadsheet Accessible to All

1 week ago | howtogeek.com | Tony PHillips |Tony Phillips

Whenever you create a Microsoft Excel workbook, you should always take the necessary steps to make it accessible to everyone, especially if you plan to share your work with others. In this guide, I'll share some tips you can follow to make this happen. Use Descriptive Sheet Names One way to make your Excel workbook more accessible is by changing the names of the worksheets.
Microsoft PowerPoint Keyboard Shortcuts: Printable Cheat Sheet

1 week ago | howtogeek.com | Tony PHillips |Tony Phillips

Microsoft PowerPoint's seemingly endless views, tabs, groups, menus, and panes can often be difficult to navigate. This is why having some of the most-used keyboard shortcuts to hand can significantly speed up your workflow, whether you're a teacher planning a lesson, an entrepreneur preparing a financial update, or a graphic designer plotting your blueprint.
How to Use Excel's AGGREGATE Function to Refine Calculations

1 week ago | howtogeek.com | Tony PHillips |Tony Phillips

Excel's AGGREGATE function lets you perform calculations whilst ignoring hidden rows, errors, or other functions that appear in the data. It's similar to the SUBTOTAL function but provides more calculation options and gives you more control over what you want to exclude from the calculation. The AGGREGATE Syntax Before we look at some examples of the AGGREGATE function in use, let's see how it works.
You Need to Know What the Hash Sign Does in Excel Formulas

2 weeks ago | howtogeek.com | Tony PHillips |Tony Phillips

Excel spilled range operator (#) allows formulas to automatically adjust to changes in the spilled range size. You need to be using Excel for Microsoft 365 on Windows or Mac to make use of this handy tool. Well-known functions like UNIQUE, COUNTIF, and SORTBY can be used with the spilled range operator to generate dynamic, sortable lists.
How to Add Different Page Numbers to Different Sections in Microsoft Word

2 weeks ago | howtogeek.com | Tony PHillips |Tony Phillips

Whether you want to use page numbers to distinguish between a novel's preface and main body, a dissertation's introduction and chapters, or a textbook's content and index, using Microsoft Word's Section Breaks tool is the way to go. All the screenshots in this article show non-printing characters, as activating these makes understanding the document's structure much easier.
How to Create a Timeline Filter in Excel

3 weeks ago | howtogeek.com | Tony PHillips |Tony Phillips

One way to display figures in an Excel table according to certain time periods is by using filter buttons. However, a better way to do this is to use a timeline, a dynamic filter option that allows you to quickly display data from individual days, months, quarters, or years. Step 1: Turn Your Data Into a PivotTable The first step is to turn your raw Excel data into a PivotTable.
How to Use the GROUPBY Function in Excel

3 weeks ago | howtogeek.com | Tony PHillips |Tony Phillips

Excel's GROUPBY function lets you group and aggregate data based on certain fields in your table of data. It also offers arguments that allow you to sort and filter your data, so you can tailor the output to meet your specific needs. Although you can use pivot tables to achieve similar outcomes to the GROUPBY function, the GROUPBY function refreshes automatically if your data changes or is reordered, and it also lets you embed more functions for more refined data sorting.
Don’t Hide and Unhide Columns in Excel-Use Groups Instead

3 weeks ago | howtogeek.com | Tony PHillips |Tony Phillips

In Microsoft Excel, you can permanently hide columns containing data you don't need to have on show. However, grouping columns is often a better way to achieve the same outcome, especially if you're dealing with large datasets or looking for ways to make your spreadsheet more flexible. This guide shows you how to group and ungroup columns in Excel, but you can also use exactly the same method to group and ungroup rows.