Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Duration 7 hours
Course Outline
1 - INTRODUCING EXCEL 2019
- Topic A: Exploring the Excel User Interface
- Topic B: Executing Excel Commands
- Topic C: Creating and Saving a Basic Workbook
- Topic D: Inputting Cell Data
- Topic E: Utilizing Excel Help Resources
2 - EXECUTING CALCULATIONS
- Topic A: Constructing Worksheet Formulas
- Topic B: Incorporating Functions
- Topic C: Reusing Formulas and Functions
3 - ADJUSTING A WORKSHEET
- Topic A: Inserting, Removing, and Resizing Cells, Columns, and Rows
- Topic B: Searching for and Replacing Data
- Topic C: Applying Proofing and Research Utilities
4 - STYLING A WORKSHEET
- Topic A: Applying Text Formatting
- Topic B: Applying Number Formatting
- Topic C: Aligning Cell Contents
- Topic D: Applying Styles and Themes
- Topic E: Applying Basic Conditional Formatting
- Topic F: Creating and Utilizing Templates
5 - PRINTING WORKBOOKS
- Topic A: Previewing and Printing a Workbook
- Topic B: Configuring the Page Layout
- Topic C: Setting Headers and Footers
6 - OVERSEEING WORKBOOKS
- Topic A: Managing Worksheets
- Topic B: Managing Workbook and Worksheet Views
- Topic C: Managing Workbook Properties
Testimonials (1)
I really appreciated that the excel spreadsheet with each module was shared with us to follow along and reference again for the formulas, etc. Lots of tips & tricks!
