Suitable for beginners at all levels, this comprehensive class will teach you how to create, modify, format, and print worksheets with confidence. You will learn fundamental formulas, essential functions, data manipulation, charting, and many additional practical skills for spreadsheet mastery.
- You will be learning Microsoft Excel from a knowledgeable live instructor in real-time
- The instructor will teach you step-by-step how to master Excel through detailed demonstrations, hands-on exercises, and individual one-on-one help
- Suitable for users with Excel 2016, 2019, or Microsoft 365 versions
Course Outline
Excel Essentials
- Starting Excel and launching the application
- Understanding the Excel interface and workspace
- Opening an existing workbook
- Navigating effectively around a Workbook
- Finding and locating data
- Entering data correctly
- Saving and closing a workbook properly
Creating Worksheets
- Understanding types of data
- Entering text content
- Adjusting column width appropriately
- Entering numbers accurately
- Understanding types of formulas
- Entering formulas correctly
- Learning about functions and their uses
- Inserting functions into your spreadsheet
- Copying and moving data within sheets
- Copying formulas to other cells
- Understanding absolute and relative references
Formatting
- Text formatting options and techniques
- Number formatting for clarity
- Alignment and cell positioning
- Text wrapping for readability
- Merging cell data
- Borders and highlighting
- Styles and themes for professional appearance
Manipulating Data
- Data entry shortcuts to increase efficiency
- Fill and auto-fill functions
- Replacing data systematically
- Paste options and flexibility
- Inserting and deleting rows and columns
- Hiding rows and columns
Charts
- Create simple charts from your data
- Changing a chart's type as needed
- Adding elements to charts
Output
- Managing worksheet windows effectively
- Freezing panes for scrolling
- Printing worksheets professionally
- Print setup options and preferences
- Print areas and titles
- Headers and footers
- Sharing workbooks with colleagues
Settings and Templates
- Workbooks options and properties
- Working with templates
Our course outlines serve as a guide to the content typically covered in a standard class. We may change or alter the course topics as needed to meet the specific objectives and needs of a particular class.
