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.
Course Outline
Introduction
- Overview of the application
- Structure of the main interface
- Managing workbooks and worksheets
Entering and Editing Cell Data
Data Formatting
- Configuring display formats for various data types and calculation outputs (e.g., dates, currency, percentages, fractions)
- Setting cell borders and fill colors
- Formatting row and column headers
- Applying Styles
Navigating the Workbook
- Efficient movement within large spreadsheets
- Simultaneous work across multiple worksheets or workbooks
Copying and Moving Data
- Selecting cell ranges
- Moving data between locations
- Special paste operations
- Using Autofill for data series (e.g., sequential numbers, consecutive business dates)
Formulas, Addresses, and Cell Names
- Creating, editing, and copying formulas
- Managing circular references
- Applying Conditional formatting
- Understanding address types and their usage
- Referencing other worksheets and workbooks
- Utilizing named cells
Functions
- General guidelines for using functions
- Commonly used functions
- Nesting functions within one another
- Using conditional logic (IF statements)
- The Function Wizard
Visual Elements in Spreadsheets
- AutoShapes and WordArt
- Static and dynamic graphic representations
Charts
- Primary chart types and their appropriate use cases
- Key principles for creating effective charts
- Steps to generate charts
- Modifying graph components
- Designing custom chart types
Hiding and Protecting Data
- Hiding sheets, columns, and rows
- Masking formulas and cell contents
- Preventing unauthorized modifications to worksheets and workbooks
- Password-protecting workbooks upon opening
Printing
- Printing specific sheets or non-contiguous ranges
- Printing charts
Requirements
Familiarity with Windows
14 Hours
Testimonials (1)
well-prepared training, interesting topics
