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.
Duration 14 hours
Course Outline
Introduction
- Overview of the Microsoft Excel application
- Understanding the layout of the main interface
- Managing workbooks and worksheets
Data Entry and Modification in Cells
Data Formatting
- Configuring display settings for various data types and results (including dates, currency, percentages, and fractions)
- Adjusting cell borders and background colors
- Formatting row headers and column labels
- Applying and customizing styles
Navigation
- Efficiently navigating large spreadsheets
- Working simultaneously with multiple worksheets and workbooks
Copying and Moving Data
- Selecting specific cell ranges
- Transferring data between locations
- Utilizing advanced insertion options
- Auto-filling data series (such as ordinal numbers and future business days)
Formulas, References, and Named Ranges
- Creating, editing, and duplicating formulas
- Understanding and resolving circular references
- Implementing conditional formatting
- Differentiating between reference types and their applications
- Linking to other worksheets and workbooks
- Utilizing defined names for cells
Functions
- General guidelines for function usage
- Exploring commonly used functions
- Nesting functions for complex logic
- Applying conditional logic within formulas
- Using the Function Argument Checker
Visual Elements in Spreadsheets
- Incorporating AutoShapes and WordArt
- Creating static and dynamic data visualizations
Charts
- Reviewing primary chart types and their best-use scenarios
- Principles for designing effective and engaging charts
- Step-by-step chart creation
- Modifying chart components
- Developing custom chart types
Data Security and Protection
- Hiding sheets, columns, and rows
- Concealing formulas and cell content
- Locking worksheets and workbooks against edits
- Securing workbooks prior to opening
Printing
- Printing specific sheets and non-contiguous areas
- Outputting charts
Requirements
Familiarity with the Windows operating system
Testimonials (1)
well-prepared training, interesting topics
