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
- Essential overview of the software
- Layout and structure of the main interface
- Managing workbooks and worksheets
Inputting and Adjusting Data in Cells
Data Formatting
- Configuring the display of various data types and calculation outcomes (e.g., dates, currency, percentages, or fractions)
- Setting cell borders and background fills
- Styling row and column headings
- Applying pre-defined styles
Navigation
- Traversing large spreadsheets
- Managing multiple worksheets and workbooks concurrently
Duplicating and Relocating Data
- Selecting specific areas (cell ranges)
- Transferring data between locations
- Advanced insertion techniques
- Auto-filling data series (such as ordinal numbers or upcoming business days)
Formulas, Addresses, and Named Ranges
- Writing, editing, and copying formulas
- Understanding circular references
- Implementing conditional formatting
- Types of cell addresses and their applications
- Linking to other worksheets and workbooks
- Utilising defined names
Functions
- General principles for function usage
- Commonly used functions
- Nesting functions
- Working with conditional logic
- Using the Function Wizard
Visual Elements in Spreadsheets
- Inserting AutoShapes and WordArt
- Displaying static and dynamic data representations
Charts
- Primary chart types and their suitable use cases
- Best practices for creating impactful charts
- Generating charts
- Modifying chart components
- Designing custom chart types
Obscuring and Data Security
- Concealing sheets, columns, and rows
- Hiding formulas and cell contents
- Locking worksheets and workbooks against edits
- Securing workbooks prior to opening
Printing
- Printing sheets and non-contiguous areas
- Outputting charts
Requirements
Familiarity with the Windows operating system.
14 Hours
Testimonials (1)
well-prepared training, interesting topics
