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 14 hours
Course Outline
Introduction
- Foundational program overview
- Interface configuration and main window layout
- Management of workbooks and worksheets
Data Entry and Cell Modification
Data Formatting Standards
- Display configurations for data types and calculated results (including dates, monetary values, percentages, and fractions)
- Boundary definitions and background styling for cells
- Formatting of row and column headers
- Application of predefined Styles
Navigation Procedures
- Traversal strategies for large-scale worksheets
- Simultaneous operation across multiple worksheets and workbooks
Data Transfer Operations
- Selection of specific cell ranges
- Transposition of data entries
- Specialized insertion techniques
- Automatic population of data series (e.g., sequential numbers and consecutive business dates)
Formulas, Cell References, and Naming Conventions
- Creation, revision, and duplication of formulas
- Identification and resolution of circular references
- Implementation of conditional formatting rules
- Classification and application of address types
- External references to other worksheets and workbooks
- Assignment and use of named cells
Functionality and Logic
- Standard protocols for function usage
- Application of commonly utilized functions
- Nesting of functions within formulas
- Integration of conditional logic
- Utilization of the Function Wizard
Visual Elements in Spreadsheets
- Implementation of AutoShapes and text effects
- Generation of static and dynamic data visualizations
Chart Development
- Primary chart categories and their operational applications
- Core principles for designing effective visual representations
- Chart construction procedures
- Modification of chart components and attributes
- Creation of customized chart types
Data Concealment and Security Protocols
- Concealment of worksheets, columns, and rows
- Obscuring of formulas and cell values
- Restriction of modifications to worksheets and workbooks
- Pre-opening security controls for workbooks
Output and Printing
- Printing of worksheets and non-contiguous areas
- Printing of graphical charts
Requirements
Familiarity with the Windows operating system
Testimonials (1)
well-prepared training, interesting topics
