Looking for corporate training?
We offer custom onsite training and discounted class vouchers.
nyc@careercenters.com212 • 684 • 5151
Download Syllabus
Beginner Microsoft Excel
Master Calculations, Formulas, & Functions
- $219
- 7 Hours
-
Mac or PC provided
We provide computers to use during class. Choose a Mac or a PC during the checkout process.
- Small in-person class
-
Free retake
Students may retake the course once within six months if there is an available seat.
- 185 Madison Avenue, NYC
Get the hang of Excel formulas, functions, charts, and workbook formatting. This beginner course is the perfect introduction to Excel for self-taught users and complete beginners alike. Develop a command of time-saving Excel shortcuts and hotkeys.
Practical Real-World Training
Our Excel course includes practical exercises that walk you through the basics. Learn the concept, watch an example, complete an activity with the new concept on your own. At the end of the course, you’ll keep your training guide for reference whenever you use Excel.
Comprehensive Excel Video Suite
Students in our Beginner Excel course, receive access to our companion video suite, featuring beginner level video lessons available for viewing on desktop, mobile, and tablet. These video tutorials explain popular Excel concepts in simple steps.
Free Retake
Need a refresher? No problem! After you’ve signed up for the course, you can retake within 6 months of your original enrollment free of charge (and so long as there is an available seat in the class).
Get 15% off by Enrolling in Bootcamp
Is your goal to become an advanced Excel user? Save money and sign up for our three-day Excel Bootcamp and save 15% on your enrollment fees.
Prerequisites
None; basic computer skills
Video Training Included
This course includes lifetime access to self-paced training videos, a $95 value.
212 • 684 • 5151
Download Syllabus
Course Overview
- Get started with Microsoft Office Excel 2016
- Perform Calculations
- Modify Text
- Format a Worksheet
- Create Charts and Tables
- Manage Workbooks
Full Course Syllabus
Download PDF OutlineIntroduction
Interface
- Provides a brief description of the user interface for Microsoft Excel
Data Entry
- Examines and describes multiple means of entering data
Formulas
Autofill
- Explores Excel's amazing ability to predict and extrapolate patterns
Calculations
- Perform mathematical expressions and review the Order of Operations rule
True or False
- Tests to see whether criteria is true/false
AutoSum Functions
- Review the five key functions: Sum, Average, Max, Min, and Count Numbers
Text Functions
- Introduces functions used to modify text in Excel
Multi-Input Functions
- More advanced functions that require more than one input
Absolute Cell References
- Changing a cell reference into a constant, which is necessary for certain calculations
Formatting
Formatting
- The addition of effects to an excel document to provide visual instruction
Format Painter
- The ability to copy format from one cell/range of cells to another cell/range of cells
Conditional Format
- Apply a predetermined format based on specified rules
Charts & Tables
Line Chart
- Create a Line chart and Spark lines to visually examine data
Column Chart
- Create a Column chart to visually examine data
Pie Chart
- Create a Pie chart to visually examine data
Tables
- Explore the special functionality created when data is converted to a Table
Workbook Management
Printing
- Rules and strategies to make printing easy
Worksheets
- Insert, move, copy and delete worksheets
Repeat Action
- Use the F4 key to duplicate a prior action
Shortcuts
- 5 Fundamental keyboard shortcuts and a review of others previously covered
End of Class Project
Project
- End of class project to review key concepts from the class
Save and Close
- Save, close and email the completed workbook