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 deleting cells
- Duplicating cells
- Using Copy and Paste commands
- Utilizing the fill handle
- The Fill command
- Series data and the Autofill option
- Duplicating formulas
- Relative and absolute references
- Mixed references
- Relocating cells
- The Office Clipboard
- Recalling, repeating, and redoing operations
Managing Workbooks
- Excel file management
- Spreadsheet workbooks
- Windows workbook integration
- Saving files to disk
- Opening existing workbooks
Applying Functions in Formulas
- Introduction to functions
- Structure of formulas
- Function arguments
- Inserting functions
- 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
- Border configuration
- Cell shading
- Styles
- Conditional formatting
- Using the Format Painter
- Optimizing column width and row height
- AutoFit settings
- AutoFormat tools
- Clearing cell formatting
Handling Graphic Objects
- Graphical elements
- Using the Drawing toolbar
- Creating drawing objects
- Inserting images
- Manipulating graphics
- Arranging the order of graphic objects
Chart Creation
- Understanding charts
- The Chart wizard
- Chart source data
- Data series and data points
- Chart components
- Varying chart types
- Chart options
- Chart titles
- Axes
- Gridlines
- Legend placement
- Data labels
- Adding data tables
Printing
- Printing process
- Page Setup dialog
- Print preview
- Printing dialog box
Leveraging Lists
- Working with lists
- Converting list ranges
- Creating form applications
- AutoFilter functionality
- Advanced filters
- Data sorting
- Subtotals
- Database functions
Pivot Tables
- Creating and modifying PivotTables
- Calculated fields and members
Requirements
Familiarity with Windows
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,