|Home||Workshops||Calendar||Registration Form||General Information||About FAST3||Contact Us|
Our Microsoft Excel workshops include:
Excel 2013 (Windows)
Excel 2010 (Windows)
In this 1-hour overview, we will explore the new look and feel of Excel 2013. We’ll take a look at templates first thing-- they do most of the set-up and design work for you, so you can focus on your data. There are templates for budgets, calendars, forms, reports, and more. Next we’ll explore some new tools, including the new Power View sheet. Power View is essentially an interactive canvas that allows you to display charts, tables, maps, and slicers in one dashboard window. We’ll also see how much easier it is to work with charts by trying out the Quick Analysis tool which lets you convert your data into a chart or table in two steps or less and the Chart Recommendations which suggests the most suitable chart for your data. We will see how to use a standalone PivotChart (interactive chart) that does not need to be associated with a PivotTable.
We will explore some of the new functions in the math and trigonometry, statistical, engineering, date and time, lookup and reference, logical, and text function categories, as well as a few Web service functions for referencing existing Representational State Transfer (REST)-compliant Web services.
We will look at what’s new when working with data, including creating
relationships between related data and drilling up or down through
complex layers of data. Slicers in 2013 will also be explored to display
graphical representation of filter values.
In this 2-hour short course you will learn how to comfortably move around in the Excel 2010 environment. Additional topics will include entering text and values in a worksheet, basic formatting, printing and using Help.
This 6-hour course is designed for those who desire to gain the necessary skills to create, edit, format, and print basic Microsoft Excel 2010 worksheets. Upon successful completion of this course, attendees will be able to: create a basic worksheet using Excel 2010; perform calculations in an Excel worksheet; modify and format an Excel worksheet; manage an Excel workbook; and print the contents of an Excel workbook.
This intermediate-level course will cover topics such as calculating with advanced formulas, organizing worksheet and table data using various techniques, creating and modifying charts, analyzing data using PivotTables and PivotCharts, inserting graphic objects, and customizing and enhancing workbooks and the Excel 2010 environment.
In this 2-hour short course you will learn how to add, divide, multiply, and subtract by entering formulas into Excel 2010 worksheets. Other topics will include an exploration of just a few of the hundreds of functions available in Excel. We will learn how to find a specific function, as well as how to get help while entering arguments. Finally, we will sample a function or two from some of the more commonly used categories of functions including statistical, logical, financial, and date & time.
In this 2-hour workshop, you will learn how to select data in an Excel 2010 worksheet and work with Chart Tools to customize the chart type, chart layout, and chart style that best represents the data. Once the chart is exactly the way you want it, we will learn how to save it as a template to use again.
Your Excel 2010 worksheet has a lot of data, but do you know what the numbers mean? Does the data answer all of your questions? PivotTable reports can help to analyze numerical data. In this 2 hour short course you will learn how PivotTable reports work, how to filter data, and how to use summary functions to calculate numbers. We will also see how easy it is to graphically display data in a PivotTable report as a PivotChart.
In this 2-hour workshop we will explore the whole set of features for managing information in tables in Excel 2010. These features make all the typical tabular manipulations—sorting, filtering, analyzing, and formatting easier than ever. Topics will include learning about sorting on as many criteria as you need (including the ability to sort by color fills in cells); filtering on multiple criteria or icon sets applied with conditional formatting; highlighting and removing duplicate data; and applying consistent and professional-looking formatting.
Although you might think of Excel as only a spreadsheet program used to record and calculate data, it is also an excellent tool for analyzing data. This short course will explore the use of pivot tables and pivot charts when summarizing large amounts of data. We will also look at one of the most appropriate categories of functions for analysis--statistical functions--including VAR, NORMDIST, and STDEV. And finally we will explore analysis tools such as Goal Seek, Solver, and Scenarios.