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 details about the application
- Architecture of the primary window
- Managing workbooks (notebooks) and individual sheets
Inputting and editing data within worksheet cells
Data formatting
- Configuring the display of various data types and calculation outputs (such as dates, monetary values, percentages, or fractions)
- Setting cell borders and backgrounds
- Styling row and column headers
- Applying predefined Styles
Navigation
- Navigating through extensive worksheets
- Simultaneous handling of multiple worksheets and workbooks
Duplication and relocation of data
- Selecting specific areas (cell ranges)
- Transferring data
- Specialized insertion methods
- Auto-filling data sections (series), including ordinal numbers and consecutive business days
Formulas, addressing, and cell naming
- Building, altering, and duplicating formulas
- Understanding circular references
- Implementing conditional formatting
- Different address types and their applications
- Linking to other worksheets and workbooks
- Utilizing named cells
Functions
- General guidelines for function usage
- Commonly utilized functions
- Nested functions
- Application of conditional logic
- Using the Function Wizard
Graphics within spreadsheets
- AutoShapes and WordArt features
- Static and dynamic data visualizations
Charts
- Primary chart types and their respective uses
- Core principles for designing impactful charts
- Process of creating charts
- Chart components and how to modify them
- Creating custom chart types
Concealment and Data Security
- Hiding specific sheets, columns, and rows
- Concealing formulas and cell contents
- Safeguarding worksheets and workbooks from modification
- Securing workbooks prior to opening
Printing
- Outputting sheets and non-contiguous areas
- Printing charts
Requirements
Familiarity with the Windows operating system
14 Hours
Testimonials (1)
well-prepared training, interesting topics
