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 Microsoft Excel application
- Overview of the main window interface and layout
- Managing workbooks and individual worksheets
Data Entry and Cell Modification
Data Formatting
- Customizing the display of various data types and calculation outcomes, such as dates, currency, percentages, or fractions
- Configuring cell borders and background colors
- Formatting row and column headers
- Applying predefined and custom Styles
Navigation
- Efficiently moving through large or complex sheets
- Working simultaneously across multiple worksheets or workbooks
Duplication and Data Transfer
- Selecting specific cell ranges
- Relocating data between locations
- Advanced insertion techniques
- Using AutoFill to populate data series, such as sequential numbers or business days
Formulas, Cell Addresses, and Named Ranges
- Creating, editing, and duplicating formulas
- Identifying and resolving circular references
- Implementing conditional formatting rules
- Understanding different address types and their applications
- Referencing data from other worksheets or workbooks
- Defining and using named cells for easier reference
Functions
- General principles for function usage
- Commonly used functions in business scenarios
- Nesting multiple functions within a single formula
- Applying conditional logic in formulas
- Utilizing the Function Wizard (Insert Function)
Visual Elements in Spreadsheets
- Inserting and customizing AutoShapes and WordArt
- Creating static and dynamic data visualizations
Charts
- Exploring primary chart types and their ideal use cases
- Best practices for designing effective and clear charts
- Step-by-step chart creation process
- Modifying chart components and layout
- Developing custom chart types
Data Hiding and Security
- Hiding specific sheets, columns, or rows
- Protecting formulas and cell contents from view
- Locking worksheets and workbooks against modifications
- Setting password protection for workbooks prior to opening
Printing
- Printing specific sheets or non-contiguous areas
- Preparing and printing charts
Requirements
Proficiency with the Windows operating system
14 Hours
Testimonials (1)
well-prepared training, interesting topics
