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
- Overview of the software capabilities
- Exploring the main window interface
- Managing workbooks and worksheets
Inputting and Updating Data in Cells
Data Formatting
- Configuring display options for various data types and results (e.g., dates, currency, percentages, or fractions)
- Customizing cell borders and background colours
- Formatting row and column headers
- Applying pre-defined Styles
Navigation
- Navigating efficiently through large datasets
- Working simultaneously across multiple worksheets and workbooks
Duplicating and Transferring Data
- Selecting specific areas (cell ranges)
- Moving data to new locations
- Special insertion techniques
- Auto-filling data series (such as sequential numbers or future working days)
Formulas, Cell Addresses, and Names
- Building, editing, and duplicating formulas
- Understanding circular references
- Implementing conditional formatting
- Different types of cell addressing and their applications
- Linking to other worksheets and workbooks
- Assigning names to cells
Functions
- Core principles for utilizing functions
- Commonly used functions
- Nesting functions within formulas
- Applying conditional logic
- Using the Function Wizard
Visual Elements in Spreadsheets
- Utilizing AutoShapes and WordArt
- Creating static and dynamic visual representations of data
Chart Creation
- Key chart types and their best-use cases
- Best practices for designing effective charts
- Steps to create charts
- Customizing chart components and modifications
- Defining custom chart types
Data Privacy and Security
- Concealing specific sheets, columns, or rows
- Hiding formulas and cell contents
- Locking worksheets and workbooks against edits
- Securing workbooks with passwords before opening
Printing
- Printing specific sheets or non-contiguous areas
- Outputting charts
Requirements
Familiarity with the Windows operating system.
14 Hours
Testimonials (1)
well-prepared training, interesting topics
