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 core program concepts
- Understanding the main window layout
- Managing workbooks and worksheets
Data Entry and Modification in Cells
Data Formatting
- Configuring display options for various data types and calculation outcomes (such as dates, currency, percentages, and fractions)
- Customizing cell borders and background fills
- Formatting row and column headers
- Applying predefined Styles
Navigation
- Efficiently navigating through large worksheets
- Working simultaneously with multiple worksheets and workbooks
Copying and Moving Data
- Selecting specific areas (cell ranges)
- Transferring data between locations
- Performing specialized insert operations
- Using AutoFill to generate data series (e.g., ordinal numbers and consecutive working days)
Formulas, Addresses, and Named Cells
- Creating, editing, and copying formulas
- Understanding circular references
- Implementing conditional formatting
- Recognizing different address types and their applications
- Referencing data across other worksheets and workbooks
- Utilizing defined cell names
Functions
- General principles for using functions
- Commonly used functions
- Nesting functions within one another
- Applying conditional logic
- Using the Function Wizard
Visuals in Spreadsheets
- Incorporating AutoShapes and WordArt
- Displaying static and dynamic data visualizations
Charts
- Overview of primary chart types and their use cases
- Best practices for designing effective charts
- Step-by-step chart creation
- Adjusting chart components and modifications
- Developing custom chart styles
Data Concealment and Protection
- Hiding specific sheets, columns, and rows
- Concealing formulas and cell contents
- Safeguarding worksheets and workbooks against unintended changes
- Securing workbooks prior to opening
Printing
- Printing specific sheets and non-contiguous areas
- Printing embedded charts
Requirements
Familiarity with the Windows operating system
14 Hours
Testimonials (1)
well-prepared training, interesting topics
