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 Techniques
- Modifying cell content
- Inserting and removing cells
- Duplicating cell data
- Utilizing Copy and Paste commands
- Applying the fill handle
- Executing the Fill command
- Managing series data with Autofill
- Duplicating formulas
- Understanding relative and absolute cell references
- Applying mixed references
- Transposing cell locations
- Leveraging the Office Clipboard
- Utilizing Recall, Redo, and Repeat operations
Workbook Management
- Managing Excel file structures
- Handling spreadsheet workbooks
- Working with Windows workbook environments
- Saving files to local storage
- Accessing existing workbooks
Formula and Function Application
- Overview of Functions
- Understanding construction features
- Defining function arguments
- Inputting functions
- Mathematical and trigonometric functions
- Statistical Functions
- Logical Functions
- Search and reference capabilities
- Information functions
- Date and Time Functions
- Text manipulation functions
Cell Formatting
- Number formatting techniques
- Alignment options
- Font styling
- Border configuration
- Cell shading
- Applying styles
- Conditional formatting rules
- Using the Format Painter
- Adjusting column width and row height
- Auto-fit settings
- AutoFormat application
- Clearing cell formatting
Integrating Graphic Objects
- Overview of graphical objects
- Using the Drawing Toolbar
- Creating drawing objects
- Inserting images
- Managing graphics
- Ordering graphic elements
Chart Development
- Chart fundamentals
- Chart Wizard usage
- Data sheet relationships in graphs
- Data series and point configuration
- Chart components
- Selecting chart types
- Chart options
- Title configuration
- Axes settings
- Grid line customization
- Legend management
- Data label placement
- Data table integration
Printing Procedures
- Printing basics
- Page Setup dialog navigation
- Print preview analysis
- Print dialog box options
Data List Utilization
- List fundamentals
- Range transformation
- Form application
- AutoFilter implementation
- Advanced filtering
- Data sorting
- Subtotal generation
- Database-specific functions
PivotTable Mastery
- PivotTable creation and modification
- Calculated fields and members
Requirements
Familiarity with the Windows operating environment
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,
