Excel for Business Level I - Fundamentals

Excel for Business Level I - Fundamentals 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 resumé and boosting your job performance. The course comes with a revolutionary video tutorial suite, and is taught by engaging instructors with several years of in-field and training experience. 

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 - Review the multiple means of entering data

Formulas
4) Autofill - Explore Excel's amazing ability to predict and extrapolate patterns
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
7) Text Functions - Introduces functions used to modify text
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) 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%MCEPASTEBIN%Formulas4)AutofillExplore Excel's amazing ability to predict and extrapolate patterns5)CalculationsPerform mathematical expressions and review the Order of Operations rule6)AutoSum FunctionsReview the five key functions: Sum, Average, Max, Min, and Count7)Text FunctionsIntroduces functions used to modify text8)Multi-Input FunctionsMore advanced functions that require more than one input9)Absolute Cell ReferencesChanging a cell reference into a constant, which is necessary in certain calculationsFormatting10)FormattingThe addition of effects to an Excel document to provide visual instruction11)Format PainterUse the Format Painer to copy format a from one cell to another12)Conditional FormatApply formats to cells based on specified rules or criteriaCharts & Tables13)Line ChartCreate a Line chart and Spark lines to visually examine data14)Column ChartCreate a Column chart to visually examine data15)Pie ChartCreate a Pie chart to visually examine data16)TablesExplores the special functionality created when data is converted to a TableWorkbook Management17)PrintingRules and strategies to make printing easy18)WorksheetsInsert, move, copy and delete worksheets19)Rows & ColumnsInsert, hide, group and freeze rows and columns20)Save and CloseSave, close and email your finished productEnd of Class Project21)ProjectEnd of class project to review key concepts from the class