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 content
- Insertion and deletion of cells
- Duplicating cells
- Utilizing Copy and Paste operations
- Leveraging the fill handle
- Applying the Fill command
- Managing series data and the Autofill feature
- Duplicating formulas
- Understanding relative and absolute references
- Implementing mixed references
- Translocating cells
- Utilizing the Office Clipboard
- Managing undo, redo, and operation repetition
Workbook Management
- Excel file structures
- Spreadsheet workbook architecture
- Managing Windows workbooks
- Saving files to local storage
- Accessing existing workbooks
Function Application in Formulas
- Overview of functions
- Structural attributes of functions
- Function parameters and arguments
- Inputting functions
- Mathematical and trigonometric functions
- Statistical analysis functions
- Logical evaluation functions
- Search and reference utilities
- Information verification functions
- Date and time calculations
- Text manipulation functions
Cell Formatting
- Numeric formatting standards
- Alignment adjustments
- Font customization
- Border styling
- Cell shading and background fills
- Application of styles
- Conditional formatting rules
- Using the Format Painter
- Adjusting column width and row height
- Auto-fit mechanisms
- AutoFormat features
- Clearing existing cell formatting
Handling Graphic Objects
- Overview of graphical elements
- Accessing the Drawing Toolbar
- Creating drawing objects
- Image insertion techniques
- Managing graphic interactions
- Setting layer order for graphic objects
Chart Creation
- Fundamentals of charts
- Utilizing the Chart Wizard
- Data source and chart relationship mapping
- Data series and point configuration
- Essential chart components
- Selection of chart types
- Chart configuration options
- Title placement and editing
- Axis management
- Grid line customization
- Legend integration
- Data label application
- Data table inclusion
Printing Processes
- Basic printing procedures
- Page Setup dialog configurations
- Print preview functionality
- Print dialog box options
Data List Utilization
- Concepts of data lists
- Converting list ranges
- Form application techniques
- AutoFilter usage
- Advanced filtering criteria
- Data sorting algorithms
- Subtotal generation
- Database-specific functions
PivotTable Implementation
- Constructing and modifying PivotTables
- Calculated fields and member definitions
Requirements
Familiarity with 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,
