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
- Core information regarding the application
- Overview of the main window structure
- Managing workbooks and individual sheets
Entering and modifying data in worksheet cells
Formatting data
- Configuring the display of various data types and calculation results (such as dates, currencies, percentages, or fractions)
- Setting cell borders and background colors
- Formatting row and column headers
- Applying Styles
Navigation
- Navigating through extensive sheets
- Working concurrently on multiple worksheets or workbooks
Copying and moving data
- Selecting areas (cell ranges)
- Transferring data
- Special insertion options
- Auto-filling data series (for example, sequential numbers or upcoming business days)
Formulas, addresses, and cell names
- Creating, editing, and copying formulas
- Understanding circular references
- Applying conditional formatting
- Types of cell addresses and their practical applications
- Referencing other worksheets and workbooks
- Utilizing named cells
Functions
- General guidelines for function usage
- Commonly used functions
- Nested functions
- Incorporating conditional logic
- Using the Function Wizard
Graphics in spreadsheets
- AutoShapes and WordArt
- Static and dynamic data visualization
Charts
- Primary chart types and their respective uses
- Key principles for designing effective charts
- Chart creation processes
- Modifying chart components
- Defining custom chart types
Hiding and Data Protection
- Concealing sheets, columns, and rows
- Hiding formulas and cell contents
- Safeguarding worksheets and workbooks from modifications
- Securing workbooks prior to opening
Printing
- Printing sheets and non-contiguous areas
- Printing charts
Requirements
Proficiency in the Windows operating system.
14 Hours
Testimonials (1)
well-prepared training, interesting topics
