INTRODUCTION TO ADVANCED + CORPORATE EXCEL
- You will learn all the tips, tricks, shortcuts, functions, and formulas you need to be an Excel power user in the Excel course. This course is very much helpful in Backoffice, Accounting, Data Entry & Banking Jobs.
- This course is designed specifically for spreadsheet users who are already performing professional financial analysis and financial modeling or are looking to prep for a wall street career.
ADVANCED EXCEL 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
CORPORATE EXCEL COURSE CURRICULUMHelpie FAQ
- Chart Creation
- Dynamic Chart with Offset Formulas
- Dashboard Example
- Live Project
- Data summarization with Pivot Table Charts
- Dashboard with Slicers
- Dashboard with Data Table
- Logical Formulas
- Data Summerization Formulas
- Dashboard Formulas Tricks
- Dashboard with Data Table
- Event Budget Report
- Website Budget Report, Digital Marketing Report
- SEO Report, Web Analytics Report
- Manufacturing Dashboard Ÿ Human Resource Dashboard
