|Home||Workshops||Calendar||Registration Form||General Information||About FAST3||Contact Us|
Our Microsoft Excel workshops include:
Excel 2013 (Windows)
Excel 2010 (Windows)
This 6-hour course is designed for those who desire to gain skills to create, edit, format, and print basic Microsoft Excel 2013 worksheets. Upon successful completion of this course, attendees will be able to: create a basic worksheet using Excel 2013; perform calculations in an Excel worksheet; modify and format an Excel worksheet; manage an Excel workbook; and print the contents of an Excel workbook.
In this 6-hour Excel 2013 Level 2 course, you will create advanced formulas; analyze data with logical and lookup functions; organize worksheet data with tables; visualize data by using charts; and analyze data with PivotTables, slicers, and PivotCharts. This course is about one simple idea: asking your data questions and using Excel 2013 to find the answers.
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.
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.
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.