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
Sp Spreadsheet Editing
- Modifying cell contents
- Inserting and removing cells
- Duplicating cells
- Utilizing Copy and Paste commands
- Using the fill handle
- Applying the Fill command
- Working with series data and the Autofill option
- Duplicating formulas
- Understanding relative and absolute references
- Handling mixed references
- Relocating cells
- Using the Office Clipboard
- Recalling, repeating, and redoing actions
Managing Workbooks
- Excel file structures
- Spreadsheet workbook components
- Windows workbook integration
- Saving files to disk
- Opening existing workbooks
Applying Functions in Formulas
- Overview of functions
- Formula construction principles
- Understanding function arguments
- Entering 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 settings
- Cell shading
- Cell styles
- Conditional formatting
- Using the Format Painter
- Adjusting column width and row height
- AutoFit features
- AutoFormat application
- Clearing cell formatting
Handling Graphic Objects
- Introduction to graphical objects
- Drawing Toolbar usage
- Creating drawing objects
- Inserting images
- Manipulating graphics
- Managing the stacking order of graphic objects
Chart Creation
- Basics of charts
- Using the Chart Wizard
- Linking charts to data sheets
- Data series and data points
- Chart components
- Selecting chart types
- Chart configuration options
- Adding titles
- Configuring axes
- Gridline settings
- Legend customization
- Data labels
- Data tables
Printing
- General printing procedures
- Page Setup dialog
- Print Preview
- Print dialog box
Utilizing Lists
- Working with lists
- Converting list ranges
- Application forms
- AutoFilter
- Advanced filters
- Sorting data
- Generating subtotals
- Functions for database operations
PivotTables
- Creating and modifying PivotTables
- 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,
