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
- Replicating cells
- Using Copy and Paste functions
- Leveraging the fill handle
- Applying the Fill command
- Utilizing series data and the Autofill option
- Duplicating formulas
- Understanding relative and absolute references
- Applying mixed references
- Transposing cells
- Using the Office Clipboard
- Undoing, repeating, and redoing actions
Managing Workbooks
- Handling Excel files
- Organizing spreadsheets within workbooks
- Working with workbook windows
- Saving files to disk
- Opening existing workbooks
Utilizing Functions in Formulas
- Overview of functions
- Syntax and structural features
- Defining function arguments
- Inputting a function
- Mathematical and trigonometric functions
- Statistical functions
- Logical functions
- Search and reference functions
- Informational functions
- Date and time functions
- Text handling functions
Cell Formatting
- Number formatting
- Text alignment
- Font styling
- Applying borders
- Shading cells
- Using styles
- Conditional formatting rules
- Using the Format Painter
- Optimizing column width and row height
- Auto-fitting dimensions
- Applying AutoFormat
- Clearing cell formatting
Handling Graphic Objects
- Types of graphical objects
- Using the Drawing Toolbar
- Creating drawing objects
- Inserting images
- Manipulating graphics
- Arranging the order of graphic objects
Creating Charts
- Introduction to charts
- Using the Chart Wizard
- Managing the chart's data sheet
- Configuring data series and points
- Chart components
- Chart types
- Chart options
- Adding titles
- Configuring axes
- Using gridlines
- Adding legends
- Data labels
- Data tables
Printing
- Printing procedures
- Page Setup dialog box
- Print preview
- Printing dialog box settings
Working with Lists
- Creating lists
- Converting ranges to lists
- Using application forms
- Applying AutoFilter
- Advanced filtering techniques
- Sorting data
- Generating subtotals
- Database functions
Pivot Tables
- Creating and modifying PivotTables
- Using 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,
