No New Notifications

Advanced Excel for Business

NYIM Training

Select Option

Highlights

Advanced Excel for Business


Advanced Excel for Business covers the advanced applications of Excel used frequently by business professionals. This course is perfect for those with strong working knowledge and practice in Excel looking to apply more complex Excel features. In this advanced course, you will learn Goal Seek, Data Tables, advanced functions, and basic macros. You will build upon intermediate-level concepts, making your lookup functions more flexible, taking Pivot Tables to the next level, and facilitating workflow with cell management techniques and Hot Keys. In this hands-on course you will work on real-world examples, reinforcing the concepts with practice throughout the class, as well as a cumulative project at the end. Each attendee will receive access to our revolutionary Excel Fundamentals video suite, with lifetime access to several hours of premium content.

Additional instructions on how to set up Mac will be sent upon registration.

Syllabus:

Cell Management 1) Advanced Cell Locking Create powerful formulas by locking either the column or the row 2) Hot Keys Transform the ribbon into a visual listing of pre-assigned shortcuts 3) Windows Techniques and keyboard shortcuts to allow editing of active windows 4) Cell Auditing Observe the relationship between formulas and cells Special Formatting 5) Date functions Calculate dates with a variety of functions 6) Conditional Formatting-Formulas Create custom rules for Conditional Formatting with formulas Advanced Functions 7) Nested If statements Nested "IF" statements allow for more than just two possibilities in a single cell 8) If statements with And/Or Expand the functionality of the IF function by adding an "AND" or an "OR" criteria into the logical test What If Analysis 9) Goal Seek Find the desired result by adjusting an input value 10) Data Tables Data Tables show the range of effects of one or two different variables on a formula Advanced Analytical Tools 11) Data Consolidation Summarize data from separate ranges and consolidate into a specified output range 12) Conditional SumProduct Use SumProduct with conditions to exclude data that does not meet certain criteria 13) Pivot Table-Calculations Create calculated rows or columns in a Pivot Table that go beyond the source data 14) Pivot Charts Pivot Charts are dynamic, graphical representations of Pivot Table data that work in tandem with Pivot Tables Advanced Database Functions 15) MATCH function Return the relative position (column or row number) of a lookup value 16) VLOOKUP-MATCH Create a more accurate VLookUp by enhancing the determination of the Column Index number 17) INDEX-MATCH Efficiently returns a value or reference from a cell at the intersecton of the row and column 18) INDEX-Double MATCH Use a second Match function to create a powerful, two-way lookup tool Introduction to Macros 19) Recording Macros Record Macros that involve formatting and calculations 20) Relative Macros Record relative reference macros for ad hoc reporting End of Class Project 21) Project End of class project to review key concepts from the class

The class identified is made available through CourseHorse, a 3rd party marketplace for Excel classes and more. Groupon is not affiliated with or sponsored by the merchant, NYIM Training, in connection with this offer. Please contact Groupon customer service for all inquiries related to this offer. Inquiries placed to CourseHorse will be directed back to Groupon.

What You'll Get

Advanced Excel for Business


Advanced Excel for Business covers the advanced applications of Excel used frequently by business professionals. This course is perfect for those with strong working knowledge and practice in Excel looking to apply more complex Excel features. In this advanced course, you will learn Goal Seek, Data Tables, advanced functions, and basic macros. You will build upon intermediate-level concepts, making your lookup functions more flexible, taking Pivot Tables to the next level, and facilitating workflow with cell management techniques and Hot Keys. In this hands-on course you will work on real-world examples, reinforcing the concepts with practice throughout the class, as well as a cumulative project at the end. Each attendee will receive access to our revolutionary Excel Fundamentals video suite, with lifetime access to several hours of premium content.

Additional instructions on how to set up Mac will be sent upon registration.

Syllabus:

Cell Management 1) Advanced Cell Locking Create powerful formulas by locking either the column or the row 2) Hot Keys Transform the ribbon into a visual listing of pre-assigned shortcuts 3) Windows Techniques and keyboard shortcuts to allow editing of active windows 4) Cell Auditing Observe the relationship between formulas and cells Special Formatting 5) Date functions Calculate dates with a variety of functions 6) Conditional Formatting-Formulas Create custom rules for Conditional Formatting with formulas Advanced Functions 7) Nested If statements Nested "IF" statements allow for more than just two possibilities in a single cell 8) If statements with And/Or Expand the functionality of the IF function by adding an "AND" or an "OR" criteria into the logical test What If Analysis 9) Goal Seek Find the desired result by adjusting an input value 10) Data Tables Data Tables show the range of effects of one or two different variables on a formula Advanced Analytical Tools 11) Data Consolidation Summarize data from separate ranges and consolidate into a specified output range 12) Conditional SumProduct Use SumProduct with conditions to exclude data that does not meet certain criteria 13) Pivot Table-Calculations Create calculated rows or columns in a Pivot Table that go beyond the source data 14) Pivot Charts Pivot Charts are dynamic, graphical representations of Pivot Table data that work in tandem with Pivot Tables Advanced Database Functions 15) MATCH function Return the relative position (column or row number) of a lookup value 16) VLOOKUP-MATCH Create a more accurate VLookUp by enhancing the determination of the Column Index number 17) INDEX-MATCH Efficiently returns a value or reference from a cell at the intersecton of the row and column 18) INDEX-Double MATCH Use a second Match function to create a powerful, two-way lookup tool Introduction to Macros 19) Recording Macros Record Macros that involve formatting and calculations 20) Relative Macros Record relative reference macros for ad hoc reporting End of Class Project 21) Project End of class project to review key concepts from the class

The class identified is made available through CourseHorse, a 3rd party marketplace for Excel classes and more. Groupon is not affiliated with or sponsored by the merchant, NYIM Training, in connection with this offer. Please contact Groupon customer service for all inquiries related to this offer. Inquiries placed to CourseHorse will be directed back to Groupon.

The Fine Print

Expiration varies.

  • ALL SALES FINAL.
  • Must be 18 or older to attend
  • Voucher valid only for date and time listed; may not be exchanged, altered, or redeemed for other dates, but may send a friend in place.
  • Must present CourseHorse confirmation email upon arrival.
  • Purchaser name must be provided at checkout; this information will be shared with CourseHorse and course provider for purposes of order fulfillment.
  • Groupon voucher Terms of Sale and Extraordinary Event Policy do not apply.
  • Merchant is solely responsible to purchasers for the care and quality of the advertised goods and services.
  • Offer is not eligible for our promo codes or other discounts.
  • Note, additional equipment or materials may be required or included in purchase price, see course description for details.
  • Merchant is solely responsible to purchasers for the care and quality of the advertised goods and services. Offer is not eligible for our promo codes or other discounts.

NYIM Training

Class, Academic Course