COURSE OVERVIEW
WE OFFER
- Instructor Led classroom based training
- Hands on Training
- Free study material
- Lab Exercises
- Unlimited lab access
- 100 % passing guarantee
or Free Re-training
COURSE INFORMATION
- Fast Track
Days: Monday-Friday
Duration: 8 days - Slow Track
Days: Saturday/Sunday Only
Duration: 8 Weeks
Study Modes:
- Classroom
- Live Virtual
MS EXCEL
For More information call us on
0208 123 7574
COURSE INSIGHT
You’ll learn all the tips you need to be an Excel power user, tricks, shortcuts, functions and formulas. This free Excel course was specifically designed for users of spreadsheets who are already carrying out professional financial analysis and financial modeling or are looking to train for a career on the Wall Street. Take the Excel Crash Course of CFI now to drive your career forward
Participants will discuss Excel tasks beyond the basics in this introductory course to Excel. After the successful completion of this workshop, participants should expect to have the requisite skills to work efficiently in an existing worksheet as well as to create new worksheets from a model and scratch.
We deliver one of the best SAP professional training programs in the industry. Specialists with extensive experience in the field conduct the lessons on this subject. The curriculum fits perfectly with professional standards with the latest industry changes.
SAP MS EXCEL COURSE OUTLINE
MODULE
- Creating a New Workbook
- Navigating in Excel
- Moving the Cell Pointer
- Using Excel Menus
- Using Excel Toolbars: Hiding, Displaying, and Moving Toolbars
- Entering Values in a Worksheet and Selecting a Cell Range
- Previewing and Printing a Worksheet
- Getting Help from the Office Assistant
- Saving a Workbook & Re-opening a saved workbook
- Creating Headers, Footers, and Page Numbers
- Adjusting Page Margins and Orientation
- Adding Print Titles and Gridlines, rows to repeat at top of each page
- Formatting Fonts & Values
- Adjusting Row Height and Column Width
- Changing Cell Alignment
- Adding Borders
- Applying Colors and Patterns
- Using the Format Painter
- Using AutoFormat
- Merging Cells, Rotating Text, and using AutoFit
- Using AutoFill
- Switching Between Sheets in a Workbook
- Inserting and Deleting Worksheets
- Renaming and Moving Worksheets
- Protecting a Workbook
- Hiding Columns, Rows and Sheets
- Splitting and Freezing a Window
- Inserting Page Breaks
- Advanced Printing Options
- Entering Date Values and using AutoComplete
- Editing, Clearing, and Replacing Cell Contents
- Cutting, Copying, and Pasting Cells
- Moving and Copying Cells with Drag and Drop
- Collecting and Pasting Multiple Items
- Using the Paste Special Command
- Inserting and Deleting Cells, Rows, and Columns
- Using Undo, Redo, and Repeat
- Checking Your Spelling
- Finding and Replacing Information
- Inserting Cell Comments
- Creating a basic Formula
- Calculating Value Totals with AutoSum
- Editing & Copying Formulas
- Fixing Errors in Your Formulas
- Formulas with Several Operators and Cell Ranges
- Sorting, Subtotaling & Filtering Data
- Copy & Paste Filtered Records
- Using Data Validation
- Creating a Chart
- Moving and Resizing a Chart
- Formatting and Editing Objects in a Chart
- Changing a Chart’s Source Data
- Changing a Chart Type and Working with Pie Charts
- Adding Titles, Gridlines, and a Data Table
- Formatting a Data Series and Chart Axis
- Annotating a Chart
- Working with 3-D Charts
- Selecting and Saving a Custom Chart
- Using Fill Effects
- Mapping Data
- Modifying a Map
- Creating a PivotTable
- Specifying the Data a PivotTable Analyzes
- Changing a PivotTable’s Calculation
- Selecting What Appears in a PivotTable
- Grouping Dates in a PivotTable
- Updating a PivotTable
- Formatting and Charting a PivotTable
- Recording a Macro
- Playing a Macro and Assigning a Macro a Shortcut Key
- Adding a Macro to a Toolbar
- Inserting an Excel Worksheet into a Word Document
- Modifying an Inserted Excel Worksheet
- Inserting a Linked Excel Chart in a Word Document
- Inserting a Graphic into a Worksheet
LOOKING FOR A
2-12 MONTHS
TRAINING?
CHOOSE
SAP MS EXCEL
SKILLS GAINED
- Advanced Formulas.
- Tables & Formatting.
- Conditional Formatting.
- Advanced Charting.
- Pivot tables & Pivot Reporting.
- VBA & Macros.
- Using Excel Productively.
- Data Tables, Simulations & Solver.
Dates And Prices
| Start Date | Timing | Days | Duration | Mode Of Training | Request Price/Future Dates |
|---|---|---|---|---|---|
| 01.07.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 08.07.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 10.07.2024 | 10:00 – 18:00 | Wed only | 5 Weeks | Classroom Based / Live Virtual Online | |
| 15.07.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 22.07.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 24.07.2024 | 10:00 – 18:00 | Wed only | 5 Weeks | Classroom Based / Live Virtual Online | |
| 29.07.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 05.08.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 07.08.2024 | 10:00 – 18:00 | Wed only | 5 Weeks | Classroom Based / Live Virtual Online | |
| 12.08.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 19.08.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 21.08.2024 | 10:00 – 18:00 | Wed only | 5 Weeks | Classroom Based / Live Virtual Online | |
| 26.08.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 02.09.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 04.09.2024 | 10:00 – 18:00 | Wed only | 5 Weeks | Classroom Based / Live Virtual Online | |
| 09.09.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 16.09.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 18.09.2024 | 10:00 – 18:00 | Wed only | 5 Weeks | Classroom Based / Live Virtual Online | |
| 23.09.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 30.09.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online |