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 the Excel application
- Understanding the main interface layout
- Managing workbooks and worksheets
Entering and Modifying Data in Cells
Data Formatting
- Customizing the display of various data types and calculation results (e.g., dates, currency amounts, percentages, or fractions)
- Setting cell borders and background colors
- Formatting row and column headers
- Applying built-in Styles
Navigation
- Efficiently moving through large worksheets
- Working simultaneously on multiple worksheets and workbooks
Copying and Moving Data
- Selecting cell ranges
- Moving data between locations
- Using Paste Special options
- Utilizing the AutoFill feature for data series (e.g., ordinals and sequential dates)
Formulas, Addresses, and Cell Names
- Creating, modifying, and copying formulas
- Understanding and resolving circular references
- Applying Conditional Formatting
- Understanding relative and absolute address types
- Referencing other worksheets and workbooks
- Defining and using named cells
Functions
- General rules for using functions
- Commonly used functions
- Nesting functions within other functions
- Using logical conditions
- Utilizing the Function Wizard
Graphics in Spreadsheets
- Using AutoShapes and WordArt
- Working with static and dynamic visual elements
Charts
- Major chart types and their appropriate applications
- Key principles for designing effective charts
- Creating charts from scratch
- Modifying chart components
- Creating custom chart types
Hiding and Data Protection
- Hiding sheets, columns, and rows
- Hiding formulas and cell contents
- Protecting worksheets and workbooks from modification
- Securing workbooks with passwords upon opening
Printing
- Printing worksheets and non-contiguous ranges
- Printing charts
Requirements
Familiarity with the Windows operating system
14 Hours
Testimonials (1)
well-prepared training, interesting topics
