Microsoft Excel

Spreadsheet Consulting

Consulting projects include setup of a spreadsheet with advanced formulas, macros and additional features as deemed necessary.  Once the project is complete it will be delivered with documentation and instruction in its use.

Training

Basic Excel will provide an overview of: orientation of the Excel screen, creating, editing and printing a basic spreadsheet, changing column widths, spell checking, formatting cells, basic arithmetic formulas, and the SUM function, copying and moving data.  After this course you will be able to create a basic Excel spreadsheet with simple formatting.

Intermediate Excelwill provide an overview of: working with multiple sheets and workbooks, copying and moving data between sheets and workbooks, linking data between sheets and workbooks, absolute cell referencing, sorting, creating a basic bar chart and pie chart.  After this course you will be able to create a 3-dimensional spreadsheet, create spreadsheet with links, create advanced formulas, and create charts.

Advanced Excel will provide an overview of: creating, executing, and editing macros, testing macros with the step mode, building onto existing macros, pivot tables, database feature, paste special, protection feature.  After this course you will be able to macros to automate repetitious tasks, create a simple database within Excel, and analyze data with a pivot table.

Excel Charting Classwill provide an overview of: creating various types of charts, modifying chart data, placing charts with spreadsheets, placing chart on a separate sheet, modifying legends, grid lines, axises, and how to use Drawing tools to enhance a chart.  After this course you will be able to create a detailed bar or pie chart with advanced formatting.

Comments are closed.