Archive | MS Office 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

Word Page Formatting: Part 4 (Specific Page Setups for Sections – Controlling Margins)

Controlling the margins of specific pages is not really a major aspect in page formatting. Even though you can set specific margins for different pages, it is not important and sometimes useless because most documents you would want would require a consistent margin size. However, I will still show you how to adjust the margins […]

Continue Reading 0

Word Page Formatting: Part 3 (Specific Page Setups for Sections – Controlling Orientation)

Controlling the orientation of specific pages is a frustrating thing to do if you do not know how to do it properly. A common user would only just navigate to the Page Layout tab and just change the orientation, but the result would change the orientation of the whole document, rather than the orientation of […]

Continue Reading 0

How to Make an Outstanding Presentation: Part 2 (Inserting Audio, Video and Screen Recordings)

In the second part of this tutorial, I will show you how to insert audio, video and screen recordings, in which many users do not know how to do, despite it being a simple function. Inserting audio, video and screen recordings is just the basics, but organizing the timing of these functions is what is […]

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

Powered by WordPress. Designed by WooThemes

Free WordPress Themes