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
- Essential overview of the application
- Understanding the main window interface
- Managing workbooks and worksheets
Data Entry and Cell Modification
Data Formatting
- Customizing the display of various data types and results, such as dates, currency, percentages, and fractions
- Adjusting cell borders and background colors
- Styling row and column headers
- Applying predefined Styles
Navigation
- Efficiently moving through large datasets
- Simultaneously working across multiple worksheets and workbooks
Copying and Moving Data
- Selecting specific cell ranges
- Transferring data
- Advanced insertion techniques
- Using Autofill for data series, such as sequence numbers and business days
Formulas, Addresses, and Named Cells
- Creating, editing, and duplicating formulas
- Identifying circular references
- Implementing conditional formatting
- Distinguishing between address types and their applications
- Referencing other worksheets and external workbooks
- Utilizing defined cell names
Functions
- Basic principles of function usage
- Exploring commonly used functions
- Working with nested functions
- Applying conditional logic
- Utilizing the Function Wizard
Visual Elements in Spreadsheets
- Incorporating AutoShapes and WordArt
- Creating static and dynamic data visualizations
Charts
- Exploring primary chart types and their best use cases
- Best practices for designing impactful charts
- Step-by-step chart creation
- Modifying graph components
- Developing custom chart styles
Data Concealment and Security
- Hiding sheets, columns, and rows
- Concealing formulas and cell values
- Locking worksheets and workbooks to prevent edits
- Securing workbooks with password protection prior to opening
Printing
- Printing specific sheets and non-contiguous areas
- Outputting charts
Requirements
Familiarity with the Windows operating system
14 Hours
Testimonials (1)
well-prepared training, interesting topics
