Filtering in Excel: Basics and Beyond
Microsoft Excel Tips and Tricks Learn how to apply filters in Excel in order to focus on only the information[…]
Read more
Category: Excel
Excel Statistical Analysis 06: Frequency Distributions, Visualizations & Skew for Quantitative Data
Microsoft Excel Tips and Tricks Learn about creating frequency distributions and visualizations for quantitative data, including Column Charts for Discrete[…]
Read more
Excel Statistical Analysis 05: Frequency Distributions & Visualizations for Categorical Data
Microsoft Excel Tips and Tricks Learn about creating Frequency Distributions & Column and Bar Chart Visualizations for Categorical Data. Credit[…]
Read more
Excel Statistical Analysis 04: PivotTable & Power Query to Build Frequency Distributions
Microsoft Excel Tips and Tricks Learn about how to use Power Query to import and transform CSV File data and[…]
Read more
Excel – Create a custom list to sort data – Fiscal Months / Products
Microsoft Excel Tips and Tricks Excel makes it easy to sort using built-in custom lists, you can sort data—either by[…]
Read more