IRS Form 1099, 1099-NEC, and Form 1099-MISC: Advanced Issues and Updates

Analysis Reports in Microsoft Excel

$199.00

SKU: 407739

Description

Learn how to properly prepare an analytics report with Microsoft Excel.
Microsoft Excel is the most common analysis software on the market and it is not just for spreadsheets it allows us to easily turn data into sophisticated graphics and charts. PivotTables, charts, and data analysis are amongst the most popular of all analytical tools. This topic provides you with tools to master analysis and reporting from data cleansing to visualization. Learn how to simplify statistics and realize the importance of PivotTables. This information includes creating trend lines, charts, and maps to visually displaying your results. A working knowledge of Excel is recommended for our analysis course.

Date: 2020-07-07 Start Time: 1:00 PM ET End Time: 2:30 PM ET

Learning Objectives

* You will be able to explain the powerful features Excel has to offer to analyze data.

* You will be able to create sparklines, slicers and map data.

* You will be able to identify the analysis tools to simplify statistics and mathematical functions.

* You will be able to describe the functionality of PivotTables and subtotals.

Your Analytical Objective
• Data Analysis – Interpret Meaning
• Understanding the Objective
• Clean up and Extraction

Organizing Your Data: Tables, Filters, Subtotals and Pivots
• Tables
• Filter
• Subtotals
• PivotTables

Visualize Your Data: Charts, Maps, and Trend Lines
• Charts and Graphs
• Line and Bar Charts
• Line Graphs
• Complex Charts
• Summary Charts
• Pie Charts
• High-Low Charts

Frequency and Trend Lines
• Histograms
• Scatter Diagram
• Trend Lines
• Linear Trend Lines
• Logarithmic Trend Line
• Polynomial Trend Lines
• Moving Average Trend Lines
• Maps

Know Your Numbers: Descriptive Statistics
• Data Analysis
• Central Tendencies
• Variability of Data
• Standard Deviation

CPE ,Additional credit may be available upon request. Contact Lorman at 866-352-9540 for further information.

Lauritta Sowa-WiseOwlOps, Inc.