Microsoft Excel Classes Microsoft Excel Training Classes in Denver Colorado Microsoft Office Excel 2007 is the essential tool for business productivity. MCS training services will enable Excel users to go beyond simply managing spreadsheets by targeting specific needs and applying the learning's to business productivity. Students of the Microsoft Office Excel training class will not only learn the essential aspects of the Excel interface, but will walk away using the software to analyze, share and make more informed business decisions that impact the bottom line. Mission Critical Systems is located in Denver Colorado and offers training courses in its convenient Downtown Denver location. MCS also offers on-site training for the latest Microsoft Office products and other software applications. Offering training classes for beginners to advanced users, MCS helps businesses be more productive by increasing users understanding of Microsoft Excel. Register for one of the following courses, or contact MCS to discuss on-site professional training. Microsoft Excel Basic – New Users Excel Training Class Goal: Introduction to Excel – for those that are just starting with this software application. Excel Course Outline: Familiarizing students with the Microsoft Excel interface, navigation and views, keyboard and mouse navigation, freezing and splitting panes, sorting data, hiding columns and rows, entering data, date and time formatting, spell check, undo and redo, inserting and deleting rows and columns, basic formulas, simple cell references, functions, AutoSum, AutoCalculate, cutting, copying and pasting data, pasting values and formulas, filling series, AutoFill, Smart tags, copying, hiding and deleting spreadsheets, formatting spreadsheets, margins, headers and footers, print options, setting print areas, repeating headings, adjusting column widths, number formatting with toolbar buttons, working with text in spreadsheets (formatting, wrapping, aligning, paragraph returns, merging and centering), Auto Format. Prerequisite for Excel Course: Ability to use a mouse (click, double-click, right-click, click-and-drag) and ability to type on a keyboard, some use of another Microsoft Office application to understand concepts like menus, toolbars and scroll bars. Register for Microsoft Excel Basic class online using our Training Calendar See if this class is right for you with our quick Skill Assessment

Microsoft Excel - UPCOMING CLASSES!   03/23 -  Excel 2007 - Basic 03/25 -  Excel 2003 - Advanced 03/25 -  Excel 2007 - Intermediate 03/29 -  Excel 2003 - Basic 04/09 -  Excel 2007 - Advanced     On-site Private Classes       Microsoft Word Training     Microsoft Excel Training     Microsoft Powerpoint Training     Microsoft Outlook Training     Microsoft Access Training     Microsoft Vista Training The instructor gave specific examples that helped me to apply the training to my industry and job. Laurie Wizeman – Patterson UTI Drilling Company

Microsoft Excel Intermediate Training Class

• Excel Training Class Goal:

  Expanding Excel skills past the basics. Learn how to take control of spreadsheets and customize formulas and formatting.

• Excel Course Outline:

  Writing formulas, "IF" statement formulas, conditional formatting, using functions, filling a series, filling by example, copying and pasting formulas, pasting into a range, working with multiple worksheets (organizing, copying, color coding, using 3-D references and formulas), hyperlinks, screen tips, formatting cells and appearance (text alignment, merge and center, text orientation, format painter), formatting numbers (percentage and custom number formats, borders), cell comments, freezing panes, grouping columns, showing formulas and references, adding page number footers, creating and editing charts (single and basic multiple series).

• Prerequisite for Excel Course:

  basic Excel skills including: navigation, basic formatting, entering data into a spreadsheet, using toolbars and menus.

Microsoft Excel Advanced Users Training Class

• Excel Training Class Goal:

  Geared for those that are already comfortable writing different types of formulas, formatting spreadsheets and text and working across multiple worksheets.

• Excel Course Outline:

  Access a list of all Excel functions, Text functions (IF Conditional, Nesting IF statements, Concatenate Functions, IF Concatenate text functions, IS functions), arrays, label formulas, Add ins, look up values, transposing data, PivotTables, PivotTable charts, multiple series charts, adding pictures to charts, moving average charts, validations, custom views, adding custom views to the toolbar, grouping columns, AutoFilters, custom lists, embedding, linking, linking as icon, locking cells, protecting worksheets and workbooks.

• Prerequisite for Excel Course:

  Understanding of Excel fundamentals including formatting, navigation, basic formulas, Autosum and other basic functions, basic charts.

Microsoft Excel Formulas & Functions Training Class

• Excel Training Class Goal:

  This class focuses on writing formulas and functions only. For those that use Excel regularly and want to explore different formulas and functions available to make spreadsheets even more powerful.

• Excel Course Outline:

  There are hundreds of different kinds of formulas and functions to use in Excel – this class will focus on some of the more cross functional ones that can be used across all types of business to improve spreadsheet performance and business productivity. Some of the formulas and functions covered include: date & time, mathematical, text, database, financial, informational, statistical, logic, lookup and reference functions and nesting IF statements.

• Prerequisite for Excel Course:

  Understanding of Excel fundamentals including, navigation, basic formulas and functions.

What is the Buzz around Microsoft Excel 2007?

Microsoft Office Excel 2007 features the more user friendly interface of the Office 2007 suite with faster access to the critical tools within the application. Not only does the latest version of Excel have a more cosmetically pleasing look, but it is also packed with additional functionality including enhanced Pivot Table usability, professional chart and graph building and of course what we have all been waiting for, an increased capacity of 1 million rows and 16,000 columns.