Advance Excel, MS Access, MS Word

Topics Covered

Basic Formula: Add/Subtract/Multiply (Product())/Divide, count(), MID(), REPT(), abs(), column(), row(), match() Statistical Functions Using The SUMIF/COUNTIF Functions • Using The AVERAGE/COUNT/LARGE/SMALL Functions Text Functions: Upper, Lower, Proper, Left, Right, Concatenate, Len, Exact, Search, Find, Clean, Replace, Substitute, Dollar, TEXT Validations: Input Messages / Error Alerts/ Drop-Down Lists • Conditional Formatting Filters: Extracting Records with Advanced Filter • Using Formulas In Criteria Sorting: Sorting by Top to Bottom / Left to Right • Creating / Deleting Custom List • Sort by using Custom List Date/Time Functions: Date, Today, Now, Day, Month, Year, Time, Hour, Minute, Second, Weekday, Datedif, Networkdays, WORKDAY Summarizing Data: Creating Subtotals/Nested Subtotals • SUBTOTALS Formula Importing & Exporting Data: Importing Data from Database/ Text Files/ Web Logical Function: Writing conditional expressions (using IF, NESTED IF) Using logical functions (AND, OR, NOT) Information Functions IsBlank, IsError, Isnumber, Istext LOOKUP Functions The VLOOKUP/HLOOKUP Functions/Index function PivotTables Creating, Formatting Simple PivotTables, slicer Chart Data Techniques: The Chart Wizard • Chart Types • Adding Title/Legends/Lables • Printing Charts • Adding Data to a Chart • Formatting/Renaming/Deleting Data Series • Changing the Order of Data Series MS ACCESS: Creating Table, queries, report, form, pivot chart, Query design etc.

Who should attend

Any Graduate/Post Graduate

Pre-requisites

Basic Computer

What you need to bring

Nothing"

Key Takeaways

Key board shortcut, Excel Tips etc