Archive | Excel Tips

microsoft_excel_2013_logo-svg

Mastering Data Analysis: Central Limit Theorem (Part 5)

This post in the tutorial set is more thereotical, rather than practical, so Excel will not be required in this post. Central Limit Theorem states that “for a sufficiently large sample size from a population with a finite level of variance, the mean of all samples from the same population will be approximately equal to […]

Continue Reading 0
microsoft_excel_2013_logo-svg

Mastering Data Analysis: Variance and Standard Deviation (Part 4)

Variance and standard deviation are useful statistical information that will give an indication of the how distributed the data is. Variance is how distribution/ “varied” the data is, and standard deviation of how much the members of a group differ from the mean value for the group. Variance VAR.P : Calculate variance based on entire […]

Continue Reading 0
Microsoft_Excel_2013_logo.svg

Mastering PivotTables: Part 14 (Conditional Formatting in PivotTables)

Conditional formatting helps you visually explore and analyse data, detect critical issues/problems, and allows you to identify pattern and trends in the data. It is important to understand the differences when using conditional formatting on a PivotTable. There are three methods for scoping the conditional format of fields in the Values area: by selection, by […]

Continue Reading 0
Microsoft_Excel_2013_logo.svg

Mastering Data Analysis: Introduction (Part 1)

In this post, I will highlight the topics that will be covered in this tutorial. There will be 6 main parts to this tutorial that involves using Excel, which consists of: Descriptive Statistics Visualisation Testing Hypothesis Probability Distributions Co-variance & Correlation Bayesian Analysis I will describe more about these main topics in future tutorials. However, […]

Continue Reading 0

Mastering PivotTables: Part 13 (Timelines)

Timelines are similar to Slicers, except that it is only limited to showing data related to Dates. Timelines allows easier visualization of data in a set amount of time, and allows easier analysis of data. Open this document (same document as Slicer) or open any Excel document that has data related with Dates. Navigate to the […]

Continue Reading 0

Mastering PivotTables: Part 12 (Slicers)

One prominent problem with PivotTable report filters is the need to constantly open the drop-down list to see which multiple items are activated. A slicer can easily show you which items are active and inactive, making it easier to understand the data. Slicers can also allow you to easily filter the data in a PivotTable, […]

Continue Reading 0

Mastering PivotTables/Charts: Part 10 (Using Tables as Data Sources)

By turning a range of cells into an Excel table, you can make managing and analyzing a group of related data easier. A table typically contains related data in a series of rows and columns in a worksheet that have been formatted as a table. By using the table features, you can then manage the […]

Continue Reading 0

Powered by WordPress. Designed by WooThemes

Free WordPress Themes