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.
Duration 14 hours
Course Outline
Editing Spreadsheets
- Modifying cell contents
- Inserting and removing cells
- Duplicating cells
- Utilising Copy and Paste operations
- Employing the fill handle
- Applying the Fill command
- Managing series data and the Autofill feature
- Duplicating formulas
- Understanding relative and absolute references
- Mixed reference applications
- Transferring cell data
- Using the Office Clipboard
- Recalling, repeating, and undoing actions
Managing Workbooks
- Excel file formats
- Spreadsheet workbooks
- Windows workbook integration
- Saving files to storage
- Accessing existing workbooks
Applying Functions within Formulas
- Overview of functions
- Construction principles
- Defining function arguments
- Inputting functions
- 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
- Border configuration
- Cell shading
- Cell styles
- Conditional formatting rules
- Using the Format Painter
- Adjusting column width and row height
- AutoFit features
- Applying AutoFormat
- Clearing cell formatting
Handling Graphic Objects
- Overview of graphical elements
- Using the Drawing toolbar
- Creating drawing objects
- Embedding images
- Manipulating graphics
- Managing object layer order
Chart Creation
- Introduction to charts
- Using the Chart Wizard
- Data sheet relationships
- Data series and data points
- Chart components
- Chart types
- Chart options
- Chart titles
- Axes configuration
- Gridline settings
- Legend placement
- Data labels
- Data tables
Printing
- Print workflows
- Page Setup dialog
- Print Preview
- Print dialog box options
Utilising Lists
- Working with lists
- Converting ranges to lists
- Using form applications
- AutoFilter functionality
- Advanced filtering
- Sorting data
- Generating subtotals
- Database-specific functions
PivotTables
- Creating and modifying PivotTables
- Calculated fields and calculated items
Requirements
Proficiency with the Windows operating system
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customised Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from £3200 + VAT*
Contact us for an exact quote and to hear our latest promotions
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,
