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
- Basic information about the program
- Structure of the main window
- Operations on workbooks (notebooks) and sheets
Entering and modifying data in worksheet cells
Formatting data
- Defining how different types of data and calculation results are displayed (e.g., dates, amounts, percentages, or fractions)
- Setting cell borders and backgrounds
- Formatting row and column headers
- Using Styles
Navigation
- Navigating through large worksheets
- Working concurrently on multiple worksheets or workbooks
Copying and moving data
- Selecting areas (cell ranges)
- Moving data
- Special paste
- Autofilling data sections (series), such as sequential numbers and dates for the next working day
Formulas, addresses, and cell names
- Creating, modifying, and copying formulas
- Circular references
- Conditional formatting
- Address types and their uses
- References to other worksheets and workbooks
- Using cell names
Functions
- General rules for using functions
- Frequently used functions
- Nested functions
- Using conditional logic
- The Function Wizard
Graphics in spreadsheets
- AutoShapes and WordArt
- Static and dynamic data visualisations
Charts
- Major chart types and their applications
- General principles for creating impactful charts
- Creating charts
- Chart components and how to modify them
- Creating custom chart types
Hiding and Data Protection
- Hiding sheets, columns, and rows
- Hiding formulas and cell entries
- Protecting worksheets and workbooks from changes
- Protecting workbooks before opening
Printing
- Printing sheets and discontinuous areas
- Printing charts
Requirements
Knowledge of Windows
14 Hours
Testimonials (1)
well-prepared training, interesting topics
