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
Editing spreadsheets
- Modifying cell contents
- Inserting and removing cells
- Duplicating cells
- Using copy and paste commands
- Utilizing the fill handle
- Applying the fill command
- Managing series data and the Autofill option
- Copying formulas
- Understanding relative and absolute references
- Mixed references
- Relocating cells
- Using the Office Clipboard
- Recalling, repeating, and redoing operations
Managing workbooks
- Excel file types
- Workbook structure
- Workbook windows
- Saving files to disk
- Opening existing workbooks
Applying functions within formulas
- Function basics
- Construction principles
- Function arguments
- Inserting functions
- Mathematical and trigonometric functions
- Statistical functions
- Logical functions
- Search and reference functions
- Information functions
- Date and time functions
- Text functions
Cell formatting
- Number formatting
- Alignment options
- Font styling
- Adding borders
- Cell shading
- Applying styles
- Conditional formatting
- Using the Format Painter
- Adjusting column width and row height
- Auto-fit settings
- Applying AutoFormat
- Clearing cell formatting
Handling graphic objects
- Types of graphical objects
- The Drawing Toolbar
- Creating drawing objects
- Inserting images
- Manipulating graphics
- Setting the order of graphic objects
Chart creation
- Chart fundamentals
- Using the Chart Wizard
- Linking data sheets to graphs
- Data series and data points
- Chart elements
- Chart types
- Chart configuration options
- Titles
- Axes
- Gridlines
- Legends
- Data labels
- Data tables
Printing
- Print processes
- Page Setup dialog
- Print preview
- Printing dialog box
Utilizing lists
- List management
- Converting ranges to lists
- Using application forms
- AutoFilter
- Advanced filtering
- Sorting data
- Subtotals
- Functions for database operations
PivotTables
- Creating and modifying PivotTables
- Calculated fields and members
Requirements
Familiarity with Windows
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,
