Suitable for beginners this class will teach you how to create, modify, format and print worksheets. You will learn basic formulas, functions, data manipulation, charting and more.
- You will be learning Microsoft Excel from a live instructor.
- They will teach you step-by-step how to master Excel, using demonstrations, hands-on exercises and one-on-one help.
- Suitable for Excel 2016, 2019 & 365 users.
Excel Essentials
- Starting Excel
- The Excel Interface
- Opening a Workbook
- Navigating around a Workbook
- Finding Data
- Entering Data
- Saving and Closing a Workbook
- Types of Data
- Entering Text
- Adjusting Column Width
- Entering Numbers
- Types of Formulas
- Entering Formulas
- About Functions
- Inserting Functions
- Copying and Moving Data
- Copying Formulas
- Absolute and Relative References
- Text Formatting
- Number Formatting
- Alignment
- Text Wrapping
- Merging Cell Data
- Borders and Highlighting
- Styles and Themes
- Data Entry Shortcuts
- Fill and Auto Fill
- Replacing Data
- Paste Options
- Inserting and Deleting Rows and Columns
- Hiding Rows and Columns
- Create Simple Charts
- Changing a Chart's Type
- Adding Elements to Charts
- Managing Worksheet Windows
- Freezing Panes
- Printing Worksheets
- Print Setup Options
- Print Areas and Titles
- Headers and Footers
- Sharing Workbooks
- Workbooks Options and Properties
- Working with Templates
Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.