MS-Excel is a commercial spreadsheet application produced and distributed by Microsoft Windows and Mac-OS. It has a characteristic of performing the basic calculations, graphing tools, creating pivot tables and creating macros This application performs very effectively on arithmetic solution.
Requirements:
Few basic formulas are suggested but this is not mandatory we will provide classes of basic level too.
Introduction to Excel, Basic Understanding Menu and Toolbar, Introduction to different category of functions like Basics, Mathematical and Statistical, Date and Time, Logical, Lookup and References, Text and Information, MACROS, Organising & Presenting Data, Auditing worksheets & Analysis Data, Import/Export & Publishing the Data.
Course details:
Time to be the expert in excel: Pursuing this course you will be enabled with understanding of advanced formulas, tools, mechanism from a basic spreadsheet program and then a lively and effective analytic tool. Whereas many other train for simple formulas, I prefer to go through contextual examples.
At the last students will be expert in writing robust, formulas and features from scratch all this will take you to build dynamic tools and excel display, and judging. Making your own formula based formatting norms. Targeting dates, schedules, and arrays.
Text Functions - UPPER,LOWER,CONCATENATE,PROPER,LEFT,RIGHT,MID,SEARCH,SEARCH,FIND,LEN,TRIM....
DATE & TIME - DATE,YEAR,DAY,MONTH,EOMONTH,TODAY,TIME,HOUR,MINUTE,DATEVALUE,WEEKDAY,DATEIF....
FINANCIAL - DB,DDB,SIN,PPMT,PMT,RATE,NPER,PV,FV,PRICE.....
LOGICAL - IF,AND.OR,NOT,TRUE,FALSE,IFERROR....
LOOKUP & REFERENCES - LOOKUP,HLOOKUP.VLOOKUP,MATCH,INDEX,INDIRECT,HYPERLINK....
MATHEMATICS - SUM,SUMIFS,COUNT,COUNTIFS,AVERAGE,ABS,FACT,FLOOR,COS,PI,ROUND,POWER,PRODUCT...
STREAMING WORKFLOW
CREATE A MACRO, EDIT A MACRO, APPLY CONDITIONAL FORMATING, ADD DATA VALIDATION CRITERIA, UPDATE A WORKBOOK PROPERTIES, MODIFYING EXCEL DEFAULT SETTIING
COLLABORATING WITH OTHERS
PROTECT FILES, SHARE A WORKBOOK, SET REVISION TRACKING, MERGE WORKBOOK, ADMINISTRATOR DIGITAL SIGNATURE
CALCULATING DATA WITH ADVANCE FORMULA
MANAGE CELL & RANGE NAME, CALCULATING DATA ACROSS WORKSHEETS, USE SPECIAL FUNCTIONS, USING FORMULA TO SEPERATE DATA INTO SEPERATE COL., LINKING FILES IN EXCEL WORKSHHETS BY USING BUTTON
Organizing Worksheet And Table Data
Create A Chart, Chart Element, Changing A Chart Type, Modifying A Chart, Format A Chart, Set Up Dynamic & Intreactive Chart, Calculating In Pivot Table
Auditing WorkSheets
Trace Cell, Trouble Shoot Error In Formulas, Troubleshoot invalid Data And Formula, Watch And Evalute Formula
Analyzing Data
Create A Scenarios, Perform What-if-analysis, Perform Statistical Analysis, Anlysis Toolpack
Organizing Sheet And Table Data
Table, Create Table Dialog Box, Styles And Quick Style Set, Formate Table, Sort Or Filter Worksheet Or Table Data, Database function…….Dsum(), Daverage(),Dcount()
Inserting Graphics Object
Insert And Modify Picture And Clipart, Draw And Modify Shapes, Illustrate Workflow Using SmartArt graphics, Layer And Group Graphics Object, Customizing And Enahancing Workbook, Customizing Workbook, Manage Themes, Create And Use Template(ex-bills)
Import/Export & Publish
Exporting Excel Data, Importing Delimited Text File, Publish A Worksheet To The Web, Importing Data From The Web, Create A Web Query