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
Spreadsheet Editing
- Modifying cell contents
- Inserting and removing cells
- Duplicating cells
- Executing Copy and Paste operations
- Utilizing the fill handle
- Applying the Fill command
- Managing series data and Autofill options
- Duplicating formulas
- Understanding relative and absolute references
- Using mixed references
- Transposing cell positions
- Leveraging the Office Clipboard
- Recalling, repeating, and undoing actions
Workbook Management
- Excel file structures
- Spreadsheet workbook architecture
- Windows workbook integration
- Saving files to disk storage
- Accessing existing workbooks
Function Application in Formulas
- Overview of functions
- Structural characteristics
- Function argument specifications
- Inputting functions
- Mathematical and trigonometric functions
- Statistical analysis functions
- Logical evaluation functions
- Lookup and reference functions
- Information retrieval functions
- Date and time calculations
- Text manipulation functions
Cell Formatting
- Numeric formatting options
- Content alignment
- Font styling
- Border configuration
- Cell shading
- Style application
- Conditional formatting rules
- Format Painter utility
- Adjusting column width and row height
- Automatic fitting
- AutoFormat features
- Clearing cell formatting
Graphic Object Integration
- Graphic element overview
- Drawing Toolbar navigation
- Creating drawing objects
- Image insertion
- Graphic manipulation techniques
- Layering and ordering graphic objects
Chart Creation
- Chart fundamentals
- Chart Wizard operation
- Data sheet relationships
- Data series and data points
- Chart components
- Chart type selection
- Chart configuration options
- Title management
- Axis settings
- Gridline management
- Legend configuration
- Data label placement
- Data table integration
Printing Procedures
- Printing basics
- Page Setup dialog configuration
- Print Preview usage
- Print dialog box options
List Utilization
- Data list concepts
- Converting ranges to lists
- Form application
- AutoFilter implementation
- Advanced filtering techniques
- Sorting operations
- Subtotal generation
- Database-oriented functions
PivotTable Application
- Generating and modifying PivotTables
- Calculated fields and members
Requirements
Proficiency in the Windows operating system
14 Hours
Testimonials (2)
Flexibility in the course delivery and the interactive approach. The trainer was open to questions, clarified doubts clearly and also considered participants suggestions during the sessions. The training was well structured and informative.
Soundarya Mohan - Mizuho Bank Europe N.V.
Course - Financial Analysis in Excel
the trainer's patience,
