Advanced Excel

  • Advanced Excel

    Smiley face

    Advanced Excel Course Microsoft Excel is a spreadsheet application developed by Microsoft for Microsoft Windows and Mac OS. It features calculation, graphic tools, pivot tables, and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for spreadsheets. Excel forms part of Microsoft Office. GITA's Microsoft Excel Advanced Training is suitable for those who wish to progress to the most complicated functions and features of Excel enhance their Spreadsheet Skills for the best jobs in corporate with a sound working knowledge of Excel.

  • Course Content

    Duration : 1 Months | Classes: Mon-Fri, 1½ Hrs./day

    • Basic Excel

      Basics Excel
      • Introduction to Spreadsheet Programs.
      • About MS-Excel.
      • Worksheet, Workbook & Workspace.
      • Screen Elements of MS Excel.
      • Ribbon Bar.
      • Sorting & Filtering.
      • Find & Replace, Goto & Paste Special.
      • Tabs and Options.
      • Sheet, Rows & Columns and Range.
      • Sheet Navigation and Sheets tab switching.
      • Working with Shortcuts.
      • Creating Records and Formatting Range & Selection.
      • Basic Functions Sum, Average, Count, Max & Min etc.
      • Alignment & Wraptext.
    • Advance Excel

      • Introduction to Excel 2010 & 13.
      • Understanding File Formats: .xls,.xlsx,.xlsm,.csv etc.
      • About Cell, NameBox, Formula Bar.
      • About Cell Referencing.
      • Type of Referencing: Absolute, Relative & Mixed.
      • About Formulas & Functions.
      • About Operators and Their Uses.
      • Working With Formulas and Functions.
      • Home Tab.
      • Paste Special & Format Painter.
      • Cell Formatting, Text Controls, Categories.
      • Advanced Conditional Formatting(With Formulas).
      • Sorting & Filtering.
      • Flash Fill.
      • Fill Series and Justify.
      • Advanced Find & GoTo Special.
      • Insert ,View & Page Layout Tab.
      • Creating & Running Macros.
      • Charts, Pictures, Smartart, Screenshot.
      • Insert links and Header & Footers.
      • Page Setup, Margins and Print Settings.
      • Print Area, Workbook views, Freeze Panes.
      • Scale to Fit, Sheet Options & Print Titles.
      • Review Tab.
      • Insert Comments, Spelling & Grammar.
      • Protect Sheet & Workbook.
      • Share Workbook.
      • Track changes.
      • Allow Users to Edit Range.
    • Advanced Excel : Formulas & Functions

      • Math & Trig
      • Nemuric Information: Abs, Gcd, Lcm.
      • Mathemical Operations: Sum, Product, Power, Sqrt, Mod, Aggregate(excel 2010).
      • Conditional Sums: Sumif, Sumifs(Excel 2007).
      • Advanced Mathematical Operations: Sumproduct, Sumsq, Seriessum.
      • Other Operations: Round, Roundup, Rounddown, Rand, Randbetween, Fact, Roman.
      • Text Functions
      • Len, Left, Right, Mid, Lower, Upper, Proper, rept, substitute, Trim, concatenate, value, find, Replace, Char, Code.
      • Financial Functions
      • Pmt, Ppmt, Ipmt, Pv, Fv, Rate.
      • Information Functions
      • Iserror, Iserr, Isna.Error.Type, Isref, Iseven, Isodd, Isnumber, N, Isblank, Row, Column, Rows, Columns, Areas.
      • Date & Time Functions
      • Day, Hour, Minute, Month, Networkdays, Now, Second, Today, Weekday, Year, Networkday.intl, Weeknum, Days360, Edate, EOMonth.
      • Logical & Reference Functions
      • Data Lookup Functions: Vlookup, Hlookup, Lookup, Choose, Match, Getpivotdata.
      • Logical Functions: And, Or, Not, If, Iferror, Ifna, True, False.
      • Cell/Range: Address, Index, Offset.
      • Other: Hyperlink, Transpose, Formulatext (Excel 2013).
      • Statistical Functions
      • Max, Min, Count, Counta, Countblank, Countif, Countifs(Excel 2007), Average, Averageif(excel 2007), Mode.sngl(Excel 2007), Mode.mult(Excel 2010), Frequency, Rank, Rank.eq(excel 2010).
    • Advanced Excel : Features & Techniques

      • Advanced Conditional Formatting Using Functions.
      • Advanced Filter, Filter To Cross Sheet and workbook
      • What if Analysis(Goal Seek, Data Tables and Scenario Manager).
      • Searching Technique with GoTo Special...
      • Lookup to Left with Index & Match
      • Loan EMI Calculator In excel.
      • Tax Calculator in Excel.
      • Advanced Chat Technique, How To Make Dynamic Charts, Bar Charts, Pie Charts, Scatter Chart, Line Chart, Column Chart, Speedometer Chart, Gantt Chart.
      • Protecting Excel File, Protecting worksheet, Workbook, Enable / Disable Range, Allow users to edit range, Protecting users to edit range, Field Controls using customized user access.

    Unique Features

    • Real Time Training with experienced, qualified and friendly trainers
    • Job Oriented training will help you in companies.
    • Free PD Class & Placement Offer for various courses.
    • Fully WiFi enabled Campus and Class Rooms.
    • Weekend Batch Facility for working persons.
  • Scope and Opportunities

    Various Advanced Excel Skilled Jobs after Completing this course are as below
      • MIS Office
      • MIS Executive
      • Office Assistant
      • Computer Operator
      • Senior Analytics
      • Process Specialist
      • Back Office Executive
      • Domestic/International Operations
      • Executive/Sr. Executive - Client Relations
      • Team Leader - Finance
      • Banking Operations