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
- Foundational knowledge of the application
- Layout and structure of the main interface
- Managing workbooks and individual sheets
Inputting and Editing Data in Worksheet Cells
Data Formatting
- Configuring display formats for various data types and calculation outcomes (such as dates, currency, percentages, or fractions)
- Customizing cell borders and background colors
- Styling row and column headers
- Application of predefined Styles
Navigation
- Efficiently moving through large spreadsheets
- Simultaneously working across multiple worksheets and workbooks
Copying and Moving Data
- Selecting specific areas (cell ranges)
- Transferring data between locations
- Special insertion techniques
- Automating data series (e.g., sequential numbers and consecutive working days) with Autofill
Formulas, Cell References, and Named Ranges
- Creating, adjusting, and replicating formulas
- Understanding circular references
- Applying Conditional formatting
- Differentiating address types and their appropriate use
- Referencing data in other worksheets or workbooks
- Utilizing defined cell names
Functions
- General guidelines for function usage
- Overview of frequently used functions
- Implementing nested functions
- Utilizing conditional logic
- Using the Function Builder
Visual Elements in Spreadsheets
- Working with AutoShapes and WordArt
- Integrating static and dynamic data visualizations
Charts
- Key chart types and their practical applications
- Best practices for designing impactful charts
- Step-by-step chart creation
- Modifying chart components and graphical elements
- Developing custom chart types
Data Concealment and Protection
- Hiding specific sheets, columns, or rows
- Concealing formulas and cell contents
- Locking worksheets and workbooks against modification
- Securing workbooks prior to opening
Printing
- Printing entire sheets or non-contiguous areas
- Printing chart outputs
Requirements
Familiarity with the Windows operating system
14 Hours
Testimonials (1)
well-prepared training, interesting topics
