## Progress Log 68 (Excel): Moving Averages

I’m taking a nanodegree course entitled “Data Analysis” by Udacity and all of the concepts described below come from that course. Moving Averages   Moving averages smooth out data to make it easier to observe long term trends and not get lost in daily fluctuations. Let us first evaluate sales …

## Progress Log 55 (Python 3): Final Assessment

I’m taking a course entitled “Introduction to Python: Fundamentals” by Microsoft at edX and all of the concepts described below come from that course.   Assessment     Code periodic_table_20 = [“Hydrogen”, “Helium”, “Lithium”, “Beryllium”, “Boron”, “Carbon”, “Nitrogen”, “Oxygen”, “Fluorine”, “Neon”, “Sodium”, “Magnesium”, “Aluminium”, “Silicon”, “Phosphorous”, “Sulfur”, “Chlorine”, “Argon”, “Potassium”, “Calcium”] …

## Progress Log 11 (EXCEL): Butterfly Charts II; Add a Heatmap to Your Pivot Table, Turn Your Pivot-Heatmap into a Butterfly Combo Chart, Calculate Percentages for Bar Graphs and Column Graphs, Select Percentage Range and Create the Bar Graphs and Column Graphs, Formatting the Bar Chart to be a Butterfly Wing, Remove the Border of the Visualization and Enlarge and Move the Bar Chart to Cover the Calculations and Fit Right on Top of the Pivot Table, Repeat the Exercise for a Column Chart, with the Addition of Inverting your Column Chart Axis

I’m taking a course entitled “Data Visualization: A practical approach for absolute beginners” at edX and all of the concepts described below come from that course.   Add a Heatmap to Your Pivot Table   Calculate Percentages for Bar Charts   Calculate Percentages for Column Charts   Select the calculation range …

## Progress Log 10 (EXCEL): Butterfly Charts; Expand Columns, Create a Pivot Table, Add Specific Fields, Filter the List of Products, Set Filters for the Fields with Specific Values, Sort the Columns and Rows in Reverse Alphabetical Order, Sort the Sales Total in Descending Order, Show Data of Sales as Currency on Pivot Table

I’m taking a course entitled “Data Visualization: A practical approach for absolute beginners” at edX and all of the concepts described below come from that course.   Expand Columns Expand the columns by clicking on “A”, the first column, and hold Shift; then move your mouse over to column “K”, and …

## Progress Log 8 (EXCEL): Business Context, Ways to Share your Visualizations, Create a Pivot Table and a Pivot Chart, Add a Heatmap, Add a Scorecard, Add Data Slicers, Add a Field Reference for Total Sales, Add a Sales to Target Calculated Field

I’m taking a course entitled “Data Visualization: A practical approach for absolute beginners” at edX and all of the concepts described below come from that course. Business Context It’s important in business to know your audience. This is the first step in deciding how to frame your business visualizations. Here are …

## Progress Log 6 (EXCEL): Add Derived Columns, Add Month, Filter by Month, Highlighting Extremes and Outliers, Create a Pivot Table, Display Data on the Pivot Table

I’m taking a course entitled “Data Visualization: A practical approach for absolute beginners” at edX and all of the concepts described below come from that course.   Add derived columns   Add month   Filter by Month   Highlighting Extremes and Outliers Step one: Select C2, hold Shift, Ctrl, Down-Arrow to select …

## Progress Log 5 (EXCEL): Set up your Data for Better Analysis, Displaying Particular Data, Sort by Descending Order, Show All Data, Sort by Ascending Order

I’m taking a course entitled “Data Visualization: A practical approach for absolute beginners” at edX and all of the concepts described below come from that course.   Set up your data for better analysis   Displaying particular data   Sort data in descending order   Show all data   Sort …

## Progress Log 2 (EXCEL): Formatting your Table, Creating a Chart, Changing Chart Types, Changing Data Displayed in your Chart, Sort your Chart

I’m taking a course entitled “Data Visualization: A practical approach for absolute beginners” at edX and all of the concepts described below come from that course. Today, I picked up a few new tricks on Microsoft Excel. Being a visual learner, recording the process is helping me absorb information a …