Скачать или смотреть 001 - Subtotal Conditional Formatting For Better Reports

In this edition of our Advanced Excel & Access Tips video series, we wanted to show you how to improve Excel reports that use the Subtotal function. By adding Conditional Formats to your Subtotaled reports, you can much more easily identify the subtotal rows making it easier to identify important trends. We also illustrate how using Filtering with a Subtotal report can provide additional insight regarding your data.

00:00 Introduction to Advanced Excel skills on Conditional Formatting of Subtotal Reports
00:30 Introducing the data set and creating some additional measures
02:27 How to use Excel's Subtotal function to subtotal our data set
03:05 How to use Excel's conditional formatting capability to improve the readability of Subtotaled reports
05:03 How to paste the ASP, Unit Cost and Margin percentages on the Subtotaled report
05:43 Filtering Subtotaled reports and why you want to add this to your reports

Check out Profitwsye Academy for additional Excel training content that will take your skills to a greater level of success at the following link:

https://Profitwyse.com/Profitwyse-Aca...