This Microsoft Excel training class , one to one, live Excel course with AMT is ideal for novices who have basic knowledge of Excel, self-taught or complete beginners. If you have a specific project, need to learn the basics of Excel or require training to become an Excel expert, we provide the courses and training options to get you up to speed as fast and efficiently as possible. Our Microsoft Excel classes are always live with an instructor. Online, or on-site at your offices. Regardless of your current experience in Excel, we can assist you. Simply because each Excel class is private, addressing your current skill level and objectives is your instructor’s only agenda. You are the focus of the class and we will teach you exactly what you need to know.
Excel Training Class
Excel Training Classes – one to one LIVE instruction
Excel Private Custom Class - Beginner (6 Hours)
Live Online
Cost: $239
Excel Level 1 Beginner Class Description
This hands-on beginner Excel class is suitable for Excel 2013, 2016, 2019 and 365 users.
You will learn to create, modify, format and print Excel worksheets and workbooks. You will learn basic formulas and functions, how to manipulate data, and how to add charts.
This course is ideal for people new to Excel who need to produce reports, budgets, lists and other spreadsheets.
Excel Essentials
- Starting Excel
- The Excel Interface
- Opening a Workbook
- Navigating around a Workbook
- Finding Data
- Entering Data
- Saving and Closing a Workbook
Creating Worksheets
- Types of Data
- Entering Text
- Adjusting Column Width
- Entering Numbers
- Types of Formulas
- Entering Formulas
- About Functions
- Inserting Functions
- Copying and Moving Data
- Copying Formulas
- Absolute and Relative References
Formatting
- Text Formatting
- Number Formatting
- Alignment
- Text Wrapping
- Merging Cell Data
- Borders and Highlighting
- Styles and Themes
Manipulating Data
- Data Entry Shortcuts
- Fill and Auto Fill
- Replacing Data
- Paste Options
- Inserting and Deleting Rows and
- Columns
- Hiding Rows and Columns
Charts
- About Charts
- Creating Charts
- Chart Types and Elements
Output
- Managing Worksheet Windows
- Freezing Panes
- Printing Worksheets
- Print Setup Options
- Print Areas and Titles
- Headers and Footers
- Sharing Workbooks
Settings and Templates
- Workbooks Options and Properties
- Working with Templates
Our Excel Private Class is specifically organized for you. Before we start teaching, our instructors will discuss your current skill level, experience and objectives to ensure you get the most out of your training.
Excel Private Custom Class - Intermediate (6 Hours)
Live Online
Cost: $239
Excel Level 2 Intermediate Class Description:
This Excel hands-on intermediate class is suitable for Excel 2013, 2016, 2019 and 365 users.
You will learn to share data across multiple worksheets and workbooks, work with named ranges, filter and sort data, use Pivot Tables and Pivot Charts, conditional formatting, advanced charting, and how collaborating with others.
You should have completed our Excel Level 1 Training Class or have the equivalent experience prior to attending this course.
Managing Workbooks
- Inserting and Deleting Worksheets
- Rearranging Worksheets
- Adding Hyperlinks
- Linking to other Workbooks
- Customizing Excel
Named Ranges
- Using Names in Formulas
- Other ways to use Named Ranges
- Naming Shortcuts
- Managing Named Ranges
Filtering and Sorting Data Tables
- Sorting Data
- Custom Sorts
- Filtering Tables
- Using Auto-Filter
- Removing Duplicate Rows
- Working with Structured References
- Data Validation
- Transposing Rows and Columns
Summarizing Data
- Consolidating Data
- Using Sub-totals
PivotTables
- About PivotTables
- Creating PivotTables
- Formatting PivotTables
- Manipulating PivotTables
- Viewing Subsets of PivotTable Data
- Adding Slicers
- Creating PivotCharts
Presentation Features
- Conditional Formatting
- Graphical Conditional Formatting
- Custom Formats
- Adding Graphics
- Adding Smart Art
Advanced Charts
- Special Chart Types
- Inserting Trendlines
- Combination Charts
- Chart Templates
- Inserting Sparklines
- Quick Analysis Options
Collaboration
- Controlling Access with Permissions
- Protecting and Securing Workbooks
- Shared Workbooks
- Adding Comments
- Tracking Changes
- Merging Shared Workbooks
Our Excel Private Custom Class is specifically organized for you. Before we start teaching, our instructors will discuss your current skill level, experience and objectives to ensure you get the most out of your training.
Excel Private Custom Class - Advanced (6 Hours)
Live Online
Cost: $239
Excel Level 3 Class Description:
This Excel hands-on advanced class is suitable for Excel 2013, 2016, 2019 and 365 users.
On this Excel advanced class you will learn advanced functions including LOOKUPS, Date and Time Functions, Text Functions, Statistical Functions, and Financial Functions. You will learn how to import and export data using the Power Pivot Data model and analysis data using What-If Analysis, Scenarios and Goal Seeker. Finally you will learn to automate tasks using Macros and capture user input using Forms.
You should have completed our intermediate class or have the equivalent experience prior to attending this course.
Logical and Lookup Functions
- The IF Function
- Conditional Calculations
- Using SUMIF
- VLOOKUPS and HLOOKUPS
- Range LOOKUPS
Advanced Formulas
- Auditing and Error Trapping
- Formula Options
- Array Functions
- Using TRANSPOSE
Special Functions
- Date and Time Functions
- TODAY
- NOW
- DATE
- Date Calculations
- Text Functions
- Using CONCATENATE and TRIM
- Using UPPER, LOWER and PROPER
- Extracting Text
- Statistical Functions
- Using MIN and MAX
- Using COUNT, COUNTA and COUNTBLANK
- Financial Functions
- Using FV
- Using PMT
Importing and Exporting
- The Power Pivot Data Model
- Importing Data
- Using Power Pivot
- Exporting Data
Data Analysis
- What-if Analysis
- Scenarios
- Using Goal Seek
- The Analysis Toolpak
Macros and Forms
- Recording Macros
- Running Macros
- Running Macros when Workbook is Open or Closed
- Using Forms to Record Input
Our Excel Private Custom Class is specifically organized for you. Before we start teaching, our instructors will discuss your current skill level, experience and objectives to ensure you get the most out of your training.
Additional Course Information
Need a Software Copy?
Need to get a licensed copy of Excel before your Excel class?
https://www.microsoft.com/en-us/microsoft-365/buy/compare-all-microsoft-365-products?tab=1
A trial version is also available for your Excel private training course
https://www.microsoft.com/en-us/microsoft-365/try?rtc=1
On-site Excel Class Options
If you prefer that we to come to your place of business and want a private in-person class, we can certainly deliver an Excel course on-site. Cost will depend on the number of students and also your location. The larger the group, the lower the cost per student.
Please complete our contact form here
Excel Development and Consulting
There are many Excel developers who get stuck and need assistance with their projects. Whether you are a beginner or an advanced user, taken an Excel class or not, we can help you complete your project.
Please complete our contact form here to get assistance.
Excel Class Features
When taking a Microsoft Excel Private Custom Class, you will leap ahead learning a world standard when it comes to windows database applications.
Excel has been around for years and we began teaching it in 2001. So after 19 years of development and teaching Excel courses, we know the program pretty well.
When training Excel one on one, you learn much better and much faster. You have a lot more time to focus on the specifics of Excel, gets lots of hands on attention and of course can ask your instructor anything about the class or Excel itself. After training thousands of students for the last 25 years, experience counts, and hands down, a Excel private custom class is without a doubt, the best way to learn Excel
What else should I learn after my Excel class?
Excel is a specialist application. It is not one of the more commonly used applications in Microsoft Office
In addition to Excel, most office users will use PowerPoint, Word, and Outlook.
Many corporations will expect you to know Teams too.
If you need to know Excel, taking an Excel private class is the best way to start. What will certainly make a difference though, is your level of expertise in Excel and knowledge of the other Microsoft products.
Excel training classes are available for all versions
Whether you are using the most recent Excel version, or earlier releases such as Excel 2010,2013,2016 or 2019, our Excel training courses will help you learn the tools you use. When attending a public Excel class, we will use the most recent versions for your Excel course. If you wish to use an older version of Excel for your training, simply let us know and we will work with you on that version. Our Excel instructors have been teaching and developing courses for over 15 years, and are happy to address questions and deliver training on all versions of Excel.
About Excel Classes and Excel Training Courses from AMT
We do offer regularly scheduled public classes, workshops in major cities, which provide hands-on learning from expert Excel instructors. Small classes with practical exercises and projects help you to quickly learn Excel as it relates to your specific needs. Our instructors have extensive experience with the applications they teach and in most cases they can assist with other programs relating to Excel. They are reviewed frequently and we take our student evaluations very seriously. Our trainers are the core of our business. Their ability and expertise in Excel and teaching, help you achieve your goals when attending a Excel course. Although public Excel classes are generally available, a private one on one course is without doubt, the best way to learn anything, including of course Excel.
Prerequisites for enrolling in Excel public courses
For the beginner course, no previous experience is required. For the advanced Excel courses, we recommend development in Excel for at least 3 months or having attended the beginner course. If you are not sure which level would benefit you, please have a look at the course descriptions for each level. Most of our classrooms, are equipped with Mac and Windows computers for use during your Excel training class. It is strongly recommend that you have a personal installation of Excel to use directly after your training. Links are above.
Course materials for Excel classes
The instructors at AMT are professionals in their respective fields, and really enjoy teaching and passing on their skills to others. Excel course participants will receive a Excel course manual as part of the class and you are naturally welcome to take any notes. Our online sessions can also be recorded for later viewing. If you would like to record your Excel Training Class, just let your trainer know when you begin your training.
Excel Certification Training
These Excel courses are the perfect preparation to become a Microsoft Office Specialist
Excel Class Reviews and Testimonials
Excel is used by almost every computer user. Simply put if you want to be employed or run your own business, knowledge of Excel is imperative. We cannot show you all our clients and their reviews on our site, and you can view a sample by using this link, however if you contact us directly, we will be happy to put in you in touch with some of our students who have taken our Excel online class
Your Excel Class is guaranteed to run
There are many training companies who offer Excel training classes either online or in-person but cancel them due to low enrolment, this will not happen when you book a private Excel class with AMT.
Excel Private
Class Benefits
You have a certified instructor all to yourself
We go at your pace as it is a private class
The course is customized to your specific objectives and needs
The dates and even times are flexible to suit your schedule
Work with your own content or projects
There is no travel time or associated costs
The price is the same or less than attending a public class with other students who may have different agenda’s and skill levels to your own
Excel Tips & Tricks
When used in a formula, such as =SUM($A$5=$A$7), it makes sure that the exact column and row are held the same even if you copy the same formula in adjacent rows.
–O–
If you need to remove duplicate data, highlight the row or column that you want to remove duplicates of. Then, go to the Data tab, and select “Remove Duplicates” (under Tools). A pop-up will appear to confirm which data you want to work with. Select “Remove Duplicates,” and you’re good to go
–O–
When using formulas, use parenthesis to ensure certain calculations are done first
–O–
You can use dollar signs to keep one cell’s formula the same regardless of where it moves.
World Class Tutors
You can rely on the expertise of our instructors. We have delivered hundreds of classes to thousands of students over 15 years
Support
When you attend our class, all students receive class materials, a certificate on completion and 3 months support from our certified instructors.
Risk Free
We guarantee your training and offer all our student a full refund if they are not satisfied with their training experience within the first 2 hours of training.