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
- Fundamental overview of the application
- Structure of the primary interface window
- Managing workbooks and individual sheets
Inputting and editing worksheet cell data
Data Formatting
- Configuring display settings for various data types and calculation outputs (such as dates, currency, percentages, or fractions)
- Adjusting cell borders and background fills
- Formatting row and column headers
- Application of Styles
Navigation
- Efficiently traversing large-scale worksheets
- Simultaneous management of multiple worksheets and workbooks
Duplication and transfer of data
- Selection of specific regions (cell ranges)
- Relocating data entries
- Specialized insertion methods
- Auto-filling data sequences (e.g., numbering systems and consecutive business days)
Formulas, Addressing, and Named Cells
- Building, altering, and replicating formulas
- Understanding circular references
- Applying conditional formatting rules
- Distinguishing between address types and their respective applications
- Linking references across different worksheets and workbooks
- Utilizing defined cell names
Functions
- Core principles for function usage
- Commonly utilized functions
- Implementing nested functions
- Leveraging conditional logic
- Utilizing the Function Wizard
Visual Elements in Spreadsheets
- Integration of AutoShapes and WordArt
- Incorporating static and dynamic data visualizations
Charts
- Overview of primary chart categories and their practical uses
- Best practices for designing impactful charts
- Step-by-step chart creation process
- Customizing chart components and adjustments
- Developing custom chart types
Obscuring and Data Security
- Concealing specific sheets, columns, or rows
- Hiding formulas and underlying cell content
- Safeguarding worksheets and entire workbooks against modifications
- Implementing password protection prior to opening files
Printing
- Outputting specific sheets or non-contiguous regions
- Printing generated charts
Requirements
Proficiency in the Windows operating environment
14 Hours
Testimonials (1)
well-prepared training, interesting topics
