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
- Fundamental overview of the software
- Layout and structure of the main interface
- Managing workbooks and worksheets
Entering and editing data in worksheet cells
Data formatting
- Configuring display settings for various data types and calculation results, such as dates, currency, percentages, or fractions
- Customizing cell borders and background colors
- Styling row and column headers
- Application of predefined Styles
Navigation
- Efficiently moving through large datasets
- Working simultaneously with multiple worksheets or workbooks
Copying and moving data
- Selecting specific areas or cell ranges
- Transferring data between locations
- Special insertion options
- Using Autofill to generate data series, such as sequential numbers or next business days
Formulas, cell addresses, and names
- Creating, modifying, and duplicating formulas
- Understanding circular references
- Applying conditional formatting
- Different types of cell addresses and their applications
- Referencing other worksheets and workbooks
- Utilizing defined cell names
Functions
- Core principles for using functions
- Overview of frequently used functions
- Nesting functions within formulas
- Incorporating conditional logic
- Using the Function Wizard (Insert Function)
Graphics in spreadsheets
- Incorporating AutoShapes and WordArt
- Displaying static and dynamic visual representations of data
Charts
- Overview of primary chart types and their specific uses
- Best practices for designing effective charts
- Step-by-step chart creation
- Adjusting chart components and styling
- Creating custom chart types
Data hiding and protection
- Concealing specific sheets, columns, or rows
- Protecting formulas and cell contents
- Locking worksheets and workbooks to prevent modifications
- Securing workbooks prior to opening
Printing
- Printing specific sheets or non-contiguous ranges
- Outputting charts to paper or PDF
Requirements
Familiarity with the Windows operating system is required.
14 Hours
Testimonials (1)
well-prepared training, interesting topics
