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 program
- Layout of the main interface window
- Managing workbooks and worksheets
Inputting and Editing Data in Cells
Data Formatting
- Configuring the display of various data types and calculation outputs (e.g., dates, currency, percentages, or fractions)
- Adjusting cell borders and background fills
- Styling row and column headers
- Applying built-in styles
Navigation
- Scrolling and moving within large spreadsheets
- Simultaneous management of multiple worksheets and workbooks
Duplicating and Relocating Data
- Selecting specific ranges (cells)
- Transferring data
- Inserting specialized elements
- Auto-filling data sequences (e.g., ordinal numbers or consecutive business days)
Formulas, References, and Named Ranges
- Building, editing, and duplicating formulas
- Understanding circular references
- Implementing conditional formatting
- Types of cell references and their applications
- Linking to other worksheets and workbooks
- Utilizing defined names for cells
Functions
- General syntax and usage rules for functions
- Commonly used functions
- Nesting functions within formulas
- Applying conditional logic
- Using the Function Wizard
Visual Elements in Spreadsheets
- Inserting AutoShapes and WordArt
- Creating static and dynamic data visualizations
Charts
- Primary chart types and their respective uses
- Best practices for designing impactful charts
- Chart creation workflow
- Modifying chart components
- Customizing chart types
Concealing and Securing Data
- Concealing specific sheets, columns, or rows
- Protecting formulas and cell contents
- Locking worksheets and workbooks against edits
- Securing workbooks prior to opening
Printing
- Printing specific sheets or non-contiguous ranges
- Outputting charts
Requirements
Familiarity with the Windows operating system
14 Hours
Testimonials (1)
well-prepared training, interesting topics
