Advanced Excel
Basics of Excel
- Introduction to Excel
- Entering & Editing Data
- Working with Cells & ranges
- Worksheet Formatting
- Understanding Excel Files
- Printing your work
Text Functions
- Concatenate Function
- Trim Function
- Upper Case
- Lower Case
- Proper
- Left & Right
- Replace
- Substitute
Logical Function
- If Else Function
- If else If Function
- Nested if
- AND Function
- OR Function
Power Function
- Sum
- Sumif
- Sumifs
- Count
- Countif
- Countifs
Financial Function
- PMT
- PPMT
- IPMT
- FV(Future Value)
- PV(Present value)
Lookup Functions
- Vlookup (approximate & Exact Match)
- Hlookup (approximate & Exact Match)
- Nested Lookup
- Match Function
- Choose Function
- Index Function
Math Functions
- RandBetween Function
- MOD Function
- Round Function
- Converting
- Round Function
Working with Dates & Times
- Work days
- NetWork Days
- Week Days
- Datedif
Visulizing data by Applying
- Conditional Formatting
- Format table
- Cell Styles
Data Analyzing
- Pivot tables
- Pivot Chart
- Goal Seek
- Time line
- Slicer
- Scenario manager
Converting Data into Charts
- Column Chart
- Pie Chart
- Bar & Scatter Chart
Data Tools
- Linking & Consolidating Worksheets
- Flash Fills
- Removing Duplicate Values
- Data Validation
- Sorting & Filtering data
- Advanced Filter
- Getting Data from another databases
- Protecting you worksheet & workbook