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.
Duration 14 hours
Course Outline
Introduction
- Essential overview of the software
- Understanding the main window layout
- Managing workbooks and sheets
Inputting and editing data within worksheet cells
Data formatting
- Configuring display settings for various data types and calculation outcomes, such as dates, currency, percentages, and fractions
- Setting cell borders and background colors
- Styling row and column headers
- Applying predefined Styles
Navigation
- Efficiently moving through large sheets
- Working simultaneously with multiple worksheets or workbooks
Copying and moving data
- Selecting specific cell ranges
- Transferring data between locations
- Special insertion techniques
- Auto-filling data series, such as sequential numbers and future working days
Formulas, addresses, and named cells
- Creating, adjusting, and duplicating formulas
- Understanding circular references
- Implementing conditional formatting
- Different address types and their practical applications
- Referencing data across different worksheets and workbooks
- Utilizing defined cell names
Functions
- General guidelines for using functions
- Commonly used function types
- Nesting functions for complex logic
- Applying conditional functions
- Using the Function Builder tool
Visual elements in spreadsheets
- Incorporating AutoShapes and WordArt
- Creating static and dynamic visual representations of data
Charts
- Overview of primary chart types and their use cases
- Key principles for designing engaging charts
- Step-by-step chart creation
- Modifying chart components and elements
- Developing custom chart types
Concealing and protecting data
- Concealing sheets, columns, and rows
- Protecting formulas and cell contents
- Securing worksheets and workbooks against modifications
- Implementing protection measures prior to opening a workbook
Printing
- Printing specific sheets or non-contiguous ranges
- Outputting charts to print
Requirements
Proficiency with the Windows operating system
Testimonials (1)
well-prepared training, interesting topics
