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 Modification
- Modifying cell contents
- Inserting and removing cells
- Duplicating cell data
- Utilizing Copy and Paste functions
- Applying the fill handle
- Using the Fill command
- Generating series data via Autofill
- Duplicating formulas
- Understanding relative and absolute references
- Mixed references
- Relocating cell content
- Managing the Office Clipboard
- Using Undo, Redo, and Repeat actions
Workbook Management
- Managing Excel files
- Structuring spreadsheet workbooks
- Organizing workbook windows
- Saving documents to disk
- Accessing existing workbooks
Applying Functions within Formulas
- Overview of functions
- Structural components of formulas
- Defining function arguments
- Inserting functions
- Mathematical and trigonometric operations
- Statistical analysis functions
- Logical evaluation functions
- Lookup and reference tools
- Information retrieval functions
- Date and time calculations
- Text manipulation functions
Cell Formatting
- Number format customization
- Alignment adjustments
- Font styling options
- Applying borders
- Cell shading
- Applying predefined styles
- Configuring conditional formatting
- Using the Format Painter
- Adjusting column widths and row heights
- AutoFit settings
- AutoFormat application
- Clearing cell formatting
Handling Graphic Objects
- Introduction to graphical elements
- Using the Drawing Toolbar
- Creating drawn shapes
- Embedding images
- Managing graphic properties
- Adjusting the stacking order of objects
Chart Development
- Basics of charting
- Utilizing the Chart Wizard
- Linking data sources to charts
- Configuring data series and markers
- Customizing chart components
- Selecting chart types
- Chart configuration options
- Adding titles
- Axis management
- Gridline settings
- Legend customization
- Data label placement
- Displaying data tables
Printing Documents
- Print workflows
- Page Setup dialog options
- Reviewing print previews
- Printing dialog configurations
Data List Management
- Understanding data lists
- Converting ranges to tables
- Creating application forms
- Applying AutoFilter
- Using Advanced Filters
- Data sorting techniques
- Calculating subtotals
- Database-specific functions
PivotTable Creation
- Building and editing PivotTables
- Implementing calculated fields and members
Requirements
Proficiency 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,
