Excel Training – The Most Comprehensive

Introduction to the Excel Training

Course Outline Presentation

• Description of the interface (Ribbon, Quick Access Toolbar, etc.)

Module 1 – Excel Basics Excel

• Structure of a file (workbooks, worksheets, and cells)
• Edit your data: Fill series and freeze panes
• Overview of key shortcuts and time-saving tips
• Customize the ribbon and Quick Access Toolbar
• Create and manage tabs

Module 2 – Using Named References

• Create named references
• Go to a named item
• Use the Name Manager
• Use a named reference in a formula

Module 3 – Tables and Page Layout

• Apply automatic table formatting
• Create a custom style and apply it to a table
• Conditional formatting
• Basic database functions: Filter and Sort
• Cell formatting and styling
• Print the table

Module 4 – Using Formulas in Excel

• Relative and absolute references
• Find and insert a function
• Use basic formulas: Sum, Average, Max, Date
• Use logical (IF), text, and date functions
• Use lookup functions: VLOOKUP, HLOOKUP, XLOOKUP

Module 5 – Creating Charts

• Select data for the chart
• Types of charts: column, line, pie (2D or 3D)
• Choose a chart type based on your needs
• Apply a style

Module 6 – Pivot Tables / Pivot Charts

• Understand the purpose of a pivot table (examples)
• Create a pivot table
• Format a pivot table
• Use slicers
• Update the pivot table after changing the data source
• Highlight desired statistics from your table
• Customize a pivot table
• Create a pivot chart
• Customize a pivot chart

Module 7 – Getting Started with Macros

• How macros work
• Record, write, and run macros
• Run a macro with shortcuts (from the ribbon, button, etc.)
• Manage macros

Advanced Macros Training

• Training: Mastering Macros and Introduction to Programming

Autre(s) cours dans cette catégorie

→ Excel Training – The Most Comprehensive

→ Excel Dashboard Training