- 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
Click to Enquiry
- 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