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
- Using Copy and Paste commands
- Leveraging the fill handle
- Utilizing the Fill command
- Generating series data via Autofill
- Duplicating formulas
- Understanding relative and absolute references
- Applying mixed references
- Relocating cells
- Using the Office Clipboard
- Recalling, repeating, and redoing actions
Managing Workbooks
- Excel file types
- Spreadsheet workbooks
- Windows-based workbooks
- Saving files to storage
- Accessing existing workbooks
Utilizing Functions in Formulas
- Overview of functions
- Formula construction features
- Understanding 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 applications
- Cell shading
- Applying styles
- Conditional formatting
- Using the Format Painter
- Adjusting column width and row height
- AutoFit features
- Applying AutoFormat
- Clearing formatting from cells
Working with Graphic Objects
- Overview of graphical objects
- Drawing toolbar usage
- Creating drawing objects
- Image insertion
- Manipulating graphics
- Adjusting the layer order of graphic objects
Chart Creation
- Introduction to charts
- Using the chart wizard
- Connecting data sheets to graphs
- Managing data series and points
- Chart components
- Different chart types
- Chart options configuration
- Titles
- Axes
- Gridlines
- Legends
- Data labels
- Data tables
Printing
- Print operations
- Page Setup dialog
- Print preview
- Print dialog box
Utilizing Lists
- Working with lists
- Converting list ranges
- Application forms
- AutoFilter
- Advanced filtering
- Sorting data
- Generating subtotals
- Database functions
PivotTables
- Creating and adjusting PivotTables
- Calculated fields and members
Requirements
Proficiency 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,
