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
- Duplicating cell data
- Utilizing Copy and Paste functionality
- Using the fill handle
- Applying the Fill command
- Handling series data and the Autofill option
- Duplicating formulas
- Understanding relative and absolute references
- Managing mixed references
- Relocating cell content
- Utilizing the Office Clipboard
- Recalling, repeating, and redoing actions
Managing Workbooks
- Excel file structures
- Spreadsheet workbook management
- Windows workbook integration
- Saving files to local storage
- Opening existing workbooks
Applying Functions in Formulas
- Overview of functions
- Formula construction techniques
- Understanding function arguments
- Inserting functions
- Mathematical and trigonometric functions
- Statistical analysis functions
- Logical operations
- Search and reference functions
- Information retrieval functions
- Date and time manipulation
- Text processing functions
Cell Formatting
- Number formatting options
- Alignment settings
- Font styling
- Border application
- Cell shading techniques
- Applying styles
- Conditional formatting rules
- Using the Format Painter
- Adjusting column width and row height
- Auto-fit features
- AutoFormat application
- Clearing cell formatting
Manipulating Graphic Objects
- Handling graphical elements
- Using the Drawing Toolbar
- Creating drawing objects
- Inserting images
- Working with graphics
- Managing the order of graphic objects
Chart Creation
- Introduction to charts
- Using the Chart Wizard
- Linking chart data sheets
- Managing data series and points
- Customizing chart elements
- Selecting appropriate chart types
- Configuring chart options
- Adding titles
- Configuring axes
- Adjusting grid lines
- Modifying legends
- Inserting data labels
- Displaying data tables
Printing
- Printing procedures
- Accessing the Page Setup dialog
- Reviewing print previews
- Using the printing dialog box
Utilizing Lists
- Managing lists
- Converting list ranges
- Creating application forms
- Applying AutoFilter
- Using advanced filters
- Sorting data
- Generating subtotals
- Functions for database operations
PivotTables
- Creating and modifying PivotTables
- Defining calculated fields and members
Requirements
Familiarity with the Windows operating environment
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,
