Microsoft Excel
is a powerful tool for developing spreadsheets. Learn to create
financial spreadsheets, utilize formulas, organize your data in charts and
more!
Microsoft Excel for Windows is the most
popular spreadsheet program today. Use it for financial analysis, budgeting,
financial worksheets, sales projections, and more.
Microsoft Excel Introduction :
In this class you will learn how to design financial spreadsheets, create
formulas to total rows and columns, do averages and percentages, copy and
move information, apply formatting to your spreadsheets, use the format
painter, print, insert and remove columns and rows, do margins and set print
ranges, and work on multiple spreadsheets at the same time.
Download Class-Outline
- Register
Microsoft Excel Intermediate: In this class you'll create
and filter lists, use graphing features to create bar, line and pie charts
from spreadsheets, enhance your charts, and link formulas across sheets.
You'll also learn Excel's database features, create your own template, and
learn how to use pivot tables. Using advanced functions in formulas will
also be practiced.
Download Class-Outline
- Register
Microsoft Excel Advanced Training Classes:
We will learn importing and exporting, use of data forms and named ranges,
formatting numbers, using the solver, sorting and filtering lists, creating
macros, spreadsheet protection and validation, master data validation,
merging and linking workbooks, and using advanced data analysis tools and
lookup functions such as VLookup.
Download Class-Outline
Microsoft Excel VBA:
In this class you'll learn to
simplify your work in Excel by automating many of the repetitive tasks that
are part of spreadsheet development. You'll apply the Visual Basic for
Applications (VBA) programming language to simplify many of the tasks you
learned in Excel Introduction and Excel Intermediate.
Download Class-Outline