Book a Free Demo / Get Full Program Details

Request a call back now

Advanced Excel Certification Course

The extreme versatility of Microsoft Excel and its ability to store and manipulate data makes it one of the most widely used spreadsheet software applications in the world.

The Excel application is widely used by professionals in different industry sectors and especially in the finance and accounting sectors. For example, a financial analyst may use it for making analytical reports while an accountant will use it for documenting cash flows. An MIS executive may use advanced functionalities of Excel to tabulate, sort and analyze raw data to generate reports which would then be presented to managers.

If you wish to pursue an Advanced Excel Course in Mumbai North region (Vasai, Virar, Palghar), then look no further than Hrishi Computer Education. We are one the best training institutes in Mumbai North region offering Certificate course in Advanced Excel. Our excellent and in-depth course content with focus on industry-requirements and practical training has enabled students to further their career up on successful completion of the Advanced Excel Training course.

COURSE DURATION

2 Months

WEEKLY

6 days/ 1 ½ Hours

Download Brochure

View Details

A list of the modules that comprise the syllabus for our Advanced Excel Course

Module 1

1
  • 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
  • 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
  • Naming Cells and Ranges
  • Use Excel Names, Create a Dynamic Named Range
  • Use a Named Excel Table, Dynamic Named Range Based on Formula
  • Relative Reference, Absolute Reference
  • Using cell references with multiple worksheets
  • Highlighting Cells Rules
  • Top/Bottom Rules
  • Data Bars, Icon Sets, Color Scales
  • Editing Standard Formatting Rules
  • Using Formulas in Conditional Formatting
  • 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
  • Filtering data for selected view (AutoFilter)
  • Using advanced filter options
  • Sorting table
  • Using multiple-level sorting
  • Using custom sorting
  • Creating subtotals
  • Multiple-level subtotals
  • Outlining and Grouping Data
  • Exploring Scenarios
  • Goal Seek and Data Tables
  • Using Solver

Module 2

2
  • 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
  • Consolidating data from multiple sheets and files
  • Using data consolidation feature to consolidate data
  • command on multiple ranges to calculate sums, averages, products, minimum and maximum values
  • Text to Columns
  • Flash Fill
  • Remove Duplicates
  • Specifying a valid range of values for a cell
  • Specifying a list of valid values for a cell
  • Specifying custom validations based on formula for a cell
  • drop Down list, prevent duplicates entries, product Codes, Reject invalid dates
  • 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)
  • Creating Sparkline
  • Editing Sparkline

Formulas and Functions

3
  • DATE, TIME, DATEVALUE, TIMEVALUE
  • Now, Today, Hour, Minute Second
  • Day, month, year, weeknum, weekday
  • EDATE, EOMONTH, WORKDAY, WORKDAY.INTL, DAYS, DAYS360
  • NETWORKDAYS, NETWORKDAYS.INTL, YEARFRAC
  • PMT function, Dollar Function, CUMIPMT function
  • And, False, IF, If error
  • Ifna, Ifs, not, or
  • Using Error Functions
  • Using Logical Functions
  • Using Array Formulas
  • Using Rounding Functions
  • average, median, mode, large, max, min
  • percentile, quartile, rank, small
  • average if, averageifs, count, correl
  • CLEAN, trim, lower, proper, upper, concatenate
  • Left, right, mid, right, rept, text
  • Len, find, search, exact, t, char, code, replace, substitute
  • Starting the Visual Basic Editor
  • Using the Project Explorer
  • Using the Properties Window
  • Creating, Importing and Exporting Modules
  • Explore Recorded Macros
  • Creating Sub and Function Procedures
  • Declare and Use Variables
  • Displaying Message to the User
  • Getting Input from the User
  • Creating a Custom Form
  • Adding Form Controls
  • Creating Event Procedures

WHAT STUDENT SAYS ABOUT US?

Book a Free Demo / Get Full-Programme Details

HRISHI Computer Education, one of the leading IT/ Computer Education Institutes in Vasai-Virar, is run under the visionary leadership of Mrs. Surekha Bhosale.

Request a call back now