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.
