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
- Foundational overview of the application
- Understanding the main window layout
- Managing workbooks and worksheets
Inputting and editing data in cells
Data Formatting
- Customising the display of various data types and outcomes (such as dates, currency, percentages, or fractions)
- Adjusting cell borders and background colours
- Formatting row and column headers
- Applying predefined styles
Navigation
- Efficiently moving through extensive worksheets
- Managing multiple worksheets and workbooks simultaneously
Duplication and relocation of data
- Selecting specific areas (cell ranges)
- Relocating data
- Special insertion options
- Auto-filling data series (e.g., sequential numbers and upcoming business days)
Formulas, references, and named cells
- Creating, altering, and copying formulas
- Identifying circular references
- Applying conditional formatting
- Differentiating address types and their applications
- Linking to other worksheets and workbooks
- Utilising named ranges
Functions
- General guidelines for function usage
- Essential frequently used functions
- Nesting functions
- Applying conditional logic
- Using the Function Wizard
Visual elements in spreadsheets
- Utilising AutoShapes and WordArt
- Creating static and dynamic data visualisations
Charts
- Primary chart types and their practical uses
- Core principles for designing impactful charts
- Chart creation processes
- Modifying chart components
- Developing custom chart styles
Concealing data and security measures
- Hiding specific sheets, columns, and rows
- Obscuring formulas and cell contents
- Locking worksheets and workbooks against edits
- Securing workbooks prior to opening
Printing
- Printing specific sheets and non-contiguous areas
- Outputting charts
Requirements
Familiarity with the Windows operating system
14 Hours
Testimonials (1)
well-prepared training, interesting topics
