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
- Overview of core program features
- Understanding the main window layout
- Managing workbooks and worksheets
Inputting and Editing Data in Cells
Data Formatting
- Configuring display settings for various data types and calculation outcomes (e.g., dates, currency, percentages, or fractions)
- Customizing cell borders and background colors
- Formatting row and column headers
- Applying Styles
Navigation
- Efficiently moving through large worksheets
- Simultaneously working with multiple worksheets or workbooks
Copying and Moving Data
- Selecting cell ranges and areas
- Transferring data effectively
- Inserting special elements
- Auto-filling data series (e.g., sequential numbers or future working days)
Formulas, Cell Addresses, and Named Ranges
- Creating, editing, and duplicating formulas
- Understanding circular references
- Applying conditional formatting
- Different types of cell addresses and their applications
- Linking to other worksheets and workbooks
- Utilizing named cells
Functions
- Basic principles for utilizing functions
- Commonly used functions
- Nesting functions for complex calculations
- Working with conditional logic
- Using the Function Wizard
Graphics in Spreadsheets
- Incorporating AutoShapes and WordArt
- Creating static and dynamic data visualizations
Charts
- Key chart types and their practical uses
- Best practices for designing engaging charts
- Step-by-step chart creation
- Modifying chart components and graphs
- Building custom chart types
Data Protection and Hiding Elements
- Concealing sheets, columns, and rows
- Masking formulas and cell content
- Safeguarding worksheets and workbooks from edits
- Implementing protection prior to opening workbooks
Printing
- Printing specific sheets and non-contiguous areas
- Outputting charts to paper or digital formats
Requirements
Proficiency with the Windows operating system
Testimonials (1)
well-prepared training, interesting topics
