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
- Adding and removing cells
- Duplicating cell data
- Utilising Copy and Paste features
- Employing the fill handle
- Applying the Fill command
- Using Series data and the Autofill option
- Replicating formulas
- Understanding relative and absolute references
- Applying mixed references
- Relocating cell content
- Using the Office Clipboard
- Undoing, repeating, and redone actions
Managing Workbooks
- Handling Excel files
- Organising spreadsheet workbooks
- Interfacing with Windows workbooks
- Storing files to disk
- Accessing existing workbooks
Utilising Functions in Formulas
- Overview of functions
- Understanding construction features
- Explaining function arguments
- Inputting functions
- Applying Math and Trigonometry functions
- Using Statistical functions
- Applying Logical functions
- Utilising Search and Address functions
- Employing Information functions
- Applying Date and Time functions
- Using Text functions
Formatting Cells
- Number formatting options
- Alignment settings
- Font styling
- Border configuration
- Cell shading
- Applying cell styles
- Implementing conditional formatting
- Using the Format Painter
- Adjusting column width and row height
- Applying Auto-fit
- Using AutoFormat
- Clearing cell formatting
Handling Graphic Objects
- Managing graphical elements
- Using the Drawing Toolbar
- Creating drawing objects
- Inserting images
- Manipulating graphics
- Setting the order of graphic objects
Generating Charts
- Chart fundamentals
- Using the Chart Wizard
- Linking data sheets to charts
- Defining data series and points
- Configuring chart elements
- Selecting chart types
- Chart configuration options
- Adding titles
- Configuring axes
- Applying gridlines
- Setting up legends
- Adding data labels
- Inserting data tables
Printing
- Print management
- Configuring Page Setup
- Reviewing Print Preview
- Using the Print dialog box
Utilising Lists
- Data lists
- Converting list ranges
- Creating application forms
- Applying AutoFilter
- Using Advanced Filters
- Sorting data
- Generating subtotals
- Database functions
PivotTables
- Creating and adjusting PivotTables
- Building calculated fields and members
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,
