MICROSOFT EXCEL TRAINING

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 TimingDaysDuration Mode Of Training Price Reserve Now
15/09/2019
Places available
10:00 – 18:00Sunday Only 5 WeeksClassroom Based£850
15/09/2019
Places available
10:00 – 18:00Monday-Friday 5 WeeksClassroom Based£850
15/09/2019
Places available
10:00 – 18:00Saturday Only 5 WeeksClassroom Based£850
15/09/2019
Places available
10:00 – 18:00Monday-Friday 5 WeeksClassroom Based£850
15/09/2019
Places available
10:00 – 18:00Monday-Friday 5 WeeksClassroom Based£850
15/09/2019
Places available
10:00 – 18:00Monday-Friday 5 WeeksClassroom Based£850
15/09/2019
Places available
10:00 – 18:00Monday-Friday 5 WeeksClassroom Based£850
15/09/2019
Places available
10:00 – 18:00Monday-Friday 5 WeeksClassroom Based£850

RELATED COURSES

SAP HCM

Company that offers design and build services for you from initial sketches to the final production.

read more

SAP Training

Our aim is exclusively focused on high quality training that are tailored to corporate needs. The training delivered by professional trainers.

read more

SAP FCO

Our internship programme is designed to help students who have successfully completed the training and give experience in real time projects.

read more

SAP FCO

Our internship programme is designed to help students who have successfully completed the training and give experience in real time projects.

read more