Excel

Excel 2013: Data Analysis with Pivot Tables

Facilitator Information: 

New Horizons

Excel 2013 Charts & Graphs

Facilitator Information: 

New Horizons

Excel 2013 Part Two

Facilitator Information: 
  • New Horizons

Excel 2013 Part One

Facilitator Information: 
  • New Horizons

Excel 2013 Dashboards

Facilitator Information: 
  • New Horizons

In-Person Courses

Topics:
Intro to Chart Terminology
o Data Point vs. Data Series
o Axes
o Legend
o Plot Area
o Structuring worksheet data for charting
Creating a Chart
o As a New Sheet
o As an Embedded Chart
o Selecting Contiguous Cells
o Selecting Non-Adjacent Cells
Modifying a Chart
o Changing Chart Type
o Changing Chart Layout
o Changing Chart Styles
o Changing Source Data
▪ Viewing same data as different types of charts.
o Adding and Modifying Layout Elements of a Chart
▪ Data Labels
▪ Axis Labels
Formatting Charts
o Selecting Individual Elements of a Chart
o Text and Number Formatting
o Fill and Border Formatting

2-D Charts (X, Y Axis)
o Formatting and Modifying:
▪ Scale
▪ Trendlines
▪ Switching Rows and Column Data
3-D Charts (X, Y, Z Axis)
o Formatting and Modifying:
▪ Rotation
▪ Perspective
▪ Elevation
Adding Sparklines to a Data Range (Excel 2010 only)
o Line
o Columns
o Win-Loss
Saving Chart as a Template, and setting as default chart type.
Using Charts with Other Applications
(Word, PowerPoint, PDF, etc.)
o Copying
o Linking
o Updating
 

Upon successful completion of this course, individuals will be able to create dashboards in Microsoft Office Excel 2013. 

Individuals will: 
•Create advanced formulas.
•Automate workbook functionality.
•Apply conditional logic.
•Visualize data by using basic charts.
•Implement advanced charting techniques.
•Analyze data by using PivotTables, slicers, and PivotCharts.

This is a two part program. In order to receive credit, participants must attend: 

October 31st, 2017 & November 7th, 2017 from 1:00 p.m. to 4:30 p.m.

OR

April 17th, 2018 & April 24th, 2018 from 1:00 p.m. to 4:30 p.m.

In this course, participants will use Microsoft® Office Excel® 2013 to create spreadsheets and workbooks that they can use to store, manipulate, and share data.
Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyze the data that is critical to the success of your organization. 
You will: 
•Get started with Microsoft Office Excel 2013
•Perform calculations
•Modify a worksheet
•Format a worksheet
•Print workbooks
•Manage workbooks

This course is a two part session. In order to receive credit you must be able to attend: 

October 31st, 2017 & November 7th, 2017 from 8:30 a.m. - 12:00 p.m.

OR

January 23rd, 2018 & January 30th, 2018 from 8:30 a.m. - 12:00 p.m.

OR

March 20th, 2018 & March 27th, 2018 from 8:30 a.m. - 12:00 p.m.

OR

April 17th, 2018 & April 24th, 2018 from 8:30 a.m. - 12:00 p.m.

Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions. 
In this course, you will: 
•Customize the Excel environment
•Create advanced formulas
•Analyze data by using functions and conditional formatting
•Organize and analyze datasets and tables
•Visualize data by using basic charts
•Analyze data by using PivotTables, slicers, and PivotCharts

This course is a two part session. In order to receive credit you must be able to attend: 

December 5th, 2017 & December 12th, 2017 from 8:30 a.m. - 12:00 p.m.

OR

March 20th, 2018 & March 27th, 2018 from 1:00 p.m. - 4:30 p.m.

COURSE OUTLINE

1 - PREPARING DATA AND CREATING PIVOT TABLES

Prepare Data

Create a PivotTable from a Local Data Source

Create a PivotTable from Multiple Local Data Sources

Create a PivotTable from an External Data Source

2 - ANALYZING DATA USING PIVOTTABLES

Summarize PivotTable Data

Organize PivotTable Data

Filter PivotTable Data

Format a PivotTable Refresh and Change PivotTable Data

3 - WORKING WITH PIVOTCHARTS

Create a PivotChart

Manipulate PivotChart Data

Format a PivotChart

Online Courses

In Excel 2010 Essential Training, Bob Flisser demonstrates the core features and tools in Excel 2010. The course introduces key Excel skills, shows how to utilize these skills with in-depth tutorials on Excel functions and spreadsheet formatting. It also covers prepping documents for printing, working with large worksheets and workbooks, collaborating with others, using Excel as a database, analyzing data, charting, and automating and customizing Excel. Exercise files are included with the course.

Topics include:

  • Copying and pasting techniques
  • Working with formulas and functions
  • Dealing with formula errors
  • Creating lookup tables
  • Naming cell ranges
  • Formatting data and worksheets
  • Finding and replacing data
  • Creating SmartArt diagrams
  • Creating charts and PivotTables
  • Recording macros
  • Sharing workbooks

Whether you're a novice or an expert wanting to refresh your skillset with Microsoft Excel, this course covers all the basics you need to start entering your data and building organized workbooks. Author Dennis Taylor teaches you how to enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data, and build charts and PivotTables. Other lessons cover the powerful IF, VLOOKUP, and COUNTIF family of functions; the Goal Seek, Solver, and other data analysis tools; and how to automate many of these tasks with macros.

Topics include:

  • What is Excel and what is it used for?
  • Using the menus
  • Working with dates and times
  • Creating simple formulas
  • Formatting fonts, row and column sizes, borders, and more
  • Inserting shapes, arrows, and other graphics
  • Adding and deleting rows and columns
  • Hiding data
  • Moving, copying, and pasting
  • Sorting and filtering data
  • Printing your worksheet
  • Securing your workbooks
  • Tracking changes

Join Curt Frye as he explains how to leverage PivotTables to summarize, sort, count, and chart your data in Microsoft Excel. Curt shows you how to navigate the complexity of PivotTables while taking advantage of their power. This course shows how to build PivotTables from single or multiple data sources, add calculated fields, filter your results, and format your layout to make it more readable. Plus, learn how to enhance PivotTable with macros, DAX expressions, and the PowerPivot add-in for analyzing millions of rows of data.

Topics include:

  • Creating a PivotTable
  • Summarizing multiple data fields
  • Managing subtotals and grand totals
  • Grouping PivotTable fields
  • Filtering with selections, rules, slicers, and search filters
  • Applying PivotTable styles
  • Formatting cells
  • Creating PivotCharts
  • Enabling PowerPivot
  • Using DAX operators
  • Visualizing data with matrices, cards, and tiles
  • Building charts and maps

Visualize data and get new insights into your information with Excel's charts and graphs. Learn how to create and modify charts, graphs, tables, and SmartArt to enhance your spreadsheets or other Office documents. This course covers all of the essential features needed to get up and running with these valuable Excel tools.

Topics include:

  • Creating a chart
  • Picking a chart type
  • Displaying data with tables
  • Editing data in a chart
  • Adding SmartArt graphics

 

Start mastering Excel, the world's most popular and powerful spreadsheet program, with Excel expert Dennis Taylor. Learn how to best enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data and cells, and build charts and PivotTables. Other lessons cover the powerful IF, VLOOKUP, and COUNTIF family of functions; the Goal Seek, Solver, and other data analysis tools; and automating tasks with macros.

Topics include:
  • Working with the Excel interface
  • Entering data
  • Creating formulas and functions
  • Formatting rows, columns, cells, and data
  • Working with alignment and text wrap
  • Adjusting rows and columns
  • Finding and replacing data
  • Printing and sharing worksheets
  • Creating charts and PivotTables
  • Inserting and deleting sheets
  • Using power functions such as IF and VLOOKUP
  • Password-protecting worksheets and workbooks
  • Sorting data
  • Analyzing data with Goal Seek and Solver
  • Creating and running macros

Excel expert Dennis Taylor helps Excel 2016 users take their spreadsheet skills to the next level with this collection of tips and tricks. He begins with his top 10 productivity boosters, and then highlights navigation, display, and selection techniques to keep you moving quickly.

The course then dives into data entry and editing techniques, formatting and drag-and-drop tricks, keyboard shortcuts for working with formulas, data management strategies, and chart tricks. Short on time? Make sure to check out the "10 Tiny Tips" chapter for a quick productivity boost.

Topics include:
  • Entering today's date or time instantly
  • Converting formulas to values with a simple drag
  • Undoing and redoing with keyboard commands
  • Accessing the Ribbon from the keyboard
  • Creating split screens fast
  • Navigating in workbooks quickly
  • Selecting noncontiguous ranges
  • Entering data more efficiently
  • Dragging and dropping data
  • Performing calculations without formulas
  • Applying formatting with keyboard shortcuts
  • Using database techniques to work with Excel data
  • Working with charts, shapes, and linked images

Excel expert Dennis Taylor demystifies some of the most useful of the 450+ formulas and functions in Excel and shows how to put them to their best use. Dennis starts with a review of the more basic functions (SUM, AVERAGE, and MAX), and a few critical keyboard shortcuts that will let you locate and display formula cells and accelerate working with Excel formulas—even on multiple sheets. He then covers how to find and retrieve data with the VLOOKUP and INDEX functions, calculate totals with counting and statistical functions, extract data with text functions, and work with date, time, array, math and information functions. The course focuses on practical examples that will help viewers easily transition to using Excel's most powerful formulas and functions in real-world scenarios.

Topics include:
  • Displaying and highlighting formulas
  • Converting formulas to values
  • Tabulating data from multiple sheets
  • Understanding the hierarchy of operations in formulas
  • Using absolute and relative references
  • Creating and expanding nested IF statements
  • Looking up information with VLOOKUP, MATCH, and INDEX
  • Using the powerful COUNTIF family of functions
  • Analyzing data with statistical functions
  • Calculating dates and times
  • Analyzing data with array formulas and functions
  • Extracting data with text function

Charts allow you to communicate information visually, in a way that's more impactful than raw data, and they happen to be one of the most powerful and easy-to-use features in Microsoft Excel. In Excel 2016, there are six brand-new chart types to learn. Let Dennis Taylor show you how to create different kinds of Excel charts, from column, bar, and line charts to exploded pies, and decide which type works best for your data. Learn how to fine-tune your chart's color and style; add titles, labels, and legends; insert shapes, pictures, and text boxes; and pull data from multiple sources. Plus, get an overview of the new chart types in Excel 2016: Treemap, Sunburst, Waterfall, Histogram, Pareto, and Box & Whisker.

The training wraps up with lesson on changing data sources for charts and printing and sharing charts.

Topics include:
  • Identifying chart elements
  • Selecting the right chart type
  • Creating basic charts
  • Creating sparklines
  • Styling charts
  • Moving and resizing charts
  • Modifying axes
  • Adding labels and gridlines
  • Analyzing data with trendlines
  • Inserting pictures, shapes, and text boxes
  • Customizing column, bar, line, and pie charts
  • Creating Gantt charts and other specialized Excel charts
  • Changing data sources
  • Printing and sharing charts

Learn how to use PivotTables to summarize, sort, count, and chart your data in Microsoft Excel 2016. Author Curt Frye shows you how to navigate the complexity of PivotTables while taking advantage of their power. This course shows how to build PivotTables from single or multiple data sources, add calculated fields, filter your results, and format your layout to make it more readable. Plus, learn how to create PivotCharts to visualize your data, enhance PivotTables with macros, and use the Data Model feature to build PivotTables from related tables.

Topics include:
  • Formatting data for use in a PivotTable
  • Creating a new PivotTable
  • Connecting to data sources
  • Consolidating data from multiple data sources
  • Creating calculated fields
  • Summarizing field data
  • Sorting and filtering PivotTables
  • Working with Excel slicers
  • Formatting PivotTables with styles and formats
  • Applying conditional formats
  • Creating PivotCharts
  • Printing PivotTables
  • Running macros
  • Creating a PivotTable using the data model