Microsoft Excel is a powerful tool used to enter and track data for analysis.
Save, close and email the completed workbookīeginner Excel Classes New York City Learn best practices in data management-Enter, Analyze, and Create Charts.
End of class project to review key concepts from the class.
5 Fundamental keyboard shortcuts and a review of others previously covered.
Use the F4 key to duplicate a prior action.
Insert, move, copy and delete worksheets.
Rules and strategies to make printing easy.
Explore the special functionality created when data is converted to a Table.
Create a Pie chart to visually examine data.
Create a Column chart to visually examine data.
Create a Line chart and Spark lines to visually examine data.
Apply a predetermined format based on specified rules.
The ability to copy format from one cell/range of cells to another cell/range of cells.
The addition of effects to an excel document to provide visual instruction.
Changing a cell reference into a constant, which is necessary for certain calculations.
More advanced functions that require more than one input.
Introduces functions used to modify text in Excel.
Review the five key functions: Sum, Average, Max, Min, and Count Numbers.
Tests to see whether criteria is true/false.
Perform mathematical expressions and review the Order of Operations rule.
Explores Excel's amazing ability to predict and extrapolate patterns.
Examines and describes multiple means of entering data.
Provides a brief description of the user interface for Microsoft Excel.