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
Modifying Spreadsheets
- Modifying the contents of a cell
- Adding and removing cells
- Duplicating cells
- Duplicating and Pasting commands
- Utilising the fill handle
- Applying the fill command
- Series data and the Autofill feature
- Duplicating formulas
- Relative references and absolute references
- Mixed references
- Relocating cells
- The Office Clipboard
- Recalling, repeating, and redoing actions
Managing Workbooks
- Excel file formats
- Spreadsheets and workbooks
- Windows workbook interface
- Saving files to disk
- Opening an existing workbook
Applying Functions in Formulas
- Function overview
- Syntax features
- Function arguments
- Inserting a Function
- Mathematical and trigonometric functions
- Statistical functions
- Logical functions
- Lookup and reference functions
- Information functions
- Date and Time functions
- Text functions
Cell Formatting
- Number formatting
- Alignment options
- Font styling
- Cell borders
- Cell shading
- Styles
- Conditional formatting
- Format Painter
- Optimising column width and row height
- AutoFit
- AutoFormat
- Clearing cell formatting
Handling Graphic Objects
- Overview of graphical objects
- Drawing Toolbar
- Creating drawing objects
- Embedding images
- Manipulating graphics
- Ordering graphic objects
Generating Charts
- Introduction to charts
- Chart wizard
- Chart data source
- Data series and data points
- Chart components
- Chart varieties
- Chart options
- Titles
- Axes
- Gridlines
- Legend
- Data labels
- Data tables
Printing
- Printing process
- Page Setup dialog
- Print preview
- Printing dialog box
Utilising Lists
- Introduction to lists
- Converting list ranges
- Application forms
- AutoFilter
- Advanced filtering
- Sorting
- Subtotals
- Database functions
Pivot Tables
- Creating and modifying PivotTables
- Calculated fields and calculated members
Requirements
Familiarity with the Windows operating system
14 Hours
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized 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 2600 € + 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,
