|
|
| Home | Workshops | Calendar | Registration Form | General Information | About FAST3 | Contact Us |
 |
Microsoft Excel
Excel 2007: New FeaturesThis 3-hour course is designed for experienced Excel users who have worked with earlier versions of the program, and who have recently upgraded to Excel 2007. Upon successful completion of this workshop, students will feel more comfortable navigating the new Excel 2007 environment. They will learn how to organize data in Excel worksheets using enhanced tables and table formats; analyze Excel data by applying enhanced conditional formatting, and generate specific information using the sort and filter options; present Excel data using enhanced charts and illustrations, and work with the enhanced options of PivotTables and PivotCharts for conducting selective analysis.
Excel 2007: Getting StartedExcel 2007 has been redesigned with a more streamlined overall look and feel. This new short course enables you to comfortably move around in the Excel window. Additional topics include entering text and values in a worksheet, basic formatting, printing and using Help.
Excel 2007: Showcase your Data with ChartsWith Excel 2007 it is easier than ever to create professional-looking charts to turn raw data into meaningful information. In this new 2-hour workshop, we will learn how to select data in a worksheet and work with the new Chart Tools to customize the chart type, chart layout, and chart style (all of which are within easy reach on the Ribbon) 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.
Excel 2007: Formulas & FunctionsIn this new short course you will learn how to add, divide, multiply, and subtract by typing formulas into Excel 2007worksheets. Other topics will include using the new Formula AutoComplete which will display below the cell a dynamic drop-down list of valid functions, names, and text strings that match the letters or trigger entered in the cell. We will look at a few of the hundreds of functions provided in Excel and learn how to find a specific function, as well as get help to enter 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 and time.
Excel 2007: Database FunctionsExcel 2007 introduces a whole new set of features for managing information in tables (formerly called lists). These new 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.
Excel 2007: Data AnalysisAlthough 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.
Excel 2007: VBA (Visual Basic for Applications)In this 6-hour course, you will apply the Visual Basic for Applications (VBA) programming language to simplify tasks that you perform using tools and functions in Excel 2007. Topics include learning how to create, edit, and debug a macro; format worksheets (insert and format text, sort and duplicate data, and generate a report); create an interactive worksheet; work with multiple worksheets and create user defined functions and automate SUM functions.
Excel 2007, Level 1Excel isn't just for financial professionals. This spreadsheet and analysis program offers intuitive tools that make it easy to access, connect, and analyze critical data. This 6-hour course will introduce the Excel 2007 environment as we create a basic worksheet and perform basic calculations. We will also learn how to modify and format a worksheet. Finally, we will look at printing options and features to help manage large workbooks.
Excel 2007, Level 2This intermediate-level course will cover topics such as streamlining and enhancing spreadsheets with templates, charts, graphics, and advanced formulas. Upon completion, attendees will be able to calculate with advanced formulas; organize worksheet and table data using various techniques; create and modify charts; analyze data using PivotTables and PivotCharts; insert graphic objects; and customize and enhance workbooks and the Excel 2007 environment.
Excel 2007, Level 3In this 6-hour course, you will extend your knowledge into some of the more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications.
Excel 2007, Level 4Excel has many tools and functions that help you in analyzing data for decision-making in the domain of areas like sales, project management, credit, equities, futures, options, currency, etc. In this 6-hour course, you will use the advanced features of Excel 2007 to forecast data using functions; analyze data using the data analysis tools; make investment decisions using financial functions; examine data using math functions; and manipulate data using text and information functions. You will also learn how to create advanced templates and work with the advanced chart options as well as manage data in Excel workbooks, such as retrieving and pasting data, and cleaning data.
|
||||||||||||||||||||||||||||||||