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
- Structure of the main interface
- Managing workbooks and worksheets
Entering and Editing Worksheet Data
Data Formatting
- Configuring display formats for various data types and calculation results (e.g., dates, currency, percentages, or fractions)
- Adjusting cell borders and background colors
- Formatting row and column headers
- Utilizing Styles
Navigation
- Efficiently moving within large sheets
- Working simultaneously across multiple worksheets and workbooks
Copying and Moving Data
- Selecting areas (cell ranges)
- Relocating data
- Using special paste options
- Autofill data series (such as sequential numbers and subsequent business days)
Formulas, Addresses, and Cell Names
- Creating, editing, and copying formulas
- Understanding circular references
- Applying conditional formatting
- Understanding address types and their applications
- Referencing other worksheets and workbooks
- Utilizing defined cell names
Functions
- General principles for using functions
- Commonly used functions
- Utilizing nested functions
- Applying conditions
- Using the Function Wizard
Graphics in Spreadsheets
- Using AutoShapes and WordArt
- Embedding static and dynamic images
Charts
- Primary chart types and their use cases
- Key principles for creating impactful charts
- Constructing charts
- Modifying chart components
- Designing custom chart types
Hiding and Data Protection
- Hiding sheets, columns, and rows
- Hiding formulas and cell contents
- Securing worksheets and workbooks against modifications
- Password-protecting workbooks upon opening
Printing
- Printing worksheets and non-contiguous ranges
- Printing charts
Requirements
Familiarity with the Windows operating system
14 Hours
Testimonials (1)
well-prepared training, interesting topics
