You are not logged in
This Month Specials

1 Union Square West, Suite 805, NY, NY 212.658.1918

Excel for Business Level I is the first of a three part series that aims to tackle the most common and practical uses of Excel in business. This is the perfect course for those who are either new to Excel or would like to improve their understanding and efficiency of its applications in business. By the end of this course, you will feel confident navigating through Excel worksheets and working with formulas, databases, charts, formatting, shortcuts and printing. The skills you take away from this course will prove crucial to building a strong resume and boosting your job performance - you will truly be amazed at how much you will benefit from this course!

# Class Perks

The most practical and hands-on training to boost productivity and skill

State-of-the-art curriculums refined by industry experts over nearly two decades

Interactive, personable, and engaging instructors with several years of in-field and training experience

Revolutionary video course with several hours of premium content

Small classroom sizes for personalized attention

Custom in-depth manuals and mousepads with key shortcuts

Convenient location and comfortable learning environment

# Materials

• Custom Manual
• Multiple XLS and XLT examples for in class and after class
• Shortcut sheets
• After class resources

# Course Outline

 Introduction 1) Introduction What is Excel and what can it be used for? 2) Interface Provides a brief description of the user interface for Microsoft Excel 3) Data Entry Examines and describes multiple means of entering data Formulas 4) Autofill Explores Excel's amazing ability to predict and extrapolate paterns 5) Calculations Perform mathematical expressions and review the Order of Operations rule 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 Create rules that govern specific cell ranges and apply a predetermined format when those rules are triggered 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) Rows & Columns Insert, hide, group and freeze rows and columns 20) Save and Close Save, close and email your finished product End of Class Project 21) Project End of class project to review key concepts from the class