+Creating Workbooks, Worksheets, and Data in Excel 2013
+Saving and Printing Data in Excel 2013
+Formatting Cells and Worksheets in Excel 2013
+Formatting Data in Excel 2013
+Presenting Data using Conditional Formatting and Sparklines in Excel 2013
+Performing Calculations Using Functions in Excel 2013
+Presenting Data in Tables and Charts in Excel 2013
Coding VBA (Visual Basic for Applications) macros is an essential skill for creating MS Excel spreadsheet applications and automating repetitive data management processes. With our MS Excel VBA class, you learn to design feature-rich applications that control Excel's built-in components. Make your Excel applications more usable for novices and automate tedious tasks to improve the productivity of your entire team.
Pivot Tables in MS Excel enable you to manipulate data with simple dragging and dropping. Take our class to learn the basics of Excel Pivot Tables and how they can help you to efficiently sort, filter, group, count, summate, and format data.
MS Excel has an array of analytic capabilities. Take your mastery of Microsoft Excel to a power user level with our Excel Expert Techniques class. Learn how to use the application's most powerful features and sophisticated data analysis techniques to develop and implement solutions for your business. Topics include advanced statistical formulas, PivotTable analysis, dashboards, and VBA macros.
Learn how to take full advantage of MS Excel's power with our advanced class. Do more powerful calculations with advanced functions. Save time with automated routines. Record and run a macro to perform automatic tasks.
This hands-on class MS Excel class will prepare you to link workbooks to manage larger data sets, work with table data and name ranges, create custom filters, and use PivotTables to explore different relationships among data.
Learn to create an MS Excel spreadsheet, track data, perform calculations, and optimize for printing. This class emphasizes practical exercises and real-world examples, so that you will leave training ready to apply your new knowledge right away.
This workshop will end your Excel frustrations for
good by providing the "how-to" for breezing through
spreadsheets, forecasts, graphs and financial
reporting, plus little-known shortcuts and time-saving
Learn ways to make your job easier and increase the
sophistication of your data reporting and analyzing.
Each session focuses on saving-you-time techniques,
advanced "how-to" exploring those
previously programmer only features and more.
We specialize in Microsoft Excel training for all skill
levels (basic, advanced financial modeling, and VBA
macro programming). We train anywhere in the
continental USA. Call 646-325-9094 or email
firstname.lastname@example.org for a quote.
An innovative approach to learning Excel for those who
need a basic working knowledge. Especially geared
for right-brain thinkers...those who learn best by
starting with examples, rather than an array of
commands & functions. Enhances engagement/retention.
Learn to how analyze data, identify patterns, solve problems, make decisions, detect abuses of statistics, and get your point across using basic quantitative tools. Emphasis is on real-world data and applications ... this Is NOT a statistics 101 refresher course.