Microsoft Excel - Excel from Beginner to Advanced
- Description
- Curriculum
- FAQ
- Reviews
Microsoft Excel all in One Package
Topics covered in this course apply to Excel 2007, 2010, 2013, 2016, 2019 (Microsoft/Office 365)/2023
This Microsoft Excel course combines 4 different courses.
-
Microsoft Excel 101 – An Introduction to Excel
-
Microsoft Excel 102 – Intermediate Level Excel
-
Microsoft Excel 103 – Advanced Level Excel
-
Master Microsoft Excel Macros and VBA in 6 Simple Projects
Recent Student Review
-
“You sir are a life saver. Not everyone has the ability to teach. Thank you so much for taking the time to put together an amazing course bro. If anyone doubts buying this course, don’t doubt it, buy it. I’ve learned so much in this course. Hope more courses are on the way because I’d buy every single one of them. Thanks again bro. God bless you and your family.“
-
“Happy to say that I now “know” excel. I realize there is so much more to learn, but it’s a start! Thank you for being such a great instructor… now on to the next class.“
-
“Thanks for a well made course. The progression of topics is well structured and the part about Macro and VBA was new for me. Excel is a really powerful tool and it is worth know all of its aspects. Kyle did a good job at explaining them.“
Enroll now to go through a deep dive of the most popular spreadsheet tool on the market, Microsoft Excel. As a Microsoft Certified Trainer I will use my 20+ years of Excel training to guide you step by step through the beginner to advanced level and beyond.
As you participate in each of the 4 courses you will master Excel tools that will clear away the pain of stumbling through your daily tasks. You will start with the basics, building a solid foundation that will give you further knowledge as you progress into intermediate and advanced level topics.
At completion of this course you will have mastered the most popular Excel tools and come out with confidence to complete any Excel tasks with efficiency and grace. Below are just a few of the topics that you will master:
-
Creating effective spreadsheets
-
Managing large sets of data
-
Mastering the use of some of Excel’s most popular and highly sought after functions (SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH and many more…)
-
Create dynamic report with Excel PivotTables
-
Unlock the power and versatility of Microsoft Excel’s Add-In, PowerPivot
-
Audit Excel Worksheet formulas to ensure clean formulas
-
Automate your day to day Excel tasks by mastering the power of Macros and VBA
What’s Included?
-
18+ Hours of Step by Step Video Lectures by a Microsoft Certified Trainer (MCT)
-
Downloadable Exercise Files to follow along and practice with
-
Additional Exercise Files are provided at the end of each major section (101, 102, 103 and VBA) that you can download and practice the skills you’ve learned
-
Section Quizzes to Test Your Knowledge on the Lecture Topics
-
QA board where you can post questions, screenshots of your progress and communicate with the instructor and fellow students in the course.
So, what are you waiting for, enroll now and take the next step in mastering Excel and go from Excel Newb to Excel Guru!
-
1
Ask QuestionsParticipants are encouraged to ask questions throughout the course to enhance their understanding.
-
2
Course Exercise Files
Downloadable exercise files are provided to facilitate hands-on learning.
-
3
Certificate of Completion
Upon course completion, participants have the opportunity to earn a certificate as recognition.
-
4
Launching Excel
Learn how to open Microsoft Excel and access its features.
-
5
Microsoft Excel Startup Screen
Explore the initial screen and its functionalities.
-
6
Introduction to the Excel Interface
Get acquainted with the Excel user interface.
-
7
Customizing the Excel Quick Access Toolbar
Discover how to personalize the Quick Access Toolbar for efficiency.
-
8
More on the Excel Interface
Dive deeper into Excel's interface components.
-
9
Understanding the Structure of an Excel Workbook
Gain insight into the structure of Excel workbooks.
-
10
Saving an Excel Document
Understand the process of saving Excel files.
-
11
Opening an Existing Excel Document
Learn how to access and work with previously created Excel files.
-
12
Common Excel Shortcut Keys
Master essential keyboard shortcuts for increased productivity.
-
13
Excel Fundamentals QuizTest your knowledge of Excel fundamentals through a quiz.
-
14
Entering Text to Create Spreadsheet Titles
Explore techniques for entering text to create informative spreadsheet titles.
-
15
Working with Numeric Data in Excel
Understand how to input and manipulate numeric data effectively.
-
16
Entering Date Values in Excel
Learn the ins and outs of entering date values accurately.
-
17
Working with Cell References
Master the use of cell references in Excel formulas.
-
18
Creating Basic Formulas in Excel
Get hands-on experience in creating basic Excel formulas.
-
19
Relative Versus Absolute Cell References in Formulas
Differentiate between relative and absolute cell references.
-
20
Understanding the Order of Operation (DOWNLOAD EXERCISE FILE)
Grasp the order in which Excel calculates formula operations.
-
21
Entering and Editing Text and Formulas Quiz
Assess your proficiency with a quiz on text and formula entry and editing.
-
22
The structure of an Excel Function
Learn about the components and structure of Excel functions.
-
23
Working with the SUM() Function
Understand how to use the SUM function to total values.
-
24
Working with the MIN() and MAX() Functions
Explore the MIN and MAX functions for finding minimum and maximum values.
-
25
Working with the AVERAGE() Function
Discover how to calculate averages using the AVERAGE function.
-
26
Working with the COUNT() Function
Learn to count cells containing data with the COUNT function.
-
27
Adjacent Cells Error in Excel Calculations
Understand and troubleshoot errors that may occur in Excel calculations.
-
28
Using the AutoSum Command
Simplify summation with the AutoSum command.
-
29
Excel's AutoSum Shortcut Key
Speed up calculations with a handy keyboard shortcut.
-
30
Using the AutoFill Command to Copy Formulas
Efficiently replicate formulas using the AutoFill command.
-
31
Basic Excel Functions Quiz
Test your knowledge of basic Excel functions with an interactive quiz.
-
32
Moving and Copying Data in an Excel Worksheet
Learn how to rearrange and duplicate data within a worksheet.
-
33
Inserting and Deleting Rows and Columns
Discover methods for adding or removing rows and columns.
-
34
Changing the Width and Height of Cells
Customize cell dimensions to accommodate your data.
-
35
Hiding and Unhiding Excel Rows and Columns
Control the visibility of rows and columns as needed.
-
36
Renaming an Excel Worksheet
Learn how to rename worksheets to improve organization.
-
37
Deleting an Excel Worksheet
Explore the process of removing unnecessary worksheets.
-
38
Moving and Copying an Excel Worksheet
Master techniques for relocating or duplicating entire worksheets.
-
39
Modifying Worksheets Quiz
Test your skills in worksheet modification through a quiz.
-
40
Working with Font Formatting Commands
Explore font formatting options to style your text.
-
41
Changing the Background Color of a Cell
Customize cell backgrounds for visual impact.
-
42
Adding Borders to Cells
Apply borders to cells for improved data separation.
-
43
Excel Cell Borders Continued
Delve deeper into cell border formatting.
-
44
Formatting Data as Currency Values
Format numbers as currency for financial presentations.
-
45
Formatting Percentages
Learn to display numbers as percentages.
-
46
Using Excel's Format Painter
Copy formatting from one cell to another with the Format Painter tool.
-
47
Creating Styles to Format Data
Create and apply custom styles to format data consistently.
-
48
Merging and Centering Cells
Combine cells and center content for neat formatting.
-
49
Using Conditional Formatting
Apply conditional formatting rules to highlight specific data conditions.
-
50
Editing Excel Conditional Formatting
Modify and manage conditional formatting rules.
-
51
Formatting Data Quiz
Assess your knowledge of Excel data formatting through a quiz.
-
52
Inserting Images
Learn how to add images to Excel worksheets.
-
53
Inserting Excel Shapes
Discover how to insert various shapes into your Excel documents.
-
54
Formatting Excel Shapes
Customize the appearance and properties of shapes.
-
55
Working with Excel SmartArt
Explore SmartArt graphics to visually represent information.
-
56
Creating an Excel Column Chart
Learn to create column charts to visualize data.
-
57
Working with the Excel Chart Ribbon
Explore chart-related options in the Excel Ribbon.
-
58
Adding and Modifying Data on an Excel Chart
Modify chart data to reflect changes in your worksheet.
-
59
Formatting an Excel Chart
Customize chart elements for better presentation.
-
60
Moving a Chart to another Worksheet
Relocate charts to different worksheets for organization.
-
61
Working with Excel Pie Charts
Create and work with pie charts to represent data.
-
62
Microsoft Excel Charts Quick Guide (DOWNLOAD)Download a quick reference guide for Excel charts.
-
63
Working with Excel Charts Quiz
Test your knowledge of Excel chart creation and management.
-
64
Viewing your Document in Print Preview
Review how your document will appear when printed.
-
65
Changing the Margins, Scaling and Orientation
Adjust page margins, scaling, and orientation for printing.
-
66
Excel Worksheet Margins
Explore margin settings for better page layout control.
-
67
Working with Page Layout View
Utilize Page Layout View to optimize your worksheet for printing.
-
68
Adding Header and Footer Content
Include custom headers and footers in printed worksheets.
-
69
Printing a Specific Range of Cells
Print only selected cells or ranges from your worksheet.
-
70
Printing an Excel Worksheet Quiz
Test your knowledge of Excel printing options and settings.
-
71
Intro to Excel Templates
Understand the concept of Excel templates.
-
72
Opening an Existing Template
Learn how to open pre-designed Excel templates.
-
73
Creating a Custom Template
Create your own custom Excel templates to streamline tasks.
-
74
Excel Templates Quiz
Assess your understanding of Excel templates with a quiz.
