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.
Duration : 1 Months | Classes: Mon-Fri, 1½ Hrs./day
Introduction to Spreadsheet Programs.
Worksheet, Workbook & Workspace.
Screen Elements of MS Excel.
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.
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.
Paste Special & Format Painter.
Cell Formatting, Text Controls, Categories.
Advanced Conditional Formatting(With Formulas).
Sorting & Filtering.
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.
Insert Comments, Spelling & Grammar.
Protect Sheet & Workbook.
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.
Len, Left, Right, Mid, Lower, Upper, Proper, rept, substitute, Trim, concatenate, value, find, Replace, Char, Code.
Pmt, Ppmt, Ipmt, Pv, Fv, Rate.
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).
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.
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
Back Office Executive
Executive/Sr. Executive - Client Relations
Team Leader - Finance
To book your banner ad on this site call : 080-40949423 | Mail at firstname.lastname@example.org
: Function split() is deprecated in