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 software
- Structure of the main interface
- Managing workbooks and worksheets
Entering and Modifying Data in Worksheet Cells
Formatting Data
- Configuring display formats for various data types and calculation results (e.g., dates, currency, percentages, or fractions)
- Defining cell borders and background colors
- Formatting row and column headers
- Applying Styles
Navigating the Workspace
- Efficient movement within extensive spreadsheets
- Concurrent work across multiple worksheets or workbooks
Copying and Moving Data
- Selecting ranges (cell areas)
- Moving data
- Special paste operations
- Using AutoFill for data series (e.g., sequential numbers and consecutive working days)
Formulas, Addresses, and Cell Names
- Creating, modifying, and copying formulas
- Understanding circular references
- Applying conditional formatting
- Different types of addresses and their applications
- Referencing other worksheets and workbooks
- Utilizing named cells
Functions
- General rules for using functions
- Commonly used functions
- Nested functions
- Using logical conditions (IF)
- The Function Wizard
Graphics in Spreadsheets
- AutoShapes and WordArt
- Inserting static and dynamic images
Charts
- Primary chart types and their use cases
- Key principles for creating effective charts
- Creating charts
- Modifying chart components
- Creating custom chart types
Hiding and Data Protection
- Hiding sheets, columns, and rows
- Hiding formulas and cell contents
- Protecting worksheets and workbooks from changes
- Securing workbooks upon opening
Printing
- Printing sheets and non-contiguous areas
- Printing charts
Requirements
Familiarity with the Windows operating system
14 Hours
Testimonials (1)
well-prepared training, interesting topics
