Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Excel in Microsoft Excel 1: beginner to Excel intermediate

Name: Excel in Microsoft Excel 1: beginner to Excel intermediate
Rating: 4.6 (2822 reviews)

Get certified! Levels 1-5 for Microsoft Excel 2007, Excel 2010, Excel 2013 and Excel 2016. Covers 77-727 and 77-420.

Created byPhillip Burton • over one million students so far, I Do Data Limited

Last updated 9/2025

English

EnglishFrench [Auto],

What you'll learn

Create, configure and save Excel worksheets and workbooks.
Navigate through and format worksheets and workbooks.
Customise options and views for worksheets and workbooks.
Configure Excel worksheets and workbooks to print (e.g. page setup).
Insert data into and format cells and ranges, and create and modify tables.
Highlight, filter, sort and group cells, ranges and tables.
Create and format Excel charts.
Insert and format objects, including modifying images.
Create formulas in Excel, including using conditional logic and modifying text.

Course content

25 sections • 174 lectures • 12h 34m total length

Introduction2:22
Welcome to Udemy0:35
Introduction to Udemy3:05
Do you want auto-translated subtitles in more languages?1:11
Curriculum6:57
Develop Excel skills from beginner to intermediate, aligned with the Microsoft Office Specialist certification, covering worksheets and workbooks, formulas and functions, tables, charts, formatting, and locale translations.

Creating new blank workbooks4:09
Create a new blank workbook in any Excel version by selecting File or Office, then New or Blank Workbook, and understand that a workbook contains worksheets, also called spreadsheets.
Entering data9:02
Enter data into cells, navigate with arrow keys, Tab and Enter; use autocomplete for speed and consistency, and press Escape to cancel; data types include text, numbers, dates, currency.
An introduction to fonts and highlighting4:23
Learn to apply front colour (text) and back colour (cell) in Excel via the Home ribbon, and master collapsing, unhide, and pin the ribbon for efficient formatting.
Saving and closing your workbook4:59
Save and close a workbook in Excel using save or save as, browse the dialog, and respond yes, no, or cancel when prompted.
Practice Activity Number 10:17
Practice Activity Number 1 - The Solution2:27
Create a new Excel workbook, enter 3, 10, and 40, color 10 yellow and 40 red, then save as My Practise Workbook and close; repeat in Excel 2010.

Creating new workbooks using templates6:07
Menus and toolbars7:16
Explore how Excel's menus and toolbars adapt to screen size, showing icons or dropdown options. Learn what each tab—home, insert, page layout, formulas, data, review, view—offers, including table tools.
Managing multiple workbooks - Excel 2013 and 20164:27
Manage multiple workbooks in Excel 2013 and 2016 by switching between windows, cascading or stacking layouts, and using the view menu to arrange, minimize, restore, or close all windows.
Managing multiple workbooks - Excel 2007 and 20107:05
Master managing multiple workbooks in Excel 2007/2010 by switching between them, minimizing and resizing windows, and using the view menu to arrange on screen.
Importing files and Opening non-native files directly in Excel7:59
Learn to import non-native files in Excel, using the Import Wizard for delimited or fixed-width text files, and open PDFs via Word before pasting into Excel.
Adding worksheets to existing workbooks3:38
Copying and moving worksheets, and changing spreadsheet order5:23
Learn how to copy and move individual or grouped worksheets, adjust spreadsheet order, and rename sheets in Excel, with practical tips on using move or copy and the group feature.

Saving workbooks in alternate file formats6:56
Save workbooks with Save and Save as, name files by date formats (British, American, Japanese); save as xlsx, xls, xlsm, xlsb, or pdf, and use tab or comma delimited formats.
Maintaining backward compatibility5:41
Learn how compatibility mode preserves legacy Excel 97–2003 files, how to convert to the new .xlsx format, and why saving as a copy protects originals while enabling newer features.
Saving files to remote locations3:15
Save excel files to remote locations using cloud storage like OneDrive, Dropbox, and SharePoint, and compare save and send with save as across Excel versions.

Using basic operators6:02
Learn how to enter and use basic formulas in Excel, including referencing other cells, operators like addition, subtraction, multiplication, division, exponents, and text in formulas with the = sign.
Order of operations5:51
Master the order of operations in Excel by learning how powers, multiply/divide, and add/subtract are evaluated, and how parentheses control the calculation, illustrated with practical examples and the PEMDAS mnemonic.
How to enter numbers and dates in Excel3:25
Referencing cell ranges in formulas10:29
Explore how to reference cell ranges in Excel formulas using cells like D2 and E2 to create dynamic, automatically updating calculations and understand precedents and dependents.
Solution to the above exercise0:27
Practice Activity Number 20:45
Practice Activity Number 2 - Solution5:52
Create and manipulate Excel workbooks across 2016 and 2010, using an invoice template, importing a tab-delimited text file, and applying formulas for powers, doubles, and division.

Searching for data within a workbook5:26
Explore how to search text across a workbook using the find dialog box and keyboard shortcuts (ctrl+f), locate and review all occurrences of 'symphony' such as 173 results.
Hyperlinks4:43
Insert hyperlinks in Excel to jump to specific cells, web pages, or files using Ctrl+K, and set the display text to link to A101.
Using Go To and Using Name Box5:23
Learn to navigate Excel with the go to box and the name box, including go to special, formulas, constants, precedents, and dependents, plus shortcuts Ctrl+G and F5.
Hot Keys3:55
Learn how to find and use the most essential Excel shortcut keys, such as ctrl+f, ctrl+g, and ctrl+k, and decide which few you should memorize to speed up work.

Changing worksheet tab colour5:25
Inserting and deleting columns and rows7:44
Master inserting and deleting columns and rows in Excel using the Home tab or right-click context menu, including multiple columns, shifting cells, and tracking with a unique ID.
Undo and Redo4:09
Learn to use undo and redo in Excel with Ctrl+Z and the Quick Access Toolbar to recover recent actions; understand that performing a new action clears the redo history.
File Management tips4:24
Learn practical file management in Excel by using date-stamped backups and multi-version saves (-2, -3, -4) to recover earlier work, restore deletions, and guard against corruption.
Adjusting row height and column width4:43
Master adjusting column width and row height in Excel by dragging the column edge, using double-click AutoFit, and setting precise sizes via the Home format options.
Hiding columns and rows3:39
Learn how to hide and unhide columns and rows in Excel, compare hiding to zero width, and use the format options to reveal hidden data without deleting it.
Selecting multiple ranges3:42
Practice Activity Number 30:24
Practice Activity Number 3 - Solution3:02
Practice activity 3 shows finding vanity with Ctrl+F, inserting a hyperlink to B15, using go to to C15, inserting a row before 15, deleting D, undoing, and coloring tab blue.

Hiding worksheets3:31
Learn how to hide and unhide worksheets in a workbook, ensure at least one sheet remains visible, and use quick right-click methods for efficient access control in Excel.
Customising the Quick Access toolbar3:25
Customize the quick access toolbar in Excel to add frequent commands like save and open using the More Commands dialog and the add and remove options.
Customising the Ribbon5:08
Learn to customize the ribbon in Excel by creating custom groups and tabs, adding commands like paste as hyperlink, and enabling the developer tag for advanced options.
Assigning shortcut keys2:49
Recording simple macros4:53
Managing macro security7:55
Save as a macro-enabled workbook (.xlsm or .xlsb) because .xlsx cannot contain macros. Use the Trust Center to manage macro settings, trusted locations, and trusted documents for secure macro use.
Changing workbook views4:13
Using zoom3:00
Adjust and compare zoom levels in Excel to view workbooks more effectively; learn to use fit selection, 100% and custom zooms, and understand that zoom affects display, not printing.
Adding values to workbook properties5:23
Learn to view and edit Excel workbook properties including title, tags, categories, authors, and custom fields via advanced properties and file info. Use tags to search in Windows Explorer.
Displaying formulas2:32
Display formulas in Excel using the Show Formulas toggle or advanced options to view formulas instead of values, and compare inconsistencies across cells.
Freezing panes4:35
Learn to freeze panes in Excel to keep header rows and labels visible while scrolling. Use top rows, left columns, or dynamic pane freezes with the cursor.
Splitting the window3:09
Practice Activity Number 40:33
Practice Activity Number 4 - The Solution3:22
Open practice file 0203, hide invoice two, record a macro to highlight C4 yellow, set zoom to 150%, add spelling to Quick Access with Alt+5, and show formulas.

Printing individual worksheets2:55
Printing an entire workbook and printing a selection2:22
Group and print multiple worksheets, print entire workbook, or print a selected range. Use shift or ctrl to select sheets, ungroup when needed, and note page setup effects.
Setting a print area4:10
Page setup, Part 1 (first two tabs)5:34
Explore page setup dialogue box and first two tabs, adjusting margins, orientation, and scaling to fit content to page sizes, and set headers, footers, and centering for print-ready Excel sheets.
Page setup, Part 2 (Repeating headers and footers)2:40
Learn to customize headers and footers in Excel, including left, center, and right sections, with odd/even and first-page options, plus scale with document and align with margins.
Adding dynamic text to headers and footers3:29
Learn to add dynamic headers and footers in Excel that show sheet names, workbook names, date and time, and page numbers using the seven header tabs.
Inserting watermarks2:58
Learn how to insert watermarks and logos in Excel headers and footers, adjust size and tone, and manage a single picture per section.
Page setup, Part 3 (Headings etc.)6:59
Explore page setup options in the page layout dialog box, including print area, repeating top rows and left columns, grid lines, and print titles for printed spreadsheets.
Configuring workbooks to print2:53
Configure workbooks for printing with uniform page setup across sheets, including orientation, margins, and header/footer. Print areas and print titles stay per sheet; create a template sheet and copy it.
Inspecting your workbook prior to distribution4:27
Learn to inspect a workbook before distribution for hidden properties, accessibility issues, and compatibility with older Excel versions, remove personal data, and save as Excel 97-2003 when needed.
Practice Activity Number 50:26
Practice Activity Number 5 - The Solution2:20
Practice activity covers setting the print area (B9:E10), 80% scale, margins centered horizontally and vertically, date/time in the footer, and repeating row eight as the print title with a preview.

Copying and pasting basics, and Utilising references (relative, mixed, absolute)8:55
Practice Activity - multiplication table2:33
Practice this activity to create a multiplication table in a spreadsheet by entering a single formula in B4 and copying it across. Master relative, mixed, and absolute cell references.
Answer - multiplication table3:07
Let's have a look at the answer to the multiplication table. Did you get it right?

Requirements

Before beginning, you will need to know how to use a Windows computer, including a mouse.
It would be good if you have used Microsoft Excel before, but this is not essential.
You should have MS Excel (or Office) 2007, 2010, 2013, 2016 or 365 installed on your computer.

Description

This course series has been recorded on Excel 2016 and Excel 2010, but the content also covers Excel 2013 and 2007.

By the end of this course, you will have the skills needed for the official Microsoft Excel Specialist exam. How would that look on your resume?

Please note: This course is not affiliated with, endorsed by, or sponsored by Microsoft.

Reviews:

"The teacher explains very well and at a good pace. Has real in-depth knowledge. The exercises are precise and well put together for the course. And the language sheets are invaluable to those that use other language than English version. I highly recommend this course. It goes thru most of the basic knowledge needed for Excel. Once again The teacher is excellent" -- Daniel Sandberg

"This is super helpful to me. I'm learning things I didn't know existed in Excel." - Jimmy Thrower

"I had to take an Excel proficiency test as a job interview requirement , and scored top 10% percentile (they called me immediately to schedule a face-to-face) , thanks to your great course for which I studied for two days straight to re-enforce my knowledge in Excel, and more importantly fill those gaps of knowledge on all its functionality capabilities . You really get the MOST out of Phillip's courses." - Rick Romero

Most people who use Excel are up to Level 3 in some aspects, and Level 2 in others. Why not go all the way to Level 5?

In this 11.5 hour course, learn how to:

Create and manage worksheets and workbooks

Create and navigate in Excel worksheets and workbooks,
Format worksheets and workbooks,
Customize options and views, and
Configure Excel worksheets and workbooks for distribution.

Manage data cells and ranges

Insert data into and format cells and ranges, and
Summarise and organize data in Excel .

Create tables

Create and manage tables,
Manage table styles and options, and
Filter and sort a table.

Perform operations with Excel formulas and functions

Summarize data,
Perform conditional operations, and
Format and modify text.
Excel Formulas such as COUNTIF, SUMIF, MIN etc. are translated into 15 different languages.

Create charts and objects

Create charts,
Format graphic elements, and
Insert and format objects in Excel .

This course teaches all the skills that Microsoft want you to know. Specifically, they are the skills required to undertake the Microsoft Certificate 77-602 (for Excel 2007), 77-882 (for Excel 2010), 77-420 (for Excel 2013) and 77-727 (for Excel 2016 Core) and will be useful if you wish to take the exam, or which to learn more about Microsoft Excel

The core skills which are taught are those tested by Microsoft in the exam. There are topics that it wants you to learn about Microsoft Excel, and this course teaches you all of them.

Each module is taught in order, and is divided in sub-topics, and generally each sub-topic will have an individual lecture lasting 5-7 minutes.

The course will take about 11 hours to complete, plus will you need additional time to test yourselves to ensure that you have learned the necessary skills.

You should take this course if:

you want to learn more about Microsoft Excel, or
you want to learn the skills you need to become a certified Microsoft Office Specialist.

Regardless whether you have Excel 2007, Excel 2010, Excel 2013, Excel 2016 or Excel 365, this course will help you get to a good level, and maybe even want you to get more!

As a bonus, there are also additional videos on:

Pivot Tables and Pivot Charts,
Sparklines,
VLOOKUP, OFFSET and INDIRECT functions.

Who this course is for:

This course is for you if you want to develop your Microsoft Excel skills.
This course will use the latest version of Excel, but is ideal for you if you use any modern version - Excel 2007, 2010, 2013, 2016 or 365.
This course is also for you if you use an older version of Microsoft Excel, but want to learn the newer versions.
This course is for you if you want to become certified in Microsoft Excel, as by the end you should the knowledge to because certified as a Microsoft specialist, if you wish to do so.
You will cover the content tested in Microsoft Office Specialist Exams 77-602 (for Excel 2007), 77-882 (for Excel 2010), 77-420 (for Excel 2013) and 77-727 (for Excel 2016 Core)
This course may not be for you if you want to learn Microsoft Excel for Macintosh computers.

Excel in Microsoft Excel 1: beginner to Excel intermediate

What you'll learn

Explore related topics

Course content

Welcome5 lectures • 14min

Level 1, Section 1 - An introduction to Excel6 lectures • 25min

Level 1, Section 2 - Create worksheets and workbooks7 lectures • 42min

Level 1, Section 3: Configure worksheets and workbooks to save3 lectures • 16min

Level 1, Section 4: Basic formulas7 lectures • 33min

Level 2, Section 1: Navigate through Excel worksheets and workbooks4 lectures • 19min

Level 2, Section 2: Format worksheets and workbooks9 lectures • 37min

Level 2, Section 3: Customise options and views for worksheets and workbooks14 lectures • 54min

Level 2, Section 4: Configure Excel worksheets and workbooks to print12 lectures • 41min

Level 2, Section 5: Utilise cell ranges and references in formulas and functions3 lectures • 15min

Requirements

Description

Who this course is for: