7

Advance Microsoft Excel

Advance Microsoft Excel course covers the following topics:

  1. Getting Started with Excel: This section of the course covers the basics of the Excel interface, including how to navigate and customize the ribbon, create and save new workbooks, and work with cells, rows, and columns.

  2. Formatting Data: This section covers how to format text, numbers, and cells, including how to use styles, themes, and conditional formatting.

  3. Working with Formulas and Functions: This section of the course covers how to use formulas and functions in Excel, including basic math and logical functions, as well as more advanced functions such as VLOOKUP and INDEX/MATCH.

  4. Charts and Graphs: This section covers how to create and customize charts and graphs in Excel, including line, bar, and pie charts, as well as more advanced chart types such as scatter plots and bubble charts.

  5. Data Analysis and PivotTables: This section covers how to use Excel’s built-in data analysis tools, including PivotTables and PivotCharts, as well as how to use the data analysis add-in for more advanced analysis.

  6. Exporting and Importing Data: This section covers how to export and import data between Excel and other programs and file formats.

  7. Macros and Automation: This section covers how to automate repetitive tasks in Excel using macros and how to program macros using VBA (Visual Basic for Applications).

  8. Advanced Excel Features: This section covers more advanced Excel features such as named ranges, data validation, and data protection, as well as advanced chart and data analysis techniques.