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 program fundamentals
- Structure of the main window
- Managing workbooks and sheets
Inputting and adjusting data in worksheet cells
Formatting data
- Configuring display formats for various data types and calculation results (such as dates, currency, percentages, or fractions)
- Setting cell borders and backgrounds
- Styling row and column headers
- Applying predefined Styles
Navigation
- Moving through large datasets within sheets
- Simultaneous management of multiple worksheets or workbooks
Duplicating and relocating data
- Selecting specific areas (cell ranges)
- Transferring data
- Special insertion techniques
- Auto-filling data series (e.g., sequential numbers or consecutive business days)
Formulas, addresses, and cell names
- Constructing, editing, and duplicating formulas
- Understanding circular references
- Implementing conditional formatting
- Different address types and their applications
- Referencing other worksheets and workbooks
- Utilizing cell names
Functions
- General principles for using functions
- Commonly used functions
- Nested functions
- Applying conditional logic
- Using the Function Wizard
Graphics in spreadsheets
- AutoShapes and WordArt
- Static and dynamic visual representations of data
Charts
- Primary chart types and their use cases
- Core principles for creating engaging charts
- Chart creation process
- Modifying graph components
- Creating custom chart types
Concealing and Protecting Data
- Hiding sheets, columns, and rows
- Concealing formulas and cell contents
- Securing worksheets and workbooks against modification
- Protecting workbooks prior to opening
Printing
- Printing sheets and non-contiguous areas
- Printing charts
Requirements
Familiarity with the Windows operating system
14 Hours
Testimonials (1)
well-prepared training, interesting topics
