[vc_row full_width=”stretch_row_content” equal_height=”yes” css=”.vc_custom_1570858557389{padding-top: 0px !important;padding-bottom: 0px !important;}” el_class=”linkbar”][vc_column][vc_btn title=”Enquiry Now” color=”white” link=”url:%23|||” el_class=”request-btn free-estimate popmake-2722″][/vc_column][vc_column][vc_row_inner el_class=”overview-btns” css=”.vc_custom_1570861575149{margin-bottom: 5px !important;background-color: #ffffff !important;}” el_id=”overview”][vc_column_inner][vc_btn title=”Course Overview” style=”flat” shape=”square” color=”white” el_class=”course_btn” link=”url:%23c_overview|||”][vc_btn title=”COURSE INSIGHT” style=”flat” shape=”square” color=”white” el_class=”course_btn” link=”url:%23insight|||”][vc_btn title=”Course Contents” style=”flat” shape=”square” color=”white” el_class=”course_btn” link=”url:%23c_content|||”][vc_btn title=”SKILLS GAINED” style=”flat” shape=”square” color=”white” el_class=”course_btn” link=”url:%23skill_gained|||”][vc_btn title=”Date & Timming” style=”flat” shape=”square” color=”white” el_class=”course_btn” link=”url:%23date_price|||”][/vc_column_inner][/vc_row_inner][/vc_column][/vc_row][vc_row full_width=”stretch_row” el_id=”c_overview”][vc_column][vc_empty_space height=”35px”][vc_custom_heading stm_title_font_weight=”900″ text=”COURSE OVERVIEW” font_container=”tag:h1|text_align:center|color:%230a0a0a” google_fonts=”font_family:Montserrat%3Aregular%2C700|font_style:400%20regular%3A400%3Anormal”][vc_empty_space height=”35px”][vc_row_inner equal_height=”yes” css=”.vc_custom_1571288216931{background-color: #f1f1f1 !important;border-radius: 25px !important;}”][vc_column_inner width=”1/2″ css=”.vc_custom_1570867959960{margin-right: 50px !important;padding-top: 50px !important;padding-right: 50px !important;padding-bottom: 140px !important;padding-left: 50px !important;}”][vc_column_text]

[/vc_column_text][/vc_column_inner][vc_column_inner width=”1/2″ css=”.vc_custom_1570867951513{margin-left: 50px !important;padding-top: 50px !important;padding-right: 50px !important;padding-bottom: 50px !important;padding-left: 50px !important;}”][vc_column_text]

[/vc_column_text][/vc_column_inner][/vc_row_inner][/vc_column][/vc_row][vc_row full_width=”stretch_row” equal_height=”yes” css=”.vc_custom_1570869469384{margin-top: -40px !important;padding-top: 10px !important;padding-bottom: 10px !important;}” el_id=”c_sap”][vc_column width=”1/6″][/vc_column][vc_column width=”2/3″ css=”.vc_custom_1571288353230{border-top-width: 2px !important;border-right-width: 2px !important;border-bottom-width: 2px !important;border-left-width: 2px !important;padding-top: 10px !important;padding-bottom: 10px !important;background-color: #002e5b !important;border-left-color: rgba(0,0,0,0.4) !important;border-right-color: rgba(0,0,0,0.4) !important;border-top-color: rgba(0,0,0,0.4) !important;border-bottom-color: rgba(0,0,0,0.4) !important;}” el_class=”course3″][vc_custom_heading stm_title_font_weight=”700″ text=”MS EXCEL” font_container=”tag:h3|text_align:center|color:%23ffffff” use_theme_fonts=”yes”][vc_column_text]

[/vc_column_text][/vc_column][vc_column width=”1/6″][/vc_column][/vc_row][vc_row full_width=”stretch_row” css=”.vc_custom_1569831338210{padding-top: 80px !important;padding-bottom: 80px !important;background-color: #f1f1f1 !important;}” el_id=”insight”][vc_column][vc_row_inner][vc_column_inner][vc_custom_heading stm_title_font_weight=”900″ text=”COURSE INSIGHT” font_container=”tag:h1|text_align:center|color:%230a0a0a” google_fonts=”font_family:Montserrat%3Aregular%2C700|font_style:400%20regular%3A400%3Anormal”][vc_empty_space][/vc_column_inner][/vc_row_inner][vc_row_inner][vc_column_inner][vc_column_text]

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.

[/vc_column_text][/vc_column_inner][/vc_row_inner][/vc_column][/vc_row][vc_row full_width=”stretch_row” equal_height=”yes” css=”.vc_custom_1570870954131{padding-top: 80px !important;padding-bottom: 80px !important;}” el_id=”c_content”][vc_column][vc_custom_heading text=”SAP MS EXCEL COURSE OUTLINE” font_container=”tag:h1|text_align:left” google_fonts=”font_family:Montserrat%3Aregular%2C700|font_style:700%20bold%20regular%3A700%3Anormal”][/vc_column][vc_column width=”1/3″ el_class=”m1″][vc_custom_heading stm_title_font_weight=”900″ text=”MODULE” font_container=”tag:p|font_size:18px|text_align:left|color:%23002e5b” use_theme_fonts=”yes”][vc_tta_accordion style=”modern” active_section=”1″][vc_tta_section title=”The Basics” tab_id=”1570863015624-b4e6e918-b6b2″][vc_column_text]

• 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

[/vc_column_text][/vc_tta_section][vc_tta_section title=”Formatting a Worksheet” tab_id=”1570863015676-2c961be8-0de3″][vc_column_text]

• 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

[/vc_column_text][/vc_tta_section][vc_tta_section title=”Managing your workbooks” tab_id=”1570863276695-5a1e4143-4812″][vc_column_text]

• 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

[/vc_column_text][/vc_tta_section][vc_tta_section title=”Editing a Workbook” tab_id=”1572527697976-c8d96a89-58f3″][vc_column_text]

• 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

[/vc_column_text][/vc_tta_section][/vc_tta_accordion][/vc_column][vc_column width=”1/3″ el_class=”m2″ css=”.vc_custom_1572527605351{margin-top: 40px !important;}”][vc_tta_accordion style=”modern” active_section=”1″][vc_tta_section title=”Formulas” tab_id=”1570865625381-8cb98704-1a22″][vc_column_text]

• Creating a basic Formula
• Calculating Value Totals with AutoSum
• Editing & Copying Formulas
• Fixing Errors in Your Formulas
• Formulas with Several Operators and Cell Ranges

[/vc_column_text][/vc_tta_section][vc_tta_section title=”Working with the Forms Menu” tab_id=”1570865625435-20ee8b6d-1e0d”][vc_column_text]

• Sorting, Subtotaling & Filtering Data
• Copy & Paste Filtered Records
• Using Data Validation

[/vc_column_text][/vc_tta_section][vc_tta_section title=”Creating and Working with Charts” tab_id=”1570865625477-86246d8b-08e8″][vc_column_text]

• 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

[/vc_column_text][/vc_tta_section][/vc_tta_accordion][/vc_column][vc_column width=”1/3″ el_class=”m3″ css=”.vc_custom_1572527618771{margin-top: 40px !important;}”][vc_tta_accordion style=”modern” active_section=”1″][vc_tta_section title=”Data Analysis and Pivot Tables” tab_id=”1570865833981-b607ec8a-08e6″][vc_column_text]

• 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

[/vc_column_text][/vc_tta_section][vc_tta_section title=”Automating Tasks with Macros” tab_id=”1570865834031-41211900-40eb”][vc_column_text]

• Recording a Macro
• Playing a Macro and Assigning a Macro a Shortcut Key
• Adding a Macro to a Toolbar

[/vc_column_text][/vc_tta_section][vc_tta_section title=”Working with Other Programs” tab_id=”1570865834087-d10ddc3e-a519″][vc_column_text]

• 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

[/vc_column_text][/vc_tta_section][/vc_tta_accordion][/vc_column][/vc_row][vc_row full_width=”stretch_row” css=”.vc_custom_1572358604870{background-color: #234b71 !important;}” el_class=”choose-course-sec”][vc_column el_class=”heading”][vc_row_inner el_class=”course_img”][vc_column_inner width=”1/2″][vc_custom_heading text=”LOOKING FOR A
2-12 MONTHS
TRAINING?” font_container=”tag:h2|text_align:left|color:%23ffffff” use_theme_fonts=”yes” css=”.vc_custom_1572358654137{padding-bottom: 40px !important;}”][vc_column_text]

CHOOSE

[/vc_column_text][vc_custom_heading text=”SAP MS EXCEL” font_container=”tag:h1|text_align:left” use_theme_fonts=”yes”][/vc_column_inner][vc_column_inner width=”1/2″][vc_empty_space height=”460px” css=”.vc_custom_1572361304073{background-image: url(https://itraininglondon.co.uk/wp-content/uploads/2019/10/course-career.png?id=2480) !important;background-position: 0 0 !important;background-repeat: no-repeat !important;}” el_class=”figure”][vc_btn title=”Find Out More” shape=”square” color=”theme_style_2″ el_class=”request-btn”][/vc_column_inner][/vc_row_inner][/vc_column][/vc_row][vc_row full_width=”stretch_row” css=”.vc_custom_1570871020356{padding-top: 80px !important;padding-bottom: 80px !important;background-color: #f1f1f1 !important;}” el_class=”skillbox” el_id=”skill_gained”][vc_column css=”.vc_custom_1569506522141{background-position: 0 0 !important;background-repeat: no-repeat !important;}”][vc_row_inner][vc_column_inner][vc_custom_heading stm_title_font_weight=”900″ text=”SKILLS GAINED” font_container=”tag:h1|text_align:center” google_fonts=”font_family:Montserrat%3Aregular%2C700|font_style:400%20regular%3A400%3Anormal”][vc_empty_space][/vc_column_inner][/vc_row_inner][vc_row_inner][vc_column_inner][vc_column_text]

• Advanced Formulas.
• Tables & Formatting.
• Conditional Formatting.
• Advanced Charting.
• Pivot tables & Pivot Reporting.
• VBA & Macros.
• Using Excel Productively.
• Data Tables, Simulations & Solver.

[/vc_column_text][/vc_column_inner][/vc_row_inner][/vc_column][/vc_row][vc_row full_width=”stretch_row” parallax=”content-moving” parallax_image=”2376″ el_class=”price_row” css=”.vc_custom_1570870994509{padding-top: 100px !important;padding-bottom: 80px !important;}” el_id=”date_price”][vc_column][vc_column_text]

Dates And Prices

[/vc_column_text][vc_column_text][table id=8 /][/vc_column_text][/vc_column][/vc_row][vc_row][vc_column][vc_empty_space height=”35px”][vc_custom_heading stm_title_font_weight=”900″ text=”RELATED COURSES” font_container=”tag:h1|text_align:left” google_fonts=”font_family:Montserrat%3Aregular%2C700|font_style:400%20regular%3A400%3Anormal”][/vc_column][/vc_row][vc_row css=”.vc_custom_1569833813559{margin-bottom: 37px !important;}”][vc_column width=”1/4″][stm_animation_block animation=”fadeInUp” animation_duration=”1″ animation_delay=”0″][stm_info_box style=”style_4″ title=”SAP HCM” link=”url:%23|title:read%20more|” image=”1428″]Company that offers design and build services for you from initial sketches to the final production.[/stm_info_box][/stm_animation_block][/vc_column][vc_column width=”1/4″][stm_animation_block animation=”fadeInUp” animation_duration=”1″ animation_delay=”0.05″][stm_info_box style=”style_4″ title=”SAP Training” image=”1427″ link=”url:%23|title:read%20more|”]Our aim is exclusively focused on high quality training that are tailored to corporate needs. The training delivered by professional trainers.[/stm_info_box][/stm_animation_block][/vc_column][vc_column width=”1/4″][stm_animation_block animation=”fadeInUp” animation_duration=”1″ animation_delay=”0.1″][stm_info_box style=”style_4″ title=”SAP FCO” image=”1426″ link=”url:%23|title:read%20more|”]Our internship programme is designed to help students who have successfully completed the training and give experience in real time projects.[/stm_info_box][/stm_animation_block][/vc_column][vc_column width=”1/4″][stm_animation_block animation=”fadeInUp” animation_duration=”1″ animation_delay=”0.1″][stm_info_box style=”style_4″ title=”SAP FCO” image=”1426″ link=”url:%23|title:read%20more|”]Our internship programme is designed to help students who have successfully completed the training and give experience in real time projects.[/stm_info_box][/stm_animation_block][/vc_column][/vc_row]