Microsoft Excel - Excel from Beginner to Advanced
- Descrição
- Currículo
- FAQ
- Revisões
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!
-
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
TIP - Hide Excel Ribbon
-
8
TIP - Customizing the Excel Quick Access Toolbar
Discover how to personalize the Quick Access Toolbar for efficiency.
-
9
More on the Excel Interface (Workbook and Status Bar)
Dive deeper into Excel's interface components.
-
10
Understanding the Structure of an Excel Workbook
Gain insight into the structure of Excel workbooks.
-
11
Saving an Excel Document
Understand the process of saving Excel files.
-
12
Opening an Existing Excel Document
Learn how to access and work with previously created Excel files.
-
13
Common Excel Shortcut Keys
Master essential keyboard shortcuts for increased productivity.
-
14
Excel Fundamentals QuizTest your knowledge of Excel fundamentals through a quiz.
-
15
Entering Text to Create Excel Spreadsheet Titles
Explore techniques for entering text to create informative spreadsheet titles.
-
16
Working with Numeric Data in Excel
Understand how to input and manipulate numeric data effectively.
-
17
Entering Date Values in Excel
Learn the ins and outs of entering date values accurately.
-
18
Working with Cell References
Master the use of cell references in Excel formulas.
-
19
Creating Basic Formulas in Excel
Get hands-on experience in creating basic Excel formulas.
-
20
Relative Versus Absolute Cell References in Formulas
Differentiate between relative and absolute cell references.
-
21
Understanding the Order of Operation (DOWNLOAD EXERCISE FILE)
Grasp the order in which Excel calculates formula operations.
-
22
Entering and Editing Text and Formulas Quiz
Assess your proficiency with a quiz on text and formula entry and editing.
-
23
The structure of an Excel Function
Learn about the components and structure of Excel functions.
-
24
Working with the SUM() Function
Understand how to use the SUM function to total values.
-
25
Working with the MIN() and MAX() Functions
Explore the MIN and MAX functions for finding minimum and maximum values.
-
26
Working with the AVERAGE() Function
Discover how to calculate averages using the AVERAGE function.
-
27
Working with the COUNT() Function
Learn to count cells containing data with the COUNT function.
-
28
Adjacent Cells Error in Excel Calculations
Understand and troubleshoot errors that may occur in Excel calculations.
-
29
Using the AutoSum Command
Simplify summation with the AutoSum command.
-
30
Excel's AutoSum Shortcut Key
Speed up calculations with a handy keyboard shortcut.
-
31
Using the AutoFill Command to Copy Formulas
Efficiently replicate formulas using the AutoFill command.
-
32
Basic Excel Functions Quiz
Test your knowledge of basic Excel functions with an interactive quiz.
-
33
Moving and Copying Data in an Excel Worksheet
Learn how to rearrange and duplicate data within a worksheet.
-
34
Inserting and Deleting Rows and Columns
Discover methods for adding or removing rows and columns.
-
35
Changing the Width and Height of Cells
Customize cell dimensions to accommodate your data.
-
36
Hiding and Unhiding Excel Rows and Columns
Control the visibility of rows and columns as needed.
-
37
Renaming an Excel Worksheet
Learn how to rename worksheets to improve organization.
-
38
Deleting an Excel Worksheet
Explore the process of removing unnecessary worksheets.
-
39
Moving and Copying an Excel Worksheet
Master techniques for relocating or duplicating entire worksheets.
-
40
Modifying Worksheets Quiz
Test your skills in worksheet modification through a quiz.
-
41
Working with Font Formatting Commands
Explore font formatting options to style your text.
-
42
Changing the Background Color of a Cell
Customize cell backgrounds for visual impact.
-
43
Adding Borders to Cells
Apply borders to cells for improved data separation.
-
44
Excel Cell Borders Continued
Delve deeper into cell border formatting.
-
45
Formatting Data as Currency Values
Format numbers as currency for financial presentations.
-
46
Formatting Percentages
Learn to display numbers as percentages.
-
47
Using Excel's Format Painter
Copy formatting from one cell to another with the Format Painter tool.
-
48
Creating Styles to Format Data
Create and apply custom styles to format data consistently.
-
49
Merging and Centering Cells
Combine cells and center content for neat formatting.
-
50
Using Conditional Formatting
Apply conditional formatting rules to highlight specific data conditions.
-
51
Editing Excel Conditional Formatting
Modify and manage conditional formatting rules.
-
52
Formatting Data Quiz
Assess your knowledge of Excel data formatting through a quiz.
-
53
Inserting Images
Learn how to add images to Excel worksheets.
-
54
Inserting Excel Shapes
Discover how to insert various shapes into your Excel documents.
-
55
Formatting Excel Shapes
Customize the appearance and properties of shapes.
-
56
Working with Excel SmartArt
Explore SmartArt graphics to visually represent information.
-
57
Creating an Excel Column Chart
Learn to create column charts to visualize data.
-
58
Working with the Excel Chart Ribbon
Explore chart-related options in the Excel Ribbon.
-
59
Adding and Modifying Data on an Excel Chart
Modify chart data to reflect changes in your worksheet.
-
60
Formatting an Excel Chart
Customize chart elements for better presentation.
-
61
Moving a Chart to another Worksheet
Relocate charts to different worksheets for organization.
-
62
Working with Excel Pie Charts
Create and work with pie charts to represent data.
-
63
Microsoft Excel Charts Quick Guide (DOWNLOAD)Download a quick reference guide for Excel charts.
-
64
Working with Excel Charts Quiz
Test your knowledge of Excel chart creation and management.
-
65
Viewing your Document in Print Preview
Review how your document will appear when printed.
-
66
Changing the Margins, Scaling and Orientation
Adjust page margins, scaling, and orientation for printing.
-
67
Excel Worksheet Margins
Explore margin settings for better page layout control.
-
68
Working with Page Layout View
Utilize Page Layout View to optimize your worksheet for printing.
-
69
Adding Header and Footer Content
Include custom headers and footers in printed worksheets.
-
70
Printing a Specific Range of Cells
Print only selected cells or ranges from your worksheet.
-
71
Printing an Excel Worksheet Quiz
Test your knowledge of Excel printing options and settings.
-
72
Intro to Excel Templates
Understand the concept of Excel templates.
-
73
Opening an Existing Template
Learn how to open pre-designed Excel templates.
-
74
Creating a Custom Template
Create your own custom Excel templates to streamline tasks.
-
75
Excel Templates Quiz
Assess your understanding of Excel templates with a quiz.
