top of page

Learning to use Excel

As part of Excel Templates, we have now included a few classes for you to learn more about using Excel. If you are a beginner in Excel or more advanced you will get something from these Excel lessons.

Summary:

In this lesson you will get a step-by-step guide to using excel, you will master Excel functions and formatting.  You will build a solid understanding of Excel and increase your knowledge.

Learn the following Microsoft Excel Lessons

  • Fundamentals

  • Entering and Editing Text and Formulas

  • Basic Excel Functions

  • Modifying the worksheets

  • Formatting Data 

  • Inserting Images and Shapes 

  • Basic Charts

  • Printing

  • Excel Templates are included in this Lesson

10 Lessons include Video Lessons, PDF Guides and slides, Real work Examples, and more

Lessons: Learning how to use Function and Pivot Tables

Summary:

In this lesson you will get a step-by-step guide to using excel, you will master Excel Functions and Pivot Tables.  You will build a solid understanding of Excel and increase your knowledge.

Learn the following Microsoft Excel Lessons

  • Functions

  • Data Validation

  • Importing and Exporting Data

  • Pivot Tables

  • Power Pivot Tools 

  • Large Sets of Data 

  • Practice Lessons 

  • Excel Templates are included in this Lesson

10 Lessons include Video Lessons, PDF Guides and slides, Real work Examples, and more

Summary:

In this lesson you will get a step-by-step guide to using excel, you will master Excel functions .  You will build a solid understanding of Excel and increase your knowledge.

Learn the following Microsoft Excel Lessons

  • Conditional Functions

  • Lookup Functions

  • Test Based Functions

  • Auditing the worksheets

  • Protecting Excel Workbook and Worksheets 

  • What if Tools

  • Automating Repetitive  Tasks

  • Excel Templates are included in this Lesson

10 Lessons include Video Lessons, PDF Guides and slides, Real work Examples, and more

Lessons: Learning how to use VBA

Learn Microsoft Excel VBA & Macros: Automate Work and Simplify Work Flow - Comprehensive Lesson with Real-World Examples  

Summary: 

Learn step-by-step how to use VBA and Macros. Gain a understanding of how VBA and improve your workflow, and save time and automate your current excel files.

Learn VBA and Macros

  •  Record Macros

  • VBA Examples Concepts

  • VBA Logic Statements

  • VBA options

  • VBA Automate Excel Formulas

  • VBA Applications

  • User  Forms

  • Importing Data form Text Files

The 10 Lessons include Video Lessons, PDF Guides and slides, Real work Examples and more.

​

​

Learn Microsoft Excel Additional VBA  Mastery of Work Flow - User form Lessons with Real-World Examples  

Summary: 

Learn step-by-step how to use VBA workflow and working with Variables . Gain a understanding of how VBA and improve your speed and understanding.

Learn VBA and Macros

  •  Automate with VBA

  • Master Macros

  • Apply VBA Examples into you own files

  • Functionality with the use of Macros

  • Formulas & and Excel core functionality

  • Useful built in Functions

  • Understand the basics of using VBA and creating Macro's

The 8 Lessons include Video Lessons, PDF Guides and slides, Real work Examples and more.

Lessons: VBA Lesson 2

Learn Microsoft Excel Additional VBA  Mastery of Work Flow - User form Lessons with Real-World Examples  

Summary: 

Learn step-by-step how to use VBA workflow and working with Variables . Gain a understanding of how VBA and improve your speed and understanding.

Learn VBA and Macros

  •  Working with Files and folders

  • Project Setting up a Sales Regional Reporting tool

  • interacting with other applications (word and Power point)

  • User Forms

  • Project Invoice Generation Tool

  • Create Custom Functions

The 8 Lessons include Video Lessons, PDF Guides and slides, Real work Examples and more.

​

​

bottom of page