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 application
- Structure of the primary interface window
- Managing workbooks and individual sheets
Inputting and adjusting data in worksheet cells
Data formatting
- Configuring the display format for various data types and calculation outcomes, such as dates, currency values, percentages, or fractions
- Defining cell borders and background colors
- Styling row and column headers
- Applying Excel Styles
Navigation
- Efficiently moving through large datasets
- Working simultaneously across multiple worksheets or workbooks
Duplicating and transferring data
- Selecting specific cell ranges
- Relocating data entries
- Special insertion techniques
- Utilizing AutoFill for data series, including ordinal numbers and consecutive business days
Formulas, cell addresses, and names
- Writing, editing, and copying formulas
- Understanding circular references
- Implementing conditional formatting
- Distinguishing between address types and their applications
- Referencing other worksheets and workbooks
- Utilizing defined cell names
Functions
- General guidelines for function usage
- Commonly used functions
- Nesting functions
- Applying conditional logic
- Using the Function Wizard
Visual elements in spreadsheets
- Incorporating AutoShapes and WordArt
- Working with static and dynamic visual data representations
Charts
- Primary chart types and their specific uses
- Best practices for creating effective charts
- Chart creation workflow
- Modifying chart components and elements
- Creating custom chart types
Data Hiding and Security
- Concealing sheets, columns, and rows
- Hiding formulas and cell contents
- Securing worksheets and workbooks against modifications
- Protecting workbooks prior to opening
Printing
- Printing specific sheets or non-contiguous areas
- Outputting charts
Requirements
Proficiency with the Windows operating system
14 Hours
Testimonials (1)
well-prepared training, interesting topics
