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 the program's core features
- Understanding the main window interface and layout
- Managing workbooks and worksheets
Inputting and Editing Data in Cells
Data Formatting
- Customizing the display of various data types and calculation results (e.g., dates, currency, percentages, and fractions)
- Configuring cell borders and background colors
- Appropriate formatting for row and column headers
- Application of predefined Styles
Navigation
- Efficiently navigating through large spreadsheets
- Working simultaneously with multiple worksheets and workbooks
Copying and Moving Data
- Selecting specific cell ranges
- Transferring data between locations
- Performing special insertion tasks
- Using Autofill to generate data series (e.g., ordinal numbers or subsequent working dates)
Formulas, Addresses, and Cell Names
- Creating, editing, and duplicating formulas
- Identifying and resolving circular references
- Implementing conditional formatting
- Understanding and utilizing different address types
- Referencing other worksheets and external workbooks
- Assigning and using defined cell names
Functions
- General principles for utilizing functions
- Exploring commonly used functions
- Nesting functions for complex calculations
- Applying conditional logic
- Using the Function Argument Wizard
Graphics in Spreadsheets
- Incorporating AutoShapes and WordArt
- Creating static and dynamic visual data representations
Charts
- Reviewing primary chart types and their practical applications
- Key principles for designing impactful charts
- Step-by-step chart creation
- Modifying chart components and elements
- Developing custom chart types
Hiding Data and Security
- Concealing specific sheets, columns, or rows
- Masking formulas and cell contents
- Locking worksheets and workbooks to prevent unauthorized edits
- Setting password protection for opening workbooks
Printing
- Printing specific sheets or non-contiguous areas
- Outputting charts for presentation or reporting
Requirements
Familiarity with the Windows operating system.
14 Hours
Testimonials (1)
well-prepared training, interesting topics
