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 display options for different data types and calculation results (e.g., dates, currency amounts, percentages, or fractions)
- Setting cell borders and background colours
- Formatting row and column headers
- Applying styles
Navigation
- Navigating large worksheets
- Working simultaneously on multiple worksheets or workbooks
Copying and Moving Data
- Selecting areas (cell ranges)
- Moving data
- Paste special
- Autofill data series (e.g., ordinal numbers and dates for the next working day)
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
- Using named cells
Functions
- General rules for using functions
- Commonly used functions
- Nested functions
- Using IF conditions
- Utilizing the Function Wizard
Graphics in Spreadsheets
- AutoShapes and WordArt
- Static and dynamic data visualizations
Charts
- Main chart types and their applications
- Key principles for creating effective charts
- Creating charts
- Modifying chart components
- Creating custom chart types
Hide Data and Protection
- Hiding sheets, columns, and rows
- Hiding formulas and cell entries
- Protecting worksheets and workbooks from modifications
- 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
