Get started with Excel and develop foundational competency using this essential course. Build comfort and confidence using Excel, and learn to increase your productivity through formulas, visual charts, and professional formatting approaches.
Master key Excel features in this one-day intensive course. You will learn how to perform calculations and enter data accurately. You will apply formatting to text and cells to make your spreadsheets easy to scan and visually organized. In this practical, hands-on training, you will master the essential basics needed to use Microsoft Excel as your primary tool for data processing and analysis. You will create polished, publication-ready spreadsheets while learning professional shortcuts that accelerate your workflow and save time.
Prerequisites:
No prior Excel experience is necessary; however, you must be comfortable with basic computer operations and navigation.
What You Will Learn at a Glance:
- AutoSum and automatic calculations
- Calculations and data entry procedures
- Absolute cell references
- Formatting text and printing spreadsheets
- Multi-input functions and formulas
- Line, column, and pie charts
- Tables and data organization
Course Syllabus:
-
Introduction
- Interface and Ribbon Navigation
- Worksheets and Workbook Organization
- Data Entry Techniques
- Rows and Columns Management
-
Formulas
- Autofill Features
- Calculations and Math Operators
- AutoSum Functions
- Absolute Cell References
- Logical Formulas: True or False
- Text Functions
- Multi-Input Functions
-
Formatting
- Cell and Text Formatting
- Cell Styles
- Conditional Formatting
-
Charts and Tables
- Tables and Data Organization
- Column Charts
- Line Charts
- Pie Charts
-
Workbook Management
- Freeze Panes
- Printing and Page Setup
- Windows and Multiple Views
- Templates and Workbook Templates
- Excel Tricks and Shortcuts
-
End of Class Projects
Learn more about Excel for Business Fundamentals at NYIM Training.
This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.
Upon registration, the instructor will send along additional information about how to log-on and participate in the class.
Also available in-person in NYC
