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
- Replicating cells
- Using Copy and Paste commands
- Utilizing the fill handle
- Applying the Fill command
- Managing series data and Autofill options
- Copying formulas
- Understanding relative and absolute references
- Applying mixed references
- Relocating cells
- Managing the Office Clipboard
- Recalling, repeating, and redoing operations
Managing Workbooks
- Handling Excel files
- Managing spreadsheet workbooks
- Working with Windows workbooks
- Saving files to disk
- Opening existing workbooks
Integrating Functions in Formulas
- Overview of functions
- Formula construction features
- Understanding function arguments
- Inserting functions
- Mathematical and trigonometric functions
- Statistical functions
- Logical functions
- Lookup and reference functions
- Information functions
- Date and time functions
- Text functions
Cell Formatting
- Number formatting
- Text alignment
- Font styling
- Applying borders
- Cell shading
- Applying styles
- Conditional formatting
- Using the Format Painter
- Adjusting column width and row height
- Auto-fit features
- Applying AutoFormat
- Clearing cell formatting
Working with Graphic Objects
- Overview of graphical objects
- Using the Drawing Toolbar
- Creating drawing objects
- Inserting images
- Managing graphics
- Setting the order of graphic objects
Chart Creation
- Introduction to charts
- Using the Chart Wizard
- Linking data sheets to graphs
- Managing data series and points
- Configuring chart elements
- Selecting chart types
- Chart options
- Adding titles
- Configuring axes
- Grid lines
- Legends
- Data labels
- Data tables
Printing
- Print processes
- Page Setup dialog
- Print preview
- Printing dialog box
Utilizing Lists
- Working with lists
- Converting list ranges
- Using 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,
