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
- Utilizing copy and paste functionality
- Leveraging the fill handle
- Applying the fill command
- Generating series data and using Autofill
- Replicating formulas
- Understanding relative versus absolute references
- Applying mixed references
- Transferring cell positions
- Using the Office Clipboard
- Managing undo, redo, and repeat actions
Managing Workbooks
- Handling Excel files
- Structuring workbook spreadsheets
- Organizing Windows workbooks
- Saving documents to storage
- Opening existing workbooks
Implementing Functions in Formulas
- Overview of functions
- Formula construction principles
- Defining function arguments
- Inserting functions
- Mathematical and trigonometric operations
- Statistical analysis functions
- Logical evaluation functions
- Lookup and reference tools
- Data information functions
- Date and time calculations
- Text manipulation functions
Cell Formatting
- Numeric formatting options
- Alignment settings
- Font styling
- Applying borders
- Cell shading
- Style application
- Conditional formatting rules
- Using the format painter
- Optimizing column width and row height
- Auto-fit adjustments
- Applying AutoFormat
- Clearing cell formatting
Handling Graphic Objects
- Graphic elements overview
- Drawing toolbar features
- Creating drawing objects
- Embedding images
- Editing graphics
- Managing object stacking order
Building Charts
- Chart fundamentals
- Using the chart wizard
- Linking data sheets to charts
- Data series and data points
- Chart component configuration
- Selecting chart types
- Chart configuration options
- Titles
- Axis management
- Gridline settings
- Legend placement
- Data label customization
- Data table display
Printing Operations
- Print settings
- Page Setup dialog options
- Previewing printed pages
- Print dialog box controls
Utilizing Data Lists
- List management basics
- Converting ranges to lists
- Creating application forms
- Using AutoFilter
- Advanced filtering techniques
- Data sorting
- Generating subtotals
- Database-specific functions
PivotTables
- Building and adjusting PivotTables
- Defining calculated fields and members
Requirements
Proficiency with the Windows operating system
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,
