Excel for Business Fundamentals

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

You can save 15% when you combine this class with 2 Advanced Excel Classes!