INTRODUCTION TO ADVANCE EXCEL
- In the Excel course, you will learn all the tips, tricks, shortcuts, functions and formulas you need to be an Excel power user.
- This course is very helpful in Backoffice, Accounting, Data Entry & Banking Jobs.
COURSE CURRICULUM
- Excel Limitation & Shortcut use and benefits
- Excel Setting and Custom List Creation
- Lookup Picture in Excel Worksheet
- Link Data range as Picture Link
- Advanced Paste Special
- Apply Custom Data Formats
- Use Advanced Fill Options
- Apply Advanced Conditional Formatting and Filtering
- Apply Custom Styles and Templates
- Use Form Controls
- Prepare Workbooks for Internationalization
- Use Outlines
- Use Custom Views
- Manage Workbook Versions
- Copy Styles between Workbooks
- Copy Macros between Workbooks
- Use Track Changes and Comments
- Protect Workbooks for Sharing
- Connect To External Data
- Functions
- Apply functions in formulas
- Mathematical Functions
- Financial functions
- Useful Data Functions
- Some Other Useful Functions
- Look up data by using functions
- Apply advanced date and time functions
- Functions for Manipulating Text
- Arrays
- Mathematical Calculation in Excel
- Logical Formulas (IF, and, Or, Xor, IfError)
- Nested If Formulas
- Text and Advanced Text Formulas
- Date and Time Calculation
- Ref# Formulas and Vlookup
- Lookup Method(VLookup,HLookup,Match,Index)
- Advanced VLookup and VLookup Listing
- Data Summarization Formulas
- AVERAGEIF,AVERAGEIFS,COUNTIF,COUNTIFS
- Database and list management Formulas
- Use What-If Analysis Tools
- Create Scenarios
- Merge Scenarios
- Create Scenario Summaries
- Use Data Tables
- Create Advanced Charts
- Basic Excel Charts
- Use Area, Scatter & Stock Charts
- Use Surface, Radar & Combination Charts
- Create Custom Chart Templates
- Work with Sparkline’s
- Date & Time For Tricks
- Conditional Formatting
- Conditional Formatting using Formulas
- File, Sheets, or Cells Protection Method
- Benefits of Data Table or Cells Style
- Data Summarization with Pivot Table
- Calculation with Pivot table
- External Data Pivot Table
- Relationship and Slicer in Pivot Table
- Hyperlink in Excel
- Text and Symbol
- Page Setup
- Manage View
- Sheets Option and Arrange
- Advanced Array Formulas
- Complicated Large Formulas Creation
- Advanced Naming Method with Formulas
- Report Automation with Formulas
- Live Automation Project
