Excel Training St. Louis
Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft. It is generally considered the most widely used spreadsheeting tool in the world and our Excel Training courses help students from Excel novices to Advanced Excel users. With Excel training and our Excel training courses you will learn many skills including calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. Our Excel Training courses focus on making sure you learn not only the software but the real-world applications of that software as well. Our Microsoft Excel Training courses use Microsoft Official Curriculum (MOC) and are taught by Microsoft Master instructors.
We think it's important to learn how to properly use application software like Microsoft Excel so that your users are empowered. Many work hours are lost through inefficient use of Excel. A lack of Excel Training and users without Excel Certification equates to inefficiency. Often times an employee fails to take advantage of features of Microsoft Excel simply because they do not know such features exist. We offer Excel Training courses for a variety of version of the software and at different skill levels to accommodate all of your employees.
We offer Excel 2007 training, Excel 2010 training, and Excel 2013 training
Outlines: 2013 - 2010 - 2007
This introduction Excel Training course is designed for students who desire to gain the necessary skills to create, edit, format, and print basic Microsoft Office Excel worksheets. This excel training course is best suited to students with a limited exposure to Excel or those who have never worked Excel before. If you already know how to create simple formulas and functions and perform basic formatting you might be too advanced for this Excel Training course.
After finishing this Excel training course, students will be able to create a basic worksheet, perform calculations in an Excel worksheet including simple functions like SUM, AVG, MIN, MAX, and COUNT, modify an Excel worksheet, modify the appearance of data within a worksheet through formatting of font, paragraph, cells, numbers, manage Excel workbooks by renaming them, giving them sheet colors, moving, and copying them, and finally learning various print techniques including margins, headers and footers, page titles, and print areas.
Outlines: 2013 - 2010 - 2007
This intermediate Excel Training course is designed for those desiring to gain the intermediate skill sets necessary for calculating data using functions and formulas, sorting and filtering data, using PivotTables and PivotCharts for analyzing data, and customizing workbooks.
Upon successful completion of this Excel training course, students will be able to use advanced formulas including IF, VLOOKUP, RIGHT, CONCATENATE, SUMIF, DSUM, and others, organize worksheet and table data with the Format as Table feature which includes the Total Row, Remove Duplicates, and banded rows and columns, create many kinds of charts including Column Charts, Pie Charts, Line Charts, and learn how to manipulate those charts with titles, legends, gridlines, and Chart Layouts, and Chart Styles, analyze data using PivotTables using rows, columns, report filters, and values, work with Slicers, and PivotCharts, insert pictures, clipart, and SmartArt into worksheets, manipulate graphics for size, position, alignment, color, and cropping, and customize and enhance workbooks with cell comments, sheet backgrounds, hyperlinks, and create and use templates.
Outlines: 2013 - 2010 - 2007
This high-level Excel Training course is designed for students who need to work with the Microsoft Excel software on a more complex level. This Excel training course teaches students how to create macros, use collaborative tools, use the audit and analyze worksheet data tools, and import and export data.
In this Excel training course,students will learn how to create macros and run them, use collaborative tools for security, sharing, tracking changes, merge workbooks, use the audit and analyze worksheet data tools to trace cell contents, watch each step of a formula, trace errors, use data validation, create scenarios, use Goal Seek and Solver, create subtotals, and import and export data using a variety of formats.
This Excel Training course is designed for advanced Microsoft Office Excel professionals who may work or be interested in the domain of finance, statistics, project analysis, and market analysis including the fields of micro- and macro-economics.
After finishing this Excel training course, students will be able to manipulate data using statistical and lookup functions, analyze data using the data analysis tools, make investment decisions using the financial functions, examine data using math functions, manipulate data using text and information functions, create templates and work with Excel's advanced chart options, and manage data in Excel workbooks.
This Excel Training course is intended for advanced professionals that need to automate spreadsheet tasks using Visual Basic for Applications (VBA). These tools are invaluable in extending Excel into real-world business environments. This Excel training course largely involves coding using VBA and is not a traditional Excel training course. Students taking this Excel training course should be prepared to type and troubleshoot VBA code and then see the results in an Excel spreadsheet.
At the conclusion of this Excel training course, students will be able to develop a macro, format worksheets using macros, create an interactive worksheet, work with multiple worksheets, and perform calculations.
Call us today and we'll help setup a class for you!
For more information -
Please contact us 314.333.3330
1750 South Brentwood Blvd.
Saint Louis, MO 63144