Advanced Excel

Advanced Excel Functions refers to the features and functions of Microsoft Excel, which helps the user to perform complex calculations, perform data analysis, and much more. In this article, you will learn some of the most commonly used advanced functions in Excel.

Course Lessons:

• Microsoft Excel Course Introduction
• Microsoft Excel Fundamental
• Entering and Editing Text and Formulas
• Working with basic Excel Function
• Modifying an Excel Worksheet
• Formatting Data in an Excel Worksheet
• Inserting Images and Shapes into an Excel Worksheet
• Creating Basic Charts in Excel
• Printing Excel Worksheet
• Working with Excel Templates
• Working with an excel list
• Excel List Function
• Excel Data Validation
• Importing and exporting Data
• Excel PivotTables
• Working with excel's powerpivot tools
• Working with Large sets of excel Data
• Working with excel's conditional functions
• Working with excel's Lookup functions
• Working with excel's taxt based functions
• Auditing an excel worksheet
• Protecting excel worksheet and workbooks
• Mastering excel's "what if?" tools
• Automating repetitve taska in excel with macros
• Microsoft excel macros and VBA course introduction
  • Project 1: using excel's Macro recorder tools
•  Excel VBA concepts
• Working with excel VBA logic statements
  • Project 2 : Moving beyond the basics and into VBA
  • Project 3 : preparing and cleaning up data with excel VBA
  • Project 4 : using VBA to Automate excel formulas
  • Project 5: Bringing it All together and a weekly report
  • Project 6: working with excel VBA user forms
  • Project 7: Importing Data from taxt files