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 much helpful in Backoffice, Accounting, Data Entry & Banking Jobs.
COURSE CURRICULUMHelpie FAQ
- 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
