[fusion_builder_container hundred_percent=”no” hundred_percent_height=”no” hundred_percent_height_scroll=”no” hundred_percent_height_center_content=”yes” equal_height_columns=”no” menu_anchor=”” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” status=”published” publish_date=”” class=”” id=”” background_color=”” background_image=”” background_position=”center center” background_repeat=”no-repeat” fade=”no” background_parallax=”none” enable_mobile=”no” parallax_speed=”0.3″ video_mp4=”” video_webm=”” video_ogv=”” video_url=”” video_aspect_ratio=”16:9″ video_loop=”yes” video_mute=”yes” video_preview_image=”” border_size=”” border_color=”” border_style=”solid” margin_top=”” margin_bottom=”” padding_top=”” padding_right=”” padding_bottom=”” padding_left=””][fusion_builder_row][fusion_builder_column type=”1_1″ spacing=”” center_content=”no” link=”” target=”_self” min_height=”” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” class=”” id=”” background_color=”” background_image=”” background_image_id=”” background_position=”left top” background_repeat=”no-repeat” hover_type=”none” border_size=”0″ border_color=”” border_style=”solid” border_position=”all” padding_top=”” padding_right=”” padding_bottom=”” padding_left=”” margin_top=”” margin_bottom=”” animation_type=”” animation_direction=”left” animation_speed=”0.3″ animation_offset=”” last=”no”][fusion_text columns=”” column_min_width=”” column_spacing=”” rule_style=”default” rule_size=”” rule_color=”” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” class=”” id=””]
CORPORATE MS EXCEL TRAINING
[/fusion_text][fusion_text columns=”” column_min_width=”” column_spacing=”” rule_style=”default” rule_size=”” rule_color=”” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” class=”” id=””]
EXCEL PROFESSIONAL LEVEL TRAINING FOR CORPORATES (BASIC to ADVANCED Training)
[/fusion_text][fusion_text columns=”” column_min_width=”” column_spacing=”” rule_style=”default” rule_size=”” rule_color=”” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” class=”” id=””]
Overview:
This will build on your current Excel skills. This course will cover all aspects of creating Spreadsheets, Performing calculations,Data Validation, VLookup, HLookup, SumIf, CountIf, Ranges, Match, Index etc. It also guides you on data presentation using Conditional Formatting, Excel-Charts, Formatting and using page setup for printing. Our professional Excel training teaches you not only basics of Microsoft Excel but also the application of it to your everyday problems. We evaluate candidate’s knowledge level, their problems and adjust our training to their specific needs. Getting Excel to make decisions using the ‘IF’ function, You’ll learn how to create templates for commonly used worksheets. We teach you how to develop analysis and data processing problems on the worksheet then how to determine the proper Excel tools to create a unique solution. This course will also enable you to create, build and customise graphs. Existing Excel users whom have not had any formal training finds this course extremely useful, as it will bridge the gap in your knowledge of Excel. Feel free to check our Advanced Excel training for corporates
[/fusion_text][/fusion_builder_column][/fusion_builder_row][/fusion_builder_container][fusion_builder_container hundred_percent=”no” hundred_percent_height=”no” hundred_percent_height_scroll=”no” hundred_percent_height_center_content=”yes” equal_height_columns=”no” menu_anchor=”” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” status=”published” publish_date=”” class=”” id=”” background_color=”” background_image=”” background_position=”center center” background_repeat=”no-repeat” fade=”no” background_parallax=”none” enable_mobile=”no” parallax_speed=”0.3″ video_mp4=”” video_webm=”” video_ogv=”” video_url=”” video_aspect_ratio=”16:9″ video_loop=”yes” video_mute=”yes” video_preview_image=”” border_size=”” border_color=”” border_style=”solid” margin_top=”” margin_bottom=”” padding_top=”” padding_right=”” padding_bottom=”” padding_left=””][fusion_builder_row][fusion_builder_column type=”1_1″ spacing=”” center_content=”no” link=”” target=”_self” min_height=”” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” class=”” id=”” background_color=”” background_image=”” background_image_id=”” background_position=”left top” background_repeat=”no-repeat” hover_type=”none” border_size=”0″ border_color=”” border_style=”solid” border_position=”all” padding_top=”” padding_right=”” padding_bottom=”” padding_left=”” margin_top=”” margin_bottom=”” animation_type=”” animation_direction=”left” animation_speed=”0.3″ animation_offset=”” last=”no”][fusion_text columns=”” column_min_width=”” column_spacing=”” rule_style=”default” rule_size=”” rule_color=”” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” class=”” id=””]
Syllabus & Training Details
[/fusion_text][/fusion_builder_column][fusion_builder_column type=”1_2″ spacing=”” center_content=”no” link=”” target=”_self” min_height=”” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” class=”” id=”” background_color=”” background_image=”” background_image_id=”” background_position=”left top” background_repeat=”no-repeat” hover_type=”none” border_size=”0″ border_color=”” border_style=”solid” border_position=”all” padding_top=”” padding_right=”” padding_bottom=”” padding_left=”” margin_top=”” margin_bottom=”” animation_type=”” animation_direction=”left” animation_speed=”0.3″ animation_offset=”” last=”no”][fusion_accordion type=”” boxed_mode=”” border_size=”1″ border_color=”” background_color=”” hover_color=”” divider_line=”” title_font_size=”” icon_size=”” icon_color=”” icon_boxed_mode=”” icon_box_color=”” icon_alignment=”” toggle_hover_accent_color=”” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” class=”” id=””][fusion_toggle title=”EXCEL ADVANCE FUNCTIONS” open=”no”]
Various Methods and Uses of Advance Excel Formulas
VLOOKUP, HLOOKUP, SUMIF, SUMIFS, SUMPRODUCT, DSUM, COUNTIF, COUNTIFS, IF, IFERROR, ISERROR, ISNA, ISNUMBER, ISNONTEXT, ISBLANK, ISTEXT, GETPIVOTDATA, DCOUNT, DCOUNTA, OR, AND, SEARCH, INDEX, MATCH etc
[/fusion_toggle][fusion_toggle title=”EXCEL OPTIONS” open=”no”]
- Various Methods and Options of Pivot Table
- Pivot Table Charts
- Pivot Table Insert Slicer
- Different Ways to Filter an Excel Slicer
- Connect Slicers to Multiple Excel Pivot Tables
- Various Methods of Filter and Advance Filter options
- Creating and Updating Subtotals
- Various Methods of Text to Column options
- Uses of Goal Seek and Scenarios Manager
- Various Method of Sorting Data
- Creating, Formatting and Modifying Chart
- Data Validation, Creating drop down lists using different data sources
Excel Options, Customizing the Quick Access Tool Bar
[/fusion_toggle][/fusion_accordion][/fusion_builder_column][fusion_builder_column type=”1_2″ spacing=”” center_content=”no” link=”” target=”_self” min_height=”” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” class=”” id=”” background_color=”” background_image=”” background_image_id=”” background_position=”left top” background_repeat=”no-repeat” hover_type=”none” border_size=”0″ border_color=”” border_style=”solid” border_position=”all” padding_top=”” padding_right=”” padding_bottom=”” padding_left=”” margin_top=”” margin_bottom=”” animation_type=”” animation_direction=”left” animation_speed=”0.3″ animation_offset=”” last=”no”][fusion_accordion type=”” boxed_mode=”” border_size=”1″ border_color=”” background_color=”” hover_color=”” divider_line=”” title_font_size=”” icon_size=”” icon_color=”” icon_boxed_mode=”” icon_box_color=”” icon_alignment=”” toggle_hover_accent_color=”” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” class=”” id=””][fusion_toggle title=”EXCEL BASIC OPTIONS” open=”no”]
An overview of the Screen, Navigation and Basic Spreadsheet concepts
Understand Excel terminology Workbooks, Worksheets, Rows, Columns and Cells
Various Selection techniques
Various ways to Enter, Edit and Delete information (Text, Numbers, Dates)
Methods to Move, Copy & Paste data
All the Options in Paste Special and Go To
Insert, Delete and Hiding Rows & Columns
Inserting and Deleting ranges
Insert, Delete and Move Cells
Various Navigation techniques
Sheet tab formatting and Renaming
Copy and Clear Formats and Merge Cells
Find, Replace and AutoCorrect
Various Printing Technique like Page break preview, Headers and footers, Freezing print titles & Data Alignments
Formatting of Cells with Number formats, Font formats, Alignment, Borders, Fill colours and Patterns
Uses Conditional Formatting and Auto Formatting
All Formate Cells Options
Uses of Toolbars and Formula Bar
Viewing, Adding, Editing and Deleting Comments
Auditing features and Tracing Formula errors
Protecting and Sharing Workbook, Worksheet and Cell ranges
Using Freeze Panes
Worksheets and Workbooks Calculation method
Hiding and Displaying Data, Rows, Columns, Worksheet & Workbooks
Methods to Move and Copy sheets
Uses of Hyperlinks and Define Name
[/fusion_toggle][fusion_toggle title=”EXCEL BASIC FUNCTIONS” open=”no”]
Uses of Basic Excel Formulas
SUM, SUBTOTAL, AVERAGE, CONCATENATE, COUNT, COUNTA, COUNTBLANK, EXACT, HYPERLINK, RIGHT, LEFT, MID, LEN, LOWER, UPPER, TEXT, OFFSET, PROPER, MAX, MIN, TIME, DATE, DAY, MONTH, YEAR, ROUND, ROW, ROWS, SUBSTITUTE, TODAY, TRANSPOSE, TRIM, INDIRECT, NETWORKDAYS, DATEDIF, NOW etc,
[/fusion_toggle][/fusion_accordion][/fusion_builder_column][/fusion_builder_row][/fusion_builder_container]