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 key program features
- Understanding the layout of the main interface
- Managing workbooks and individual sheets
Data Entry and Modification in Cells
Data Formatting
- Configuring display settings for various data types and calculation outcomes (such as dates, currency, percentages, and fractions)
- Customizing cell borders and background fills
- Styling row and column headers
- Applying predefined styles
Navigation
- Efficiently traversing large sheets
- Simultaneously managing multiple worksheets and workbooks
Data Replication and Relocation
- Selecting specific cell ranges
- Transferring data between locations
- Utilizing special insertion options
- Automatically filling data series (e.g., sequential numbers or subsequent business days)
Formulas, Cell References, and Names
- Creating, editing, and duplicating formulas
- Identifying and resolving circular references
- Applying conditional formatting rules
- Differentiating between address types and their applications
- Referencing data across different worksheets and workbooks
- Leveraging named cells for clarity
Functions
- Core principles of function usage
- Essential functions for common tasks
- Nesting functions for complex logic
- Incorporating conditional logic
- Utilizing the Function Wizard
Visual Elements in Spreadsheets
- Inserting AutoShapes and WordArt
- Embedding static and dynamic visual data
Charting
- Overview of primary chart types and their use cases
- Best practices for designing effective charts
- Step-by-step chart creation
- Modifying chart components
- Customizing unique chart styles
Data Concealment and Protection
- Hiding sheets, columns, or rows
- Obscuring formulas and cell content
- Locking worksheets and workbooks against modifications
- Securing workbooks prior to access
Printing
- Printing specific sheets or non-contiguous areas
- Outputting charts
Requirements
Familiarity with the Windows operating system
14 Hours
Testimonials (1)
well-prepared training, interesting topics