Excel

Excel 2007 Sm

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, SmeOC develops course ware 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. Our 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.

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

Learn more about our webinars

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

Leave a Reply