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
- Essential overview of the software
- Understanding the main window interface
- Managing workbooks and worksheets
Entering and editing worksheet data
Data formatting
- Customising the display of various data types and calculation results (e.g., dates, currency amounts, percentages, or fractions)
- Setting cell borders and background colours
- Formatting row and column headings
- Applying Styles
Navigating spreadsheets
- Moving efficiently through large sheets
- Working simultaneously on multiple worksheets and workbooks
Copying and moving data
- Selecting areas (cell ranges)
- Moving data between locations
- Utilising special paste options
- Using Autofill for data series (e.g., ordinal numbers and subsequent working day dates)
Formulas, addresses, and cell names
- Creating, modifying, and copying formulas
- Understanding circular references
- Applying conditional formatting
- Types of cell references and their applications
- Referencing other worksheets and workbooks
- Using defined cell names
Functions
- General rules for using functions
- Commonly used functions
- Nested functions
- Using IF conditions
- The Function Wizard
Graphics in spreadsheets
- AutoShapes and WordArt
- Static and dynamic data images
Charts
- Primary chart types and their appropriate applications
- Key principles for creating impactful charts
- Creating charts
- Modifying graph components
- Creating custom chart types
Hiding data and protection
- Hiding sheets, columns, and rows
- Concealing formulas and cell contents
- Protecting worksheets and workbooks from modification
- Protecting workbooks with passwords before opening
Printing
- Printing sheets and specific non-contiguous areas
- Printing charts
Requirements
Familiarity with the Windows operating environment
14 Hours
Testimonials (1)
well-prepared training, interesting topics
