Advance Excel – Professional
Advanced Excel skills include the ability to produce graphs and tables, use spreadsheets efficiently, and perform calculations and automation to process large volumes of data. With the rise of big data and data analytics, advanced Excel skills are a real asset both during the job hunt and everyday work tasks.
- Loan Calculation
- PMT
- PPMT
- IPMT
- RATE
- NPER
- PV
- Types of what if analysis
- Creating data table
- Use of Scenario of manager
- Managing Scenario manager
- Displaying Scenarios
- Introduction of solver
- Appropriate of Solver
- Count
- COUNTA
- COUNTBLANK
- COUNTIF
- SUMIF
- SUMIFS
- What is macro
- Assign macro
- Delete Macro
- Run Macro
- About data Validation
- Specifying validation criteria
- Types of Validation
- Drop down list of data validation
- Setup of Stop, Information, warning
- Using Excel on a Network
- Sharing workbook
- Understanding shared workbook
- Controlling the advance sharing setting
- Resolving conflicting changes between users
- Pivot table from non-numeric data
- Grouping pivot table items
- Automatic grouping
- Filtering pivot table with slicers
- Connection for two or more pivot table
- Creating Pivot Charts
- Finding and correcting formula errors
- Cells are filled with hash marks
- Formulas running an error
- Import data
- Filter data
- Audit report
- Create charts
- Polish charts
- Connection with charts and data
- Share Workbooks
- Online
- Import Access Data
- Microsoft Query
- Import/Export Text Files
- XML
- Enter a Formula
- Edit a Formula
- Operator Precedence
- Copy/Paste a Formula
- Insert Function
- Most Used Functions
- If
- And
- OR
- Not
- Absolute Value
- Year, Month, Day
- Date Function
- Current Date & Time
- Hour, Minute, Second
- Time Function
- Today’s Date
- Calculate Age
- Weekdays
- Left
- Right
- Mid
- Len
- Find
- Substitute
- Text to Columns
- Flash Fill
- Average
- Averageif
- Median
- Mode
- Min
- Max
- Large
- Small
- Round
- RoundUp
- RoundDown
