MS Excel Fundamentals: The Complete Beginner's Guide
- Description
- Curriculum
- FAQ
- Reviews
Master Microsoft Excel: Beginner to Expert All-in-One Course
Unlock the full potential of Microsoft Excel in this comprehensive course designed to take you from beginner to advanced—plus expert-level tools like Macros and VBA. Perfect for any version from Microsoft Excel 2007 to 2024, this course bundles four intensive classes into one powerful package.
What You’ll Learn
Whether you’re just starting or looking to automate your workflow, we’ve got you covered:
-
Building organized and effective spreadsheets
-
Managing and analyzing large data sets with ease
-
Mastering essential Excel functions like SUM, VLOOKUP, IF, and INDEX/MATCH
-
Including new Microsoft 365 Functions like XLOOKUP, SWITCH, TEXTSPLIT and more
-
-
Creating dynamic reports with PivotTables
-
Harnessing PowerPivot for more advanced data modeling
-
Cleaning and auditing formulas to ensure accuracy
-
Automating tasks with Macros and VBA
What’s Included?
-
22+ hours of in-depth video instruction led by a Microsoft Certified Trainer
-
Downloadable exercise files to follow along and practice
-
Section quizzes to reinforce learning
-
An interactive Q&A board for questions and support
Student Success Story
-
“This course is amazing. Not everyone has the gift of teaching, but Kyle truly makes Excel easy and engaging. I now know Excel better than ever and feel ready to tackle any project!”
-
“This course made me an Excel pro! I was a total beginner, and now I feel confident tackling any Excel task. Kyle’s course is well-structured and easy to follow—highly recommend!”
-
“Excel has been a mystery to me until this course! Kyle’s teaching made it simple to understand. If you’re hesitant, don’t be—this is the course to buy!”
Take the next step in mastering Excel. Enroll now and transform from an Excel novice to an Excel expert!
-
1Ask QuestionsVideo lesson
Participants are encouraged to ask questions throughout the course to enhance their understanding.
-
2Course Exercise FilesVideo lesson
Downloadable exercise files are provided to facilitate hands-on learning.
-
3Certificate of CompletionVideo lesson
Upon course completion, participants have the opportunity to earn a certificate as recognition.
-
4Launching ExcelVideo lesson
Learn how to open Microsoft Excel and access its features.
-
5Microsoft Excel Startup ScreenVideo lesson
Explore the initial screen and its functionalities.
-
6Introduction to the Excel InterfaceVideo lesson
Get acquainted with the Excel user interface.
-
7TIP - Hide Excel RibbonVideo lesson
-
8TIP - Customizing the Excel Quick Access ToolbarVideo lesson
Discover how to personalize the Quick Access Toolbar for efficiency.
-
9More on the Excel Interface (Workbook and Status Bar)Video lesson
Dive deeper into Excel's interface components.
-
10Understanding the Structure of an Excel WorkbookVideo lesson
Gain insight into the structure of Excel workbooks.
-
11Saving an Excel DocumentVideo lesson
Understand the process of saving Excel files.
-
12Opening an Existing Excel DocumentVideo lesson
Learn how to access and work with previously created Excel files.
-
13Common Excel Shortcut KeysVideo lesson
Master essential keyboard shortcuts for increased productivity.
-
14Excel Fundamentals QuizQuiz
Test your knowledge of Excel fundamentals through a quiz.
-
15Entering Text to Create Excel Spreadsheet TitlesVideo lesson
Explore techniques for entering text to create informative spreadsheet titles.
-
16Working with Numeric Data in ExcelVideo lesson
Understand how to input and manipulate numeric data effectively.
-
17Entering Date Values in ExcelVideo lesson
Learn the ins and outs of entering date values accurately.
-
18Working with Cell ReferencesVideo lesson
Master the use of cell references in Excel formulas.
-
19Creating Basic Formulas in ExcelVideo lesson
Get hands-on experience in creating basic Excel formulas.
-
20Relative Versus Absolute Cell References in FormulasVideo lesson
Differentiate between relative and absolute cell references.
-
21Understanding the Order of Operation (DOWNLOAD EXERCISE FILE)Video lesson
Grasp the order in which Excel calculates formula operations.
-
22Entering and Editing Text and Formulas QuizQuiz
Assess your proficiency with a quiz on text and formula entry and editing.
-
23The structure of an Excel FunctionVideo lesson
Learn about the components and structure of Excel functions.
-
24Working with the SUM() FunctionVideo lesson
Understand how to use the SUM function to total values.
-
25Working with the MIN() and MAX() FunctionsVideo lesson
Explore the MIN and MAX functions for finding minimum and maximum values.
-
26Working with the AVERAGE() FunctionVideo lesson
Discover how to calculate averages using the AVERAGE function.
-
27Working with the COUNT() FunctionVideo lesson
Learn to count cells containing data with the COUNT function.
-
28Adjacent Cells Error in Excel CalculationsVideo lesson
Understand and troubleshoot errors that may occur in Excel calculations.
-
29Using the AutoSum CommandVideo lesson
Simplify summation with the AutoSum command.
-
30Excel's AutoSum Shortcut KeyVideo lesson
Speed up calculations with a handy keyboard shortcut.
-
31Using the AutoFill Command to Copy FormulasVideo lesson
Efficiently replicate formulas using the AutoFill command.
-
32Basic Excel Functions QuizQuiz
Test your knowledge of basic Excel functions with an interactive quiz.
-
33Moving and Copying Data in an Excel WorksheetVideo lesson
Learn how to rearrange and duplicate data within a worksheet.
-
34Inserting and Deleting Rows and ColumnsVideo lesson
Discover methods for adding or removing rows and columns.
-
35Changing the Width and Height of CellsVideo lesson
Customize cell dimensions to accommodate your data.
-
36Hiding and Unhiding Excel Rows and ColumnsVideo lesson
Control the visibility of rows and columns as needed.
-
37Renaming an Excel WorksheetVideo lesson
Learn how to rename worksheets to improve organization.
-
38Deleting an Excel WorksheetVideo lesson
Explore the process of removing unnecessary worksheets.
-
39Moving and Copying an Excel WorksheetVideo lesson
Master techniques for relocating or duplicating entire worksheets.
-
40Modifying Worksheets QuizQuiz
Test your skills in worksheet modification through a quiz.
-
41Working with Font Formatting CommandsVideo lesson
Explore font formatting options to style your text.
-
42Changing the Background Color of a CellVideo lesson
Customize cell backgrounds for visual impact.
-
43Adding Borders to CellsVideo lesson
Apply borders to cells for improved data separation.
-
44Excel Cell Borders ContinuedVideo lesson
Delve deeper into cell border formatting.
-
45Formatting Data as Currency ValuesVideo lesson
Format numbers as currency for financial presentations.
-
46Formatting PercentagesVideo lesson
Learn to display numbers as percentages.
-
47Using Excel's Format PainterVideo lesson
Copy formatting from one cell to another with the Format Painter tool.
-
48Creating Styles to Format DataVideo lesson
Create and apply custom styles to format data consistently.
-
49Merging and Centering CellsVideo lesson
Combine cells and center content for neat formatting.
-
50Using Conditional FormattingVideo lesson
Apply conditional formatting rules to highlight specific data conditions.
-
51Editing Excel Conditional FormattingVideo lesson
Modify and manage conditional formatting rules.
-
52Formatting Data QuizQuiz
Assess your knowledge of Excel data formatting through a quiz.
-
53Inserting ImagesVideo lesson
Learn how to add images to Excel worksheets.
-
54Inserting Excel ShapesVideo lesson
Discover how to insert various shapes into your Excel documents.
-
55Formatting Excel ShapesVideo lesson
Customize the appearance and properties of shapes.
-
56Working with Excel SmartArtVideo lesson
Explore SmartArt graphics to visually represent information.
-
57Creating an Excel Column ChartVideo lesson
Learn to create column charts to visualize data.
-
58Working with the Excel Chart RibbonVideo lesson
Explore chart-related options in the Excel Ribbon.
-
59Adding and Modifying Data on an Excel ChartVideo lesson
Modify chart data to reflect changes in your worksheet.
-
60Formatting an Excel ChartVideo lesson
Customize chart elements for better presentation.
-
61Moving a Chart to another WorksheetVideo lesson
Relocate charts to different worksheets for organization.
-
62Working with Excel Pie ChartsVideo lesson
Create and work with pie charts to represent data.
-
63Microsoft Excel Charts Quick Guide (DOWNLOAD)Text lesson
Download a quick reference guide for Excel charts.
-
64Working with Excel Charts QuizQuiz
Test your knowledge of Excel chart creation and management.
-
65Viewing your Document in Print PreviewVideo lesson
Review how your document will appear when printed.
-
66Changing the Margins, Scaling and OrientationVideo lesson
Adjust page margins, scaling, and orientation for printing.
-
67Excel Worksheet MarginsVideo lesson
Explore margin settings for better page layout control.
-
68Working with Page Layout ViewVideo lesson
Utilize Page Layout View to optimize your worksheet for printing.
-
69Adding Header and Footer ContentVideo lesson
Include custom headers and footers in printed worksheets.
-
70Printing a Specific Range of CellsVideo lesson
Print only selected cells or ranges from your worksheet.
-
71Printing an Excel Worksheet QuizQuiz
Test your knowledge of Excel printing options and settings.
-
72Intro to Excel TemplatesVideo lesson
Understand the concept of Excel templates.
-
73Opening an Existing TemplateVideo lesson
Learn how to open pre-designed Excel templates.
-
74Creating a Custom TemplateVideo lesson
Create your own custom Excel templates to streamline tasks.
-
75Excel Templates QuizQuiz
Assess your understanding of Excel templates with a quiz.
