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 program capabilities
- Understanding the main window layout
- Managing workbooks and worksheets
Entering and Modifying Data in Cells
Data Formatting
- Configuring display formats for various data types and results (e.g., dates, currency, percentages, and fractions)
- Customizing cell borders and background colors
- Styling row and column headers
- Applying Excel Styles
Navigation
- Efficiently navigating through large worksheets
- Working simultaneously with multiple worksheets and workbooks
Copying and Moving Data
- Selecting specific cell ranges
- Transferring data
- Advanced insertion options
- Using Autofill for data series (e.g., sequential numbers and business dates)
Formulas, Addresses, and Cell Names
- Creating, editing, and duplicating formulas
- Avoiding circular references
- Implementing conditional formatting
- Understanding address types and their applications
- Referencing external worksheets and workbooks
- Utilizing defined cell names
Functions
- Core principles of function usage
- Commonly utilized functions
- Nesting functions
- Applying conditional logic
- Using the Function Wizard
Graphics in Spreadsheets
- Inserting AutoShapes and WordArt
- Embedding static and dynamic images
Charts
- Key chart types and their use cases
- Best practices for creating impactful visuals
- Chart creation process
- Modifying chart components
- Creating custom chart types
Data Hiding and Protection
- Concealing sheets, columns, and rows
- Hiding formulas and cell content
- Securing worksheets and workbooks against edits
- Setting protection prompts before opening workbooks
Printing
- Printing specific sheets or non-contiguous areas
- Outputting charts
Requirements
Familiarity with the Windows operating system.
14 Hours
Testimonials (1)
well-prepared training, interesting topics
