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
- Basic information about the program
- Structure of the main window
- Operations on workbooks and sheets
Entering and Modifying Data in Worksheet Cells
Formatting Data
- Configuring the display of different data types and calculation results (e.g., dates, currency amounts, percentages, or fractions)
- Setting cell borders and background colors
- Formatting row and column headers
- Applying Styles
Navigation
- Navigating within large worksheets
- Working simultaneously on multiple worksheets and workbooks
Copying and Moving Data
- Selecting ranges (cell areas)
- Moving data
- Special paste options
- Using AutoFill for data series (e.g., ordinal numbers and next working day dates)
Formulas, Cell Addresses, and Named Ranges
- Creating, modifying, and copying formulas
- Handling circular references
- Applying conditional formatting
- Understanding address types and their usage
- Referencing other worksheets and workbooks
- Utilizing named ranges
Functions
- General rules for using functions
- Commonly used functions
- Nested functions
- Using logical conditions
- Using the Function Wizard
Graphics in Spreadsheets
- AutoShapes and WordArt
- Static and dynamic data images
Charts
- Main chart types and their applications
- General principles for creating effective charts
- Creating charts
- Modifying chart components
- Creating custom chart types
Hiding and Data Protection
- Hiding sheets, columns, and rows
- Concealing formulas and cell contents
- Protecting worksheets and workbooks from modification
- Protecting workbooks upon opening
Printing
- Printing sheets and non-contiguous areas
- Printing charts
Requirements
Knowledge of Windows
14 Hours
Testimonials (1)
well-prepared training, interesting topics
