No New Notifications

Excel for Business Fundamentals

Select Option

Highlights

Excel for Business Fundamentals - Beginner Excel Classroom Training in NYC

Excel for Business Fundamentals covers the essential applications of Excel used frequently by business professionals. In this introductory course, you will learn basic and multi-input functions, absolute references, charts and tables. We will help you produce polished and presentable work with formatting and printing techniques, while learning crucial tricks to facilitate the workflow. 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:


Introduction 1) Interface Provides a brief description of the user interface for Microsoft Excel 2) Data Entry Examines and describes multiple means of entering data Formulas 3) Autofill Explores Excel's amazing ability to predict and extrapolate patterns 4) Calculations Perform mathematical expressions and review the Order of Operations rule 5) True or False Tests to see whether criteria is true/false 6) AutoSum Functions Review the five key functions: Sum, Average, Max, Min, and Count Numbers 7) Text Functions Introduces functions used to modify text in Excel 8) Multi-Input Functions More advanced functions that require more than one input 9) Absolute Cell References Changing a cell reference into a constant, which is necessary in certain calculations Formatting 10) Formatting The addition of effects to an excel document to provide visual instruction 11) Format Painter The ability to copy format from one cell/range of cells to another cell/range of cells 12) Conditional Format Apply a predetermined format based on specified rules Charts & Tables 13) Line Chart Create a Line chart and Spark lines to visually examine data 14) Column Chart Create a Column chart to visually examine data 15) Pie Chart Create a Pie chart to visually examine data 16) Tables Explores the special functionality created when data is converted to a Table Workbook Management 17) Printing Rules and strategies to make printing easy 18) Worksheets Insert, move, copy and delete worksheets 19) Repeat Action Use the F4 key to duplicate a prior action 20) Shortcuts 5 Fundamental keyboard shortcuts and a review of others previously covered End of Class Project 21) Project End of class project to review key concepts from the class 22) Save and Close

Save, close and email the completed workbook


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.

Customer Reviews

This deal doesn't have any written reviews yet.

What You'll Get

Excel for Business Fundamentals - Beginner Excel Classroom Training in NYC

Excel for Business Fundamentals covers the essential applications of Excel used frequently by business professionals. In this introductory course, you will learn basic and multi-input functions, absolute references, charts and tables. We will help you produce polished and presentable work with formatting and printing techniques, while learning crucial tricks to facilitate the workflow. 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:


Introduction 1) Interface Provides a brief description of the user interface for Microsoft Excel 2) Data Entry Examines and describes multiple means of entering data Formulas 3) Autofill Explores Excel's amazing ability to predict and extrapolate patterns 4) Calculations Perform mathematical expressions and review the Order of Operations rule 5) True or False Tests to see whether criteria is true/false 6) AutoSum Functions Review the five key functions: Sum, Average, Max, Min, and Count Numbers 7) Text Functions Introduces functions used to modify text in Excel 8) Multi-Input Functions More advanced functions that require more than one input 9) Absolute Cell References Changing a cell reference into a constant, which is necessary in certain calculations Formatting 10) Formatting The addition of effects to an excel document to provide visual instruction 11) Format Painter The ability to copy format from one cell/range of cells to another cell/range of cells 12) Conditional Format Apply a predetermined format based on specified rules Charts & Tables 13) Line Chart Create a Line chart and Spark lines to visually examine data 14) Column Chart Create a Column chart to visually examine data 15) Pie Chart Create a Pie chart to visually examine data 16) Tables Explores the special functionality created when data is converted to a Table Workbook Management 17) Printing Rules and strategies to make printing easy 18) Worksheets Insert, move, copy and delete worksheets 19) Repeat Action Use the F4 key to duplicate a prior action 20) Shortcuts 5 Fundamental keyboard shortcuts and a review of others previously covered End of Class Project 21) Project End of class project to review key concepts from the class 22) Save and Close

Save, close and email the completed workbook


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