joanna

About Joanna Siennicka

• 20 years of experience lecturing at the Faculty of Business, University of Alberta and Grant MacEwan University, Edmonton, Alberta
• 10 years senior leadership experience in professional development organizations
• Worked with students, teams, and individuals on national and international platforms

An Example of Using a PivotTable Instead of the SUBTOTAL Command

Recently we posted an article in which we looked at the example of the SUBTOTAL command. We used this command to analyse the data set for the top 25 car sales by country in 2020. Figure 1. In this post we would like to use a Pivot Table for [...]

By [Joanna Siennicka](/content/author/joanna/ "Posts by Joanna Siennicka"/index.html) | 2022-01-26T17:43:37-07:00 January 26th, 2022 | Data Analysis, Excel, PivotTables

An Example of Using the Subtotal Function in Excel

The SUBTOTAL function is incredibly versatile, and the name is misleading since it can perform any of 11 different calculations not just finding totals. The particular calculation is controlled by using a specific value for one of the arguments, which we will describe below. There are two main reasons why the SUBTOTAL function is so [...]

By [Joanna Siennicka](/content/author/joanna/ "Posts by Joanna Siennicka"/index.html) | 2021-12-13T13:38:39-07:00 December 13th, 2021 | Data Analysis, Excel, MS Office 2016

An Example of Using the Subtotal Command in Excel

In the previous article we discussed the SUBTOTAL function. In this post we will look at the SUBTOTAL command found on the Data tab in the Outline group. Each Excel function provides a specific calculation. We use any of the over 500 functions that Excel provides by typing an = sign in a cell [...]

By [Joanna Siennicka](/content/author/joanna/ "Posts by Joanna Siennicka"/index.html) | 2021-12-13T13:40:56-07:00 December 13th, 2021 | Data Analysis, Excel, MS Office 2016, Subtotal Function and Command

A Story About the Curious Clerk and Excel’s Data Validation.

What comes to your mind when you think about Excel? Most of us think about building tables for data sets, using formulas and tools to analyze data, displaying the data by using charts, and maybe some are eager to do analysis with PivotTables. We have access to multiple tools on the Excel tabs to make [...]

By [Joanna Siennicka](/content/author/joanna/ "Posts by Joanna Siennicka"/index.html) | 2021-07-20T17:35:03-06:00 July 20th, 2021 | Excel, MS Office 2016

A Few Words About the Pearson’s Correlation Coefficient.

“Politicians use statistics in the same way that a drunk uses lamp-posts for support rather than illumination” -A. Lang Statistics is a very complex subject and because of its complexity statistics and its terms are frequently misunderstood and misused. I came across an excellent article on The datapine Blog about how statistics can be misleading. [...]

By [Joanna Siennicka](/content/author/joanna/ "Posts by Joanna Siennicka"/index.html) | 2021-03-26T17:45:50-06:00 March 26th, 2021 | Correlations, Excel, Statistics

How to use the Correlation Command

Once the Data Analysis toolbox has been enabled, the correlation function is ready to use. For this example, we are going to use data from two stock market indexes: NASDAQ Composite Index and the Dow Jones Industrial Average. The data is the daily closing price for the last 6 months of [...]

By [Joanna Siennicka](/content/author/joanna/ "Posts by Joanna Siennicka"/index.html) | 2021-02-17T00:05:15-07:00 December 30th, 2020 | Correlations, Excel, Tutorials and How-Tos

How to Enable Analysis ToolPack in Excel

First: What is the Analysis ToolPak: Excel’s Analysis ToolPak provides a variety of tools and functions which enable sophisticated data analysis to be performed. It produces output tables, and, in addition, some tools also generate charts. The add-in takes the basic Excel functions and combines them into workflows where only the input values and [...]

By [Joanna Siennicka](/content/author/joanna/ "Posts by Joanna Siennicka"/index.html) | 2021-02-18T17:15:05-07:00 December 23rd, 2020 | Excel, Tutorials and How-Tos

Keyboard Shortcuts for Microsoft Excel 2016

Whether you are technologically savvy or not you can still implement shortcuts when using software applications such as Microsoft Excel. The shortcuts are easy to use and remember. For those people that tend to forget things, keeping a printout of the shortcuts is not a bad idea.

By [Joanna Siennicka](/content/author/joanna/ "Posts by Joanna Siennicka"/index.html) | 2021-02-18T17:23:32-07:00 August 26th, 2019 | MS Office 2016, Resources

Keyboard Shortcuts for Microsoft Word 2016

Whether you are technologically savvy or not you can still implement shortcuts when using software applications such as Microsoft Word. The shortcuts are easy to use and remember. For those people that tend to forget things, keeping a printout of the shortcuts is not a bad idea.

By [Joanna Siennicka](/content/author/joanna/ "Posts by Joanna Siennicka"/index.html) | 2021-02-18T17:20:49-07:00 August 22nd, 2019 | MS Office 2016, Resources