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 program
- Overview of the main window layout
- Managing workbooks and worksheets
Inputting and editing cell data
Data formatting
- Setting display formats for various data types and results (such as dates, currencies, percentages, or fractions)
- Customizing cell borders and background colors
- Styling row and column headers
- Applying cell styles
Navigation
- Efficiently navigating through extensive sheets
- Simultaneously working with multiple worksheets or workbooks
Copying and moving data
- Selecting specific areas (cell ranges)
- Transferring data
- Advanced insertion options
- Auto-filling data series (e.g., sequential numbers and future work dates)
Formulas, addresses, and named ranges
- Creating, modifying, and replicating formulas
- Understanding circular references
- Applying conditional formatting
- Differentiating address types and their applications
- Referencing other worksheets and workbooks
- Utilizing defined cell names
Functions
- General guidelines for using functions
- Commonly used functions
- Nesting functions
- Implementing conditional logic
- Using the Function Wizard
Visual elements in spreadsheets
- Working with AutoShapes and WordArt
- Creating static and dynamic data visualizations
Charts
- Key chart types and their use cases
- Best practices for designing effective charts
- Chart creation process
- Adjusting chart components
- Customizing chart types
Data concealment and protection
- Concealing sheets, columns, and rows
- Protecting formulas and cell contents
- Securing worksheets and workbooks against modifications
- Setting password protection before opening workbooks
Printing
- Printing specific sheets or non-contiguous areas
- Outputting charts
Requirements
Familiarity with the Windows operating system
14 Hours
Testimonials (1)
well-prepared training, interesting topics
