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 content
- Inserting and removing cells
- Duplicating cell data
- Utilizing Copy and Paste commands
- Applying the fill handle
- Using the Fill command
- Managing series data and the Autofill option
- Duplicating formulas
- Understanding relative and absolute references
- Mixed references
- Relocating cells
- Using the Office Clipboard
- Recalling, repeating, and redoing operations
Managing workbooks
- Excel file structures
- Spreadsheet workbook architecture
- Windows workbook management
- Saving files to local disk
- Opening existing workbooks
Utilizing functions in formulas
- Function fundamentals
- Formula construction features
- Function argument management
- Inserting functions
- Math and trigonometric functions
- Statistical functions
- Logical functions
- Search and address functions
- Information functions
- Date and Time functions
- Text functions
Cell formatting
- Number formatting
- Alignment options
- Font styling
- Applying borders
- Cell shading
- Style application
- Conditional formatting
- Using the Format Painter
- Adjusting column width and row height
- Auto-fit settings
- AutoFormat features
- Clearing cell formatting
Working with graphic objects
- Graphic object fundamentals
- Drawing Toolbar usage
- Creating drawing objects
- Inserting images
- Manipulating graphics
- Setting the order of graphic objects
Chart creation
- Chart fundamentals
- Chart wizard usage
- Relationship between data sheets and graphs
- Data series and points
- Chart elements
- Chart types
- Chart options
- Title configuration
- Axis management
- Grid lines
- Legend
- Data labels
- Data tables
Printing
- Printing procedures
- Page Setup dialog
- Print preview
- Printing dialog box
Working with lists
- List fundamentals
- Transforming list ranges
- Application forms
- AutoFilter
- Advanced filters
- Sorting data
- Generating subtotals
- Functions for database operations
PivotTables
- Creating and modifying PivotTables
- Calculated fields and calculated 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,
