Intermediate Microsoft Excel Training for Business Professionals Workshop Outline

Our "data processing and formulas" Microsoft Excel workshop that shows you how to build power formulas using VLOOKUP, IF, SUMIF..etc, build pivot tables, process text files, process and analyze worksheet data, link to Word and PowerPoint and more. Read below and see how our 14 years of Excel training and consulting can help supercharge your Excel skills >>>

Call us at:   1.805.498.7162     1.805.558.9277--

• Onsite, Self-Study, Public, Webinar

Our "hands-on" intermediate Excel training focuses on useful formula design for data processing and modeling, using Excel's built-in range features like Data Validation, useful worksheet functions like VLookup and applying Excel's built-in data processing tools and worksheet functions to analyze and clean text files and worksheet tables. We teach you how to develop analysis and data processing problems on the worksheet then how to determine the proper Excel tools to create a unique solution. In all of our workshops, we evaluate our clienteles' knowledge level, their problems and adjust our curriculum to their specific needs.

• Intermediate Microsoft Excel skills for constructing business charts and formatting them

• How to use logical, reference, lookup and information Microsoft Excel worksheet functions to build "smart" business worksheets including VLookup, SumProduct, Index, Match, CountIf, SumIf, If, And, Or, Round, IS functions and Indirect

• How to construct array formulas and summary worksheets

• How to construct dynamic ranges in formulas that adjust to table size

• How to use the text Microsoft Excel worksheet functions to parse text in cells including Right, Mid, Left, Substitute and Replace

• Intermediate Excel skills for returning arrays from Microsoft Excel worksheet functions

• How to use Text Wizard and Text to Columns to parse text into the worksheet

• Intermediate Microsoft Excel skills for using the data validation and conditional formatting worksheet features

• How to use Microsoft Excel's built-in analysis tools (sort, Advanced Filter, AutoFilter) for analyzing worksheet data using

• Intermediate Excel skills for drawing and importing pictures on the worksheet

• How to create simple worksheet based business forms and questionnaires

• How to create and use basic Microsoft Excel pivot tables

• How to link Microsoft Excel to Word and PowerPoint for report generation

* If you are looking for advanced formula design and dashboards, try our Advanced Microsoft Excel workshop

• 1-day workshop

• Personal examples: Covered in-class

• Excel Versions: 2000-2010

• Type: Business Professionals

• Platform: Windows or Mac

• Training Materials: Included, 1800+ page manual

• Training Method: Hands-on

In this 1-day "hands-on" workshop you will learn:

• Basic formula and cell name review

• Conditional Formatting / Data Validation: How to use the conditional formatting and data validation Microsoft Excel worksheet features

• Smart Worksheets: How to construct "smart" Microsoft Excel worksheets using Excel's logic, information, lookup and reference worksheet functions including VLookup, Match, SumProduct, CountIF, SumIf, Index, If, And and Or

• Text Functions: How to use the text Microsoft Excel worksheet functions including Right, Mid, Left, Substitute and Replace

• Nesting Worksheet Functions: How to nest Microsoft Excel worksheet functions to create smart worksheets

• Concatenation: How to perform concatenation in Microsoft Excel worksheet formulas

• Databases / Lists: How to create and manage databases in Microsoft Excel

• Sort / AutoFilter / Advanced Filter Tools: How to use Microsoft Excel's database management tools like the sort, form, AutoFilter and Advanced Filter tools

• Text Wizard and Text to Columns: How to use with text files and Microsoft Word

• Using Ranges: How to use ranges in Microsoft Excel worksheet functions

• Array Formulas: How to use array formulas to build summary sheets and dashboards

• Dynamic ranges: Learn how to build ranges in formulas that adjust to table size

• Drawing / Pictures / Flow Charts: How to use Microsoft Excel's drawing tools to create graphics on the worksheet including business flow charts

• Business Report Generation: How to use Microsoft Excel as a daily or weekly business report generator

• Forms / Questionnaires: How to construct business forms and questionnaires in Microsoft Excel

• Pivot Tables: How to create and use basic Microsoft Excel pivot tables

• Link Excel to Word and PowerPoint: Learn the basics of linking Microsoft Excel to Word and PowerPoint for report generation

Click here for Schedule, Pricing, Enrollment

• Microsoft Excel users that understand basic worksheet skills (typed in a cell, used a formula before, opened a workbook...etc).

• It is intended for all types of professionals.

Public Location: Thousand Oaks,CA, Directions/Thousand Oaks Info

Hotel: Thousand Oaks Inn

EMAGENIT is based in Thousand Oaks, CA which is in the vicinity of Los Angeles county (LA County), Ventura county, Santa Barbara county and San Diego county. We hold all of our courses on-site nation wide. We also webcast (webinar) our public workshops, consult our webcast page for more information.

Our public workshops are a short commute for those living in:

For more information about our public workshops, visit our public workshops page our call us at 805.498.7162.

Submit a question to us via email at intexcel@emagenit.com

Call EMAGENIT between the hours of 8:00 A.M. and 5 P.M. PST at 1.805.498.7162 or 805.558.9277 for more information about this workshop.