Get started in Excel with this fundamental Excel course. Get comfortable using Excel and learn to boost your productivity with formulas, charts, and formatting techniques.
Master the core Excel functions in this one-day course. Learn calculations and data entry. Apply formatting to text and cells to make your spreadsheet scannable and visually appealing. In this hands-on training, you will learn all the basics to use Microsoft Excel as your primary data processing tool. You'll produce polished and print-ready spreadsheets while learning tricks to accelerate your workflow.
Prerequisites:
Prior experience with Excel is not required; however, attendees must be comfortable with computer basics.
What You’ll Learn at a Glance
- AutoSum functions
- Calculations and data entry
- Absolute cell references
- Formatting and printing
- Multi-input functions
- Line, column, and pie charts
- Tables
Course Syllabus
- Introduction
- Interface
- Worksheets
- Data Entry
- Rows & Columns
- Formulas
- Autofill
- Calculations
- AutoSum Functions
- Absolute Reference
- True or False
- Text Functions
- Multi-Input Functions
- Formatting
- Formatting
- Cell Styles
- Conditional Formatting
- Charts & Tables
- Tables
- Column Chart
- Line Chart
- Pie Chart
- Workbook Management
- Freeze Panes
- Printing
- Windows
- Templates
- Excel Tricks
- End of Class Projects
Learn more about Excel for Business Fundamentals at NYIM Training.