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 application
- Layout and interface of the main window
- Managing workbooks and sheets
Inputting and editing data within worksheet 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
- Styling row and column headers
- Applying predefined Styles
Navigation techniques
- Efficiently moving through large sheets
- Simultaneously working across multiple worksheets or workbooks
Duplicating and relocating data
- Selecting specific areas (cell ranges)
- Transferring data between locations
- Performing special insertions
- Auto-filling data sequences (such as ordinal numbers or consecutive business days)
Formulas, addresses, and named cells
- Creating, editing, and duplicating formulas
- Understanding circular references
- Implementing conditional formatting
- Types of cell addresses and their appropriate usage
- Referencing data in other worksheets or workbooks
- Utilizing named cell ranges
Functions
- Fundamental principles for using functions
- Commonly utilized functions
- Nesting functions
- Applying conditional logic
- Using the Function Builder
Graphics within spreadsheets
- Incorporating AutoShapes and WordArt
- Displaying static and dynamic data visuals
Charts
- Primary chart types and their respective use cases
- Best practices for creating impactful charts
- Step-by-step chart creation
- Modifying graph components and elements
- Developing custom chart styles
Data concealment and protection
- Hiding specific sheets, columns, or rows
- Concealing formulas and cell contents
- Locking worksheets and workbooks to prevent alterations
- Securing workbooks prior to opening
Printing
- Printing specific sheets or non-contiguous regions
- Outputting charts
Requirements
Familiarity with the Windows operating system
14 Hours
Testimonials (1)
well-prepared training, interesting topics
