We are offering a Microsoft Excel Expert Seminar. The class will teach you how to create Marco's, conditional formatting, securing your workbooks, expert functions, auditing worksheets, analyzing data, and importing, exporting data.

This course is perfect for someone who uses Microsoft Excel already, or took our Excel essentials course and wants to become an expert user.

Students will learn:
 

• How to macros to automate our spreadsheets.

• Using conditional formatting to formats specific cells in a range.

• Protecting workbooks and sheets. If you share your workbooks with others, protecting certain sheets or range will ensure the integrity of the sheets stays intact.

• How to use a combo IF and Vlookup to lookup values base on certain conditions and criteria.

• When you would use the ISBLANK or ISERROR functions. Ever had a function return error because a cell was blank? We will show how to stop this.

• Using SUMIF, AVERAGEIF, COUNTIF. These will allow us to sum, count and average base on certain criteria.

• Inputting financial functions.

• Tracing errors in functions using formula auditing. Excel has a great set of tools to help us troubleshoot errors in formulas.

• Working with scenarios. what are they, and how they help us save time.

• Inserting a treadline on a chart and having Excel forecast your next quarter or months finance.

• How to import and export data into excel. Also includes using web data. Have a web page you constantly monitor, to update excel? Have excel update itself when the web page changes.

Benefits to this course:

• Small class.

• 100% hands on training. Every student gets their own computer to follow along.

• Full day of training, or 2 evening. 8 hours of total training time.

• Convenient location in Midtown Manhattan. 2 blocks from Penn Station.

• Expert instructor with more than 10 years of financial experience using and teaching Excel.

• A free retake if needed

The class will be held in Midtown Manhattan. The seminar will include a customize manual with step by step directions and a certificate at the end, showing that you attended a class.

Seminar Cost: $139

**Summer Special**
Sign up for both classes the same day and get the Excel Expert class for $99.

Topics covered:

Lesson 1: Streamlining Workflow

Topic 1A: Create a Macro

Topic 1B: Apply Conditional Formatting

Topic 1C: Add Data Validation Criteria

Lesson 2: Collaborating with Others

Topic 2A: Protect Files

Topic 2B: Share a Workbook

Topic 2C: Set Revision Tracking

Topic 2D: Review Tracked Revisions

Topic 2E: Merge Workbooks

Lesson 3: Expert Functions
            Topic 3A: Financial Functions
            Topic 3B: Date and time functions
            Topic 3C: Nested Logical Functions
            Topic 3D: Working with Math Functions

Lesson 4: Auditing Worksheets

Topic 4A: Trace Cells

Topic 4B: Troubleshoot Errors in Formulas

Topic 4C: Troubleshoot Invalid Data and Formulas

Topic 4D: Watch and Evaluate Formulas

Lesson 5: Analyzing Data

Topic 5A: Create a Trendline

Topic 5B: Create Scenarios

Lesson 6: Working with Multiple Workbooks

Topic 6A: Create a Workspace

Topic 6B: Consolidate Data

Topic 6C: Link Cells in Different Workbooks

Topic 6D: Edit Links

Lesson 7: Importing and Exporting Data

Topic 7A: Export Excel Data

Topic 7B: Import a Delimited Text File