Course Timings
9.00 am - 3.00 pm
Course Starting from
Monday to Saturday (Every Batch 1 hour)
Course Contents
- Introduction Ms Excel 2010
- Working With Formulas And Function Library
- Advanced Charts
- Creating A Macro
- Working With Ribbon & Quick Access Toolbar
- Text Functions Search, Mid,Exact, Substitute,Replace
Find, Proper, Fixed, Trim, Clean, Text - Logical Functions
- Editing A Macro
- Selecting Cells And Ranges
- Date And Time Functions Date,Today, Weekday,
Date Value,Time, Hour, Now, Days 360,
Edate, Emonth, Networkdays.etc. - Date & Time Functions
- Adding A Commands To A Menu
- Conditional Formatting
- Lookup & Reference Function Match,
Vlookup,
Hlookup, Lookup, Inder, Offset - Conditional Formatting
- Data Handling, Mis, Excel And Access
- Create Custom Tables
- Trigonmetry Functions Degree,
radians, Cos, Sin, Tan Etc.... - Lookup & Reference Functions
- Vba In Excel 2010
- Advance Filter
- Statistical Functions Counta,
Countblank, Count If, Forecast. - Hyperlinks, linking & Embedding
- Macros & The Vb Editor
- Chart Type
- Enginnering Function Convert,
Delta Gestep,Imreal, Dec2hex Functions - Trignometry Functions
- Projects & Reports
- Pivot Table And Pivot Chart
- Insert Slicer
- Statistical Functions
- Hyperlinks
- Tracking And Reviewing Changes
- Printing Your Work
- Page Layout Option
- Solver
- Engineering Function
- Macro
- Developer Tab
- Information Functions
- Scenario, Goalseek, Data Table
- Other Functions
- Starting Ms-excel2010 Application
- Logical Functions And, If, Or, Not, True
& False Functions - Advanced Pivot Tables
- Running A Macro
- Worksheet Fundamentals
- Concatenate & Functions.
- Text Functions
- Adding A Menu To The Menu Bar
- Formatting Cell And Worksheet
- Financial Functions Fv,
Pmt, Pv, Rate, Nper, Sin, Db, Syd....etc... - Data Validations
- Adding Buttons To A Toolbar
- Insert Tab in Excel 2010
- Mathematical Functions Sign,
God, Lom, Product,
Sumproduct, Sumif,
Ceiling, Fact, Mmult, Combin Etc.... - Financial Functions
- Macro Generation And Application Design
- Sorting Data
- Database Function Dsum,
Dmax, Dproduct, Dvar Etc... - Mathematical Functions
- Vba Programming
- Creating Charts And Graphics
- Frequency, Information Function
Is Blank. Is Logical, Info, Cell Ls Ref Etc. - Import Data
- Modyfying The Recorded Code
- Sparkline
- Using Names To Work With Ranges Auditing
- Database Functions
- Various Examples
- Graphics & Designing In Excel
- Working With Pictures,
Clipart & Shapes - Sorting & Filtering Data
- Smart Art Objects
- Scenario, Goal Seek
- Analysing Data With Excel
- Get external Data From Various Sourses
- Solver & Data Table
- Data Validation
- Performing Spreadsheet
What - If analysis - Macros
- Practical Project & Reports
- MIS In Excel
- Lookup Project