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 and its core features
- Understanding the main interface layout
- Managing workbooks and worksheets
Entering and Modifying Data in Worksheet Cells
Data Formatting
- Customizing the display format for various data types, such as dates, monetary values, percentages, and fractions
- Setting cell borders and background colors
- Formatting row and column headers
- Applying and customizing Styles
Navigation
- Navigating through large and complex worksheets
- Working simultaneously on multiple worksheets and workbooks
Copying and Moving Data
- Selecting cell ranges
- Moving data within or between sheets
- Performing special paste operations
- Using AutoFill to generate data series (e.g., sequential numbers or working days)
Formulas, Cell Addresses, and Named Ranges
- Creating, editing, and copying formulas
- Identifying and resolving circular references
- Applying Conditional Formatting
- Understanding and using different address types (relative, absolute, mixed)
- Referencing other worksheets and workbooks
- Utilizing Named Ranges for easier formula management
Functions
- General principles for using functions effectively
- Commonly used built-in functions
- Using nested functions for complex calculations
- Leveraging conditional logic in functions
- Using the Function Wizard
Graphics in Spreadsheets
- Inserting AutoShapes and WordArt
- Working with static and dynamic images
Charts
- Overview of primary chart types and their appropriate use cases
- Best practices for designing clear and impactful charts
- Step-by-step chart creation
- Modifying chart elements and components
- Creating custom chart types
Hiding and Protecting Data
- Hiding rows, columns, and entire worksheets
- Concealing formulas and cell contents
- Protecting worksheets and workbooks from unauthorized modifications
- Encrypting workbooks with passwords for secure access
Printing
- Printing specific sheets or non-contiguous areas
- Printing charts
Requirements
Familiarity with the Windows operating system.
14 Hours
Testimonials (1)
well-prepared training, interesting topics
