Microsoft Excel Training

Learn from Beginning

  1. Introduction to Excel: This section may cover the Excel interface, basic functions, and formulas, and navigating the program.

  2. Formatting and Styling: This section may include instruction on how to format and style cells, columns, and rows, including applying color and borders to cells, formatting numbers and dates, and changing font styles.

  3. Data Entry and Management: This section may cover entering data into a worksheet, editing and deleting data, sorting and filtering data, and using tables to organize data.

  4. Formulas and Functions: This section may cover how to use Excel’s built-in functions and create custom formulas, including arithmetic functions, statistical functions, and logical functions.

  5. Charts and Graphs: This section may cover how to create and format different types of charts and graphs, including bar charts, line graphs, and pie charts, and how to use chart elements and formatting options.

  6. PivotTables and PivotCharts: This section may cover how to create and manipulate PivotTables and PivotCharts, which allow users to summarize, analyze, and visualize large datasets quickly and efficiently.

  7. Macros and VBA: This section may cover how to use macros and VBA (Visual Basic for Applications) to automate repetitive tasks, customize Excel functionality, and create advanced calculations.

  8. Collaboration and Sharing: This section may cover how to share Excel workbooks with others, protect worksheets and workbooks, and collaborate with others in real-time using Excel Online