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
- Determining how to display different types of data and calculation results (e.g., dates, amounts, percentages, or fractions)
- Setting cell borders and background colors
- Formatting row and column headings
- Using Styles
Navigation
- Moving through extensive sheets
- Concurrent work on multiple worksheets and workbooks
Copying and moving data
- Selecting areas (cell ranges)
- Moving data
- Special insert options
- Using autofill for data series (e.g., ordinal numbers and dates for the next working day)
Formulas, addresses, and cell names
- Creating, modifying, and copying formulas
- Understanding circular references
- Applying conditional formatting
- Address types and their usage
- References to other worksheets and workbooks
- Using cell names
Functions
- General rules for using functions
- Commonly used functions
- Nested functions
- Using conditional logic
- 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
- Components of graphs and their modification
- Creating custom chart types
Hiding and Data Protection
- Hiding sheets, columns, and rows
- Hiding formulas and cell entries
- Protecting worksheets and workbooks from changes
- Protecting workbooks before opening
Printing
- Printing sheets and non-contiguous areas
- Printing charts
Requirements
Knowledge of Windows
14 Hours
Testimonials (1)
well-prepared training, interesting topics
