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
- Understanding the main window layout
- Managing workbooks and worksheets
Entering and Modifying Data in Cells
Formatting Data
- Customizing the display of various data types and calculation results (e.g., dates, currency amounts, percentages, or fractions)
- Setting cell borders and background colors
- Formatting row and column headers
- Applying Styles
Navigating the Workspace
- Moving through large worksheets
- Working simultaneously on multiple worksheets and workbooks
Copying and Moving Data
- Selecting areas (cell ranges)
- Moving data between locations
- Utilizing special paste options
- Using AutoFill to populate data series (e.g., ordinal numbers or subsequent working days)
Formulas, Addresses, and Cell Names
- Creating, modifying, and copying formulas
- Understanding circular references
- Applying conditional formatting
- Utilizing different address types
- Referencing other worksheets and workbooks
- Using defined cell names
Functions
- General guidelines for using functions
- Commonly used functions
- Nested functions
- Implementing conditional logic within functions
- Using the Function Wizard
Graphics in Spreadsheets
- AutoShapes and WordArt
- Incorporating static and dynamic images
Charts
- Main chart types and their applications
- Principles for creating compelling charts
- Creating charts
- Modifying chart components
- Creating custom chart types
Hiding and Data Protection
- Hiding sheets, columns, and rows
- Concealing formulas and cell content
- Protecting worksheets and workbooks from unauthorized changes
- Securing workbooks prior to opening
Printing
- Printing sheets and discontinuous areas
- Printing charts
Requirements
Familiarity with the Windows operating system.
14 Hours
Testimonials (1)
well-prepared training, interesting topics
