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
- Fundamentals of the application
- Structure of the primary interface
- Managing workbooks and individual sheets
Data Entry and Modification in Cells
Data Formatting
- Configuring display formats for various data types and results (such as dates, currency, percentages, and fractions)
- Customizing cell borders and backgrounds
- Styling row and column headers
- Applying predefined Styles
Navigation
- Efficiently traversing large sheets
- Simultaneously working across multiple worksheets or workbooks
Cutting, Copying, and Moving Data
- Selecting cell ranges
- Transferring data
- Performing specialized insertions
- Using Autofill for data series (e.g., sequential numbers and next business day dates)
Formulas, Addresses, and Named Ranges
- Creating, editing, and duplicating formulas
- Identifying circular references
- Applying conditional formatting
- Understanding different address types and their application
- Referencing other worksheets and workbooks
- Utilizing named ranges
Functions
- General principles of function usage
- Commonly used functions
- Nesting functions
- Implementing conditional logic
- Using the Function Argument Wizard
Visual Elements in Spreadsheets
- Integrating AutoShapes and WordArt
- Incorporating static and dynamic data visualizations
Charts
- Key chart types and their suitable applications
- Best practices for designing effective charts
- Building charts
- Modifying chart components
- Creating custom chart types
Data Concealment and Security
- Hiding specific sheets, columns, or rows
- Concealing formulas and cell contents
- Locking worksheets and workbooks against modifications
- Securing workbooks prior to opening
Printing
- Printing full sheets or specific non-contiguous areas
- Outputting charts
Requirements
Familiarity with the Windows operating system
14 Hours
Testimonials (1)
well-prepared training, interesting topics
