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
- Insertion and deletion of cells
- Duplicating cell data
- Utilising Copy and Paste functionalities
- Application of the fill handle
- Executing fill operations
- Managing series data and using Autofill
- Duplicating formula logic
- Understanding relative and absolute references
- Applying mixed references
- Relocating cells
- Leveraging the Office Clipboard
- Undoing, redoing, and repeating actions
Managing Workbooks
- Understanding Excel file structures
- Handling spreadsheet workbooks
- Navigating Windows-based workbooks
- Saving documents to local storage
- Accessing existing workbook files
Applying Functions in Formulas
- Overview of available functions
- Understanding formula structure
- Defining function arguments
- Inserting functions into cells
- Mathematical and trigonometric operations
- Employing statistical functions
- Using logical operators
- Search and reference techniques
- Utilising information functions
- Managing date and time data
- Processing text data
Cell Formatting
- Numerical formatting options
- Text alignment adjustments
- Font styling and modification
- Applying borders
- Cell shading and background colours
- Using pre-defined styles
- Implementing conditional formatting rules
- Using the Format Painter
- Adjusting column width and row height
- Utilising AutoFit
- Applying AutoFormat features
- Clearing existing formatting
Handling Graphic Objects
- Introduction to graphical elements
- Using the Drawing Toolbar
- Creating drawing objects
- Inserting image files
- Manipulating graphics
- Managing the stacking order of objects
Chart Creation
- Basics of charting
- Using the Chart Wizard
- Linking charts to data sheets
- Configuring data series and points
- Modifying chart components
- Selecting appropriate chart types
- Adjusting chart options
- Adding and editing titles
- Configuring axes
- Customising gridlines
- Managing legends
- Inserting data labels
- Displaying data tables
Print Management
- Printing processes
- Configuring Page Setup settings
- Reviewing print preview
- Using the print dialog interface
Utilising Lists
- Managing data lists
- Converting ranges to lists
- Creating application forms
- Applying AutoFilter
- Using advanced filtering criteria
- Data sorting techniques
- Generating subtotals
- Functions for database operations
Pivot Tables
- Building and updating PivotTables
- Creating calculated fields and members
Requirements
Familiarity with the Windows operating environment
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,
