MICROSOFT EXCEL

Learn the industry standard in spreadsheet applications from our award winning instructors. Our one-on-one approach and group programs are tailor made to fit your precise needs. Unlike generic, standardized public classes, MTC develops courseware and program agendas based on an Excel training needs analysis. We can focus on spreadsheet fundamentals with gradual emphasis on charting and graphing or incorporation of databases and Excel forms. The overview / outline of the Excel course below was developed to provide you with a sampling of modules that you can learn. Topic areas may be added and removed based on your exact specifications. MTC coaching programs are dynamic and self-paced - if you're a beginning user and are able to grasp the fundamentals relatively fast, our consultants will adjust the program agenda accordingly, i.e., introducing intermediate and even advanced modules dependent on your proficiency and comfort levels.

• Create professional workbooks quickly by utilizing our tips and shortcuts
• Manipulate cells and cell data by using a variety of repositioning techniques
• Perform calculations on data by developing formulas, including functions
• Change the appearance of worksheet data by employing Excels powerful formatting tools
• Learn to use Excel as a database using its powerful Autofilters and Form tools
• Create & modify Pivot Tables and Charts

Interested in CBT's (computer based training on CD or DVD)? SMEs Inc. develops customized CBT courses that contain only the topics you're interested in learning or reinforcing!

OUTLINE

• Develop a Spreadsheet from scratch
• Powerful Excel keyboard and mouse shortcuts
• Create additional Worksheets / Save a Workbook
• Move Data to Other Cells
• Creating and Modifying Charts
  • Change the Chart Type
  • Create both Embedded Charts and. Chart Sheets
  • Formatting X and Y axis, data series, plot areas
• Insert and Delete Rows and Columns Freeze and Unfreeze Rows and Columns
• Customizing Headers and Footers
• Performing Calculations
  • Sum a Range of Data Print a Range
  • Copy a Formula
  • Create an Absolute Reference
  • VLook Ups
• Pivot Tables
• Formatting
  • Specify Numerical Format
  • Create a Custom Numeric Format
  • Change Font Size and Type
  • Add Borders to Cells
  • Format painter for consistent look and feel
  • Change Column Width and Row Height
  • Align Cell Contents
• Using Excel as a database
• Creating forms to manage your Excel database
• Auto Filters
• Macros

Please note that this is an overview of course modules. SMEs Inc. will add or remove topics based on your specific requirements.

You may Contact Us by clicking on the button below: