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 features
- Understanding the main window layout
- Managing workbooks and worksheets
Data Entry and Modification in Worksheet Cells
Data Formatting
- Customizing the display of various data types and calculation outcomes (e.g., dates, currency, percentages, or fractions)
- Configuring cell borders and background colors
- Styling row and column headers
- Applying predefined Styles
Navigation
- Efficiently navigating large worksheets
- Concurrent work across multiple worksheets and workbooks
Copying and Moving Data
- Selecting cell ranges and areas
- Transferring data between locations
- Advanced insertion techniques
- Autofilling data series (e.g., sequential numbers or future business dates)
Formulas, Addresses, and Named Ranges
- Creating, editing, and duplicating formulas
- Understanding circular references
- Implementing conditional formatting
- Exploring address types and their applications
- Referencing other worksheets and workbooks
- Utilizing named cell ranges
Functions
- General guidelines for function usage
- Commonly used functions
- Nesting functions
- Working with conditional logic
- Using the Function Wizard
Graphics in Spreadsheets
- Using AutoShapes and WordArt
- Creating static and dynamic data visualizations
Charts
- Key chart types and their use cases
- Principles for designing impactful charts
- Chart creation process
- Modifying graph components
- Developing custom chart styles
Data Hiding and Protection
- Concealing sheets, columns, and rows
- Hiding formulas and cell contents
- Securing worksheets and workbooks against edits
- Setting open-protected workbooks
Printing
- Printing entire sheets or specific non-contiguous areas
- Outputting charts
Requirements
Proficiency with the Windows operating system
14 Hours
Testimonials (1)
well-prepared training, interesting topics
