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 functionality
- Utilising the Fill Handle
- Applying the Fill command
- Working with series data and the Autofill option
- Duplicating formulas
- Understanding relative and absolute cell references
- Applying mixed references
- Moving cell contents
- Using the Office Clipboard
- Undoing, redoing, and repeating operations
Managing Workbooks
- Excel file management
- Spreadsheet workbook structure
- Window management within workbooks
- Saving files to local or network storage
- Opening and reviewing existing workbooks
Applying Functions in Formulas
- Overview of Excel functions
- Building formula structures
- Understanding function arguments
- Entering functions effectively
- Mathematical and trigonometric functions
- Statistical functions
- Logical functions
- Search and reference functions
- Information functions
- Date and Time functions
- Text manipulation functions
Cell Formatting
- Number formatting
- Alignment options
- Font styling and adjustments
- Applying borders
- Shading and background colours
- Using cell styles
- Implementing conditional formatting
- Using the Format Painter
- Adjusting column widths and row heights for optimal readability
- Auto-fit techniques
- Applying AutoFormat
- Clearing cell formatting
Working with Graphic Objects
- Managing graphical elements
- Using the Drawing Toolbar
- Creating and editing drawing objects
- Inserting images
- Editing graphic properties
- Setting the layering order of graphic objects
Chart Creation
- Introduction to charts
- Using the Chart Wizard
- Linking chart data to source sheets
- Managing data series and data points
- Customising chart elements
- Selecting appropriate chart types
- Configuring chart options
- Adding and editing titles
- Configuring axes
- Managing gridlines
- Editing legends
- Adding data labels
- Displaying data tables
Printing
- Print process overview
- Configuring Page Setup settings
- Using Print Preview
- Managing print dialog boxes
Utilising Lists
- Working with Excel lists
- Converting ranges to structured lists
- Creating and using forms
- Applying AutoFilter
- Using Advanced Filters
- Sorting data
- Generating subtotals
- Using functions for database operations
PivotTables
- Creating and modifying PivotTables
- Working with 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,
