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
- Structure of the main window
- Managing workbooks and sheets
Entering and Editing Data in Worksheet Cells
Formatting Data
- Configuring display formats for various data types and calculation results (e.g., dates, currency, percentages, or fractions)
- Setting cell borders and background colors
- Formatting row and column headers
- Applying Styles
Navigation
- Navigating through large sheets
- Working simultaneously across multiple worksheets and workbooks
Copying and Moving Data
- Selecting areas (cell ranges)
- Moving data
- Special paste options
- Using Autofill for data series (e.g., sequences, consecutive workdays)
Formulas, Cell Addresses, and Named Ranges
- Creating, modifying, and copying formulas
- Understanding circular references
- Applying conditional formatting
- Using different address types
- Referencing other worksheets and workbooks
- Utilizing named ranges
Functions
- General rules for using functions
- Commonly used functions
- Nesting functions
- Logical conditions
- Using the Function Wizard
Graphics in Spreadsheets
- AutoShapes and WordArt
- Static and dynamic graphical representations
Charts
- Main chart types and their use cases
- Principles for creating effective charts
- Building charts
- Modifying chart components
- Creating custom chart types
Hiding and Protecting Data
- Hiding sheets, columns, and rows
- Hiding formulas and cell contents
- Protecting worksheets and workbooks from unauthorized changes
- Password-protecting workbooks upon opening
Printing
- Printing sheets and non-contiguous ranges
- Printing charts
Requirements
Knowledge of Windows
14 Hours
Testimonials (1)
well-prepared training, interesting topics
