Diploma in Corporate Advance Excel- RS INFOTECH Computer Education #1 training institute in Vasai, Mumbai

About

Diploma in Corporate Advance Excel | Duration :

Corporate Advance Excel is an MS Excel based preparatory diploma course that not only focusses on solidifying the foundation of your Excel knowledge and usage, but also shows you faster and efficient ways of processing, evaluating, and consolidating multi-sheet data points. This course is divided into three levels where you'll learn to use advanced MS Excel formulas and functions for everyday professional necessities like Corporate analysis reporting, Financial analysis, etc. By end of the course, you'll be armed with exceptional knowledge about Excel-focussed data consolidation and analytical skills, enough to help you climb up the corporate ladder faster!

OTP verification

About

Diploma in Corporate Advance Excel | Duration :

Corporate Advance Excel is an MS Excel based preparatory diploma course that not only focusses on solidifying the foundation of your Excel knowledge and usage, but also shows you faster and efficient ways of processing, evaluating, and consolidating multi-sheet data points. This course is divided into three levels where you'll learn to use advanced MS Excel formulas and functions for everyday professional necessities like Corporate analysis reporting, Financial analysis, etc. By end of the course, you'll be armed with exceptional knowledge about Excel-focussed data consolidation and analytical skills, enough to help you climb up the corporate ladder faster!

Module 1 Microsoft Beginners Advance Excel
Introduction to excel
Excel Start Screen The Ribbon (Customization and Developer Tabs)
Tabs, Groups, Commands, Dialog Box Launcher ,Quick Access Toolbar
File Tab (Backstage View),Excel Options, Views and Zooming, Keyboard
Shortcuts Workbook Windows, Document Inspector, File Formats,
Compatibility and Versions
Worksheet Formatting
Using auto formatting option for worksheets, Using conditional formatting
option for rows, columns and cells, Protecting and un-protecting
worksheets Using slicers with table, Cells Formatting, create and modify table
Name Manager
Naming Cells and Ranges, Use Excel Names, Create a Dynamic
Named Range Use a Named Excel Table,
Dynamic Named Range Based on Formula
Conditional Formatting
Highlighting Cells Rules, Top/Bottom Rules, Data Bars, Icon Sets, Color Scales
Editing Standard Formatting Rules, Using Formulas in Conditional Formatting
Filtering
Filtering data for selected view (AutoFilter), Using advanced filter options
Sorting
Sorting table, Using multiple-level sorting, Using custom sorting
Grouping, Outlining and subtotals
Creating subtotals, Multiple-level subtotals, Outlining and Grouping Data
Charts
Using Charts, Formatting Charts, Using 3D Graphs, Trend lines, Error Bars,
Using Bar and Line Chart together, Using Secondary Axis in Graphs
Sharing Charts with PowerPoint / MS Word, Dynamically
(Data Modified in Excel, Chart would automatically get updated)

Module 2 Microsoft Expert Advance Excel
Relative and Absolute Reference
Relative Reference, Absolute Reference
Using cell references with multiple worksheets
Pivot Tables And Pivot Charts
Creating Pivot tables, Formatting and customizing Pivot tables
Using advanced options of Pivot tables, Pivot charts, Creating Slicers
Viewing Subtotal under Pivot, Consolidating data from multiple sheets and
files using Pivot tables, Importing Pivot Table Data,
Calculated Fields in Pivot Tables, Creating Custom Pivot Tables Styles
Formatting and customizing Pivot tables, Using advanced options of
Pivot tables, Pivot charts, Creating Slicers, Viewing Subtotal under Pivot
Consolidating data from multiple sheets and files using Pivot tables
Importing Pivot Table Data, Calculated Fields in Pivot Tables
Creating Custom Pivot Tables Styles
Logical Functions
And, False, IF, If error, Ifna, Ifs, not, or
Statistical Functions
average, median, mode, large, max, min, percentile, quartile, rank, small
average if, averageifs, count, correl
Text Functions
CLEAN, trim, lower, proper, upper, concatenate, Left, right, mid, right, rept, text
Len, find, search, exact, t, char, code, replace, substitute
Vlook up Operator And Lookup Functions
VlookUP with Exact Match, Approximate Match
HlookUP with Exact Match, Approximate Match
Nested VlookUP with Exact Match
VlookUP with Tables, Dynamic Ranges
Nested VlookUP with Exact Match
Using VLookUP to consolidate Data from Multiple Sheets
Consolidation
Consolidating data from multiple sheets and files
Using data consolidation feature to consolidate data
command on multiple ranges to calculate sums,

Start Today

Diploma in Corporate Advance Excel | Duration :

Diploma in Corporate Advance Excel | Duration :

Module 1 Microsoft Beginners Advance Excel

Module 2 Microsoft Expert Advance Excel

Usefull Links

More Info

Contact Info