|
|
| Home | Workshops | Calendar | Registration Form | General Information | About FAST3 | Contact Us |
 |
Microsoft Excel
Excel 2003: Getting StartedExcel is an electronic spreadsheet that adapts calculations from paper and the calculator to the computer. This short course enables you to identify the components of the Excel window and enter data in a worksheet. It also covers various formatting options in Excel, and describes how to manage and print Excel files and customize the appearance of a workbook.
Excel 2003: Showcase your Data with ChartsAlmost everyone has seen or worked with a chart at one time or another--charts illustrate data, relationships, or trends graphically. Like the saying "a picture is worth a thousand words," charts are often better at presenting information than hard-to-read numbers. In this short course, you will learn just about everything there is to know about charts. The dazzling charts you will be able to create after you finish this course will impress both you and your colleagues.
Excel 2003: Formulas & FunctionsThis short course focuses on how to work with formulas and functions in Excel worksheets. Formulas are equations that perform calculations on values in a worksheet. Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order, or structure. Functions can then be used to perform simple or complex calculations. Attendees will learn how to work with formulas; use references and AutoSum; enter functions; use basic and date functions; as well as financial and logical functions.
Excel 2003: Database FunctionsAlong with spreadsheet functionality, Excel can also keep track of information in lists or databases. Some examples of things you might track in a list include telephone numbers, clients, and employee rosters. Once you create a list in Excel, you can easily find, organize, and analyze its information with Excel’s rich set of list-management features. In this short course, you will learn how to create a list, and then add, modify, delete, and find information in it. You’ll also learn how you can use Excel’s filter commands to display specific information. And finally, we'll see how easy it is to use information stored in Excel as a list of database when performing a Word mail merge.
Excel 2003: Data AnalysisAlthough you might think of Excel as only a spreadsheet software program used to record data, it is also an excellent tool for analyzing that 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 2003, 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--regardless of your profession. This course will give you the skills to create, edit, format, and print basic worksheets and charts in Excel. Upon successful completion of this course, attendees will be able to:
Excel 2003, Level 2This course will cover topics such as streamlining and enhancing spreadsheets with templates, charts, graphics, and advanced formulas Upon successful completion of this course, attendees will be able to:
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, 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 2003: Collaboration ToolsThese days, information systems have to do more than just store your data. They must make it easy for you and your colleagues to work with information as a team. The ability to collaborate is not a luxury, but a key to business success. Performing accounting functions, such as financial reporting, budgeting, and analysis, usually requires a great deal of collaboration. For example, people from different departments often need to submit budget requests for the coming year. How do you consolidate all that information? In this short course you will learn about how to share a workbook, how to track changes, add comments, and merge workbooks.
Excel 2003: Tips and TricksEver wish you had an Excel expert at your shoulder while you work, always ready with great tips and tricks for working with your data? After attending this short course, you’ll be that expert! Explore some strategies for designing a new worksheet; learn some time-saving tricks for selecting data in a worksheet, different ways to use the autofill feature, and how to work more efficiently with formulas and functions, including how to use formulas to edit and proofread a spreadsheet.
Excel 2003: In the ClassroomMicrosoft Excel is seen by many as the industry standard for data analysis, including graphing and producing lists. Many educators from all levels are learning that applications like Excel not only need to be introduced in a students' K-12 program, but need to be introduced early and revisited often to reinforce the skills associated with such applications. This short course will explore the use of Excel in a K-12 classroom as well as the use of templates for use by teachers to help make their classroom run smoothly. Upon successful completion of this course, attendees will be able to:
Excel 2003: Save Time with Worksheets & 3-D ReferencesWorksheets provide a logical and intuitive way to organize your data in Microsoft Excel. Frequently, multiple worksheets are used to further separate data into categories such as date or product type. The ability to work with data in multiple worksheets is a necessary skill for Excel users. In this short course, we will work with multiple worksheets including formulas that reference information from several different worksheets. Upon successful completion of this course, attendees will
be able to:
Excel 2003: Track and Analyze Your Business Data using MS ExcelMicrosoft Excel is a powerful tool for tracking business data. Whether you're running a small business or you work in a large corporation, you can use Excel to create worksheets for tracking and projecting sales, determining appropriate service charges, and calculating a wide variety of formulas. Upon successful completion of this course, attendees will
be able to:
Excel 2003, Level 3In this six-hour course you will learn how to automate common Excel tasks with macros, apply advanced analysis techniques to more complex data sets, collaborate on worksheets, with others, and share Excel data by importing and exporting. We will conclude by working with the structure of workbooks with XML.
|
|||||||||||||||||||||||||||||||||||||||||||||