GROUPBY function: The future of COUNTIF SUMIF
Find out how to build and use the GROUPBY function in Excel 365. Group data, calculate summaries, and update instantly.
Statistics
Calculate Percentage Change in Excel
Learn how to calculate percentage change in Excel and gain valuable insights into your data trends and performance.
TOP 10 Most Useful Statistical Functions for Data Analysis
Learn the top 10 most useful Excel statistical functions for data analysis, with clear explanations and examples.
Study Case with Excel Statistics functions
How to use Excel statistics functions? In this study case, we will analyze the wages of all the employees and what is the result.
Calculate Moving Average in Excel
Learn how to calculate a moving average in Excel. Use the AVERAGE function to smooth out data and identify trends.
Understand the Standard Deviation
Learn to calculate and interpret standard deviation to better understand your average results.
Categories
- AI & Excel (1)
- Conditional (12)
- Conditional Formatting (18)
- Date (48)
- Dynamic Arrays (10)
- Excel Charts (11)
- Excel Online (4)
- Excel Tests (8)
- Excel Training (15)
- Excel Tutorial (16)
- Expert (26)
- Finance (7)
- Free Excel Tutorial for beginners (29)
- Function (1)
- Intermediate Excel Skills: Tutorials and Articles (19)
- Lookup functions (14)
- Manage data (18)
- Maps and GPS (5)
- Pivot Table (10)
- Power Query (6)
- Quiz Premium (7)
- Shortcuts (5)
- Statistical functions (25)
- Text functions (19)
- Tips and Tricks (21)
