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's key features
- Structure of the main interface
- Managing workbooks and worksheets
Entering and Modifying Data in Cells
Formatting Data
- Configuring display formats for various data types and calculation outcomes (e.g., dates, currency, percentages, or fractions)
- Customizing cell borders and background colors
- Formatting row and column headers
- Applying and customizing styles
Navigation
- Efficiently navigating through large spreadsheets
- Working simultaneously across multiple worksheets and workbooks
Copying and Moving Data
- Selecting ranges of cells
- Moving data between locations
- Utilizing special paste options
- Using the autofill feature for data series (such as sequential numbers and next working days)
Formulas, Cell References, and Names
- Creating, modifying, and copying formulas
- Understanding and resolving circular references
- Applying conditional formatting
- Types of cell references and their applications
- Referencing data in other worksheets and workbooks
- Using defined cell names
Functions
- General principles for using functions
- Commonly used functions
- Utilizing nested functions
- Implementing IF conditions
- Using the Function Wizard
Graphics in Spreadsheets
- Adding AutoShapes and WordArt
- Inserting static and dynamic images
Charts
- Key chart types and their appropriate uses
- Best practices for creating effective charts
- Creating charts from data
- Customizing chart components and elements
- Creating custom chart types
Hiding and Protecting Data
- Hiding worksheets, columns, and rows
- Hiding formulas and cell contents
- Preventing unauthorized changes to worksheets and workbooks
- Securing workbooks with passwords prior to opening
Printing
- Printing worksheets and non-contiguous data ranges
- Printing charts
Requirements
Basic knowledge of the Windows operating system.
14 Hours
Testimonials (1)
well-prepared training, interesting topics
