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 window
- Operations on workbooks and worksheets
Entering and Modifying Data in Worksheet Cells
Data Formatting
- Configuring display formats for different 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
- Efficient movement within large worksheets
- Simultaneous work across multiple worksheets and workbooks
Copying and Moving Data
- Selecting ranges (cell areas)
- Moving data
- Paste Special operations
- Autofill features for data series (e.g., sequential numbers and dates)
Formulas, Addresses, and Cell Names
- Creating, modifying, and copying formulas
- Handling circular references
- Applying conditional formatting
- Understanding address types and their applications
- Referencing other worksheets and workbooks
- Utilizing defined cell names
Functions
- General rules for using functions
- Commonly used functions
- Nested functions
- Using logical conditions
- The Function Wizard
Graphics in Spreadsheets
- AutoShapes and WordArt
- Static and dynamic data visualizations
Charts
- Main chart types and their applications
- 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 content
- Protecting worksheets and workbooks from modification
- Securing workbooks with a password before opening
Printing
- Printing specific sheets and non-contiguous ranges
- Printing charts
Requirements
Knowledge of Windows
14 Hours
Testimonials (1)
well-prepared training, interesting topics
