Your cart is empty.
Keep shopping
Teach on Udemy
Turn what you know into an opportunity and reach millions around the world.
Learn MoreMicrosoft Excel 2010 Training - Beginner to Advanced
Rating: 4.5 out of 54.5(61 ratings)
1,970 students
Microsoft Excel 2010 Training - Beginner to Advanced
This course will teach you Excel 2010 from the absolute basics through to the most powerful and advanced topics.
Created byVideoTraining Online
Last updated 2/2019
English
What you'll learn
- By the end of this course you will be very comfortable with all aspects of Microsoft Excel 2010
Explore related topics
Course content
12 sections • 158 lectures • 11h 44m total length
- Welcome to Excel 20101:25Welcome to Excel 2010! The journey begins here.
- Starting Excel 20102:55Starting with the absolute basics, we look at how to start the application and also how to add shortcuts to the desktop and Task Bar for fast and easy access.
- Understanding the new Excel 2010 Screen Layout8:54Excel 2010 Screen Layout - There have been a number of changes in this release, so let's take a look at some of them.
- Introducing the new File Tab and Backstage View14:47Introducing the File Tab and the new Backstage View
- Excel 2010 work file to be downloaded and used throughout this course.0:06Excel 2010 work file to be downloaded and used for practice during the training course.
- Introducing the new Office 2010 file format4:49Introducing the new Office 2010 file format - Learn why the new file format is much better than the old format.
- Creating and saving a new workbook4:39Creating and saving a new workbook
- Opening an existing workbook1:35How to open an existing workbook
- Creating a new workbook from a template5:01Creating a new workbook from a template
- Saving a workbook as a template3:41Saving a workbook as a template
- Opening a workbook using different options5:25Opening a workbook using different options - Learn some of the more advanced and useful options when opening files.
- Using SAVE AS to create a new workbook1:30Using SAVE AS to create a new workbook
- Saving a Excel 2010 workbook in Excel 2003 format2:28Saving a Excel 2010 workbook in Excel 2003 format
- Saving a workbook as a PDF file2:33Saving a workbook as a PDF file
- Saving a workbook in web page format (HTML)3:50Saving a workbook in web page format (HTML)
- Printing workbooks4:30Printing workbooks - Printing is so much more straight forward in Excel 2010. A welcome addition.
- Understanding text versus numeric cell entries5:40Understanding text versus numeric cell entries
- Introducing the Quick Access Toolbar6:43Introducing the Quick Access Toolbar
- How to minimize the Office Ribbon2:40How to minimize the Office Ribbon - Useful to know if you would like to use more of the screen for your work.
- Navigating the Office Ribbon using the keyboard3:45Navigating the Office Ribbon using the keyboard
- Navigating around worksheets using the keyboard5:18Navigating worksheets using the keyboard
- Managing worksheets4:17Managing worksheets
- Introducing the Mini Toolbar3:37Introducing the Mini Toolbar
- Getting to know the Formula Bar5:35Getting to know the Formula Bar
- How to select cells in different ways4:49How to select cells in different ways
- Resizing rows and columns2:13Resizing rows and columns
- Using AutoCorrect2:52Using AutoCorrect
- Using AutoComplete2:24Using AutoComplete
- Using AutoFill6:50Using AutoFill - Your new best friend.
- Inserting and deleting cells, rows and columns3:25Inserting and deleting cells, rows and columns
- A closer look at Cut, Copy and Paste7:34A closer look at Cut, Copy and Paste
- Understanding Excel Operators5:46Understanding Excel Operators
- A refresher course in the Order of Operations4:46A refresher course in the Order of Operations
- Multi-User editing using the new Office Web Apps3:50Multi-user editing using the new Office Web Apps
- Getting the most from the Office Clipboard7:43Getting the most from the Office Clipboard
- Working with the Format Painter3:14Saving time with the Format Painter
- Understanding the Font Group commands5:03Understanding the Font Group commands
- Understanding the Alignment Group commands2:43Understanding the Alignment Group commands
- Merging cells and wrapping text entries4:56Merging cells and wrapping text
- Understanding the Number Group commands6:32Understanding the Number Group commands
- Introducing Conditional Formatting9:08Introducing Conditional Formatting
- Working with Table Styles5:14Working with Table Styles
- Table Style formatting options5:22Table formatting options
- Working with Cell Styles5:16Working with Cell Styles
- Introducing Sparklines8:49Introducing Sparklines
- Adjusting rows and columns using the Office Ribbon4:36Adjusting rows and columns using the Office Ribbon
- How to hide and un-hide rows, columns and worksheets3:25How to hide and un-hide rows, columns and worksheets
- Managing worksheets using the Office Ribbon1:38Managing worksheets using the Office Ribbon
- Clearing cell content and formatting3:24Clearing cell contents and formatting
- Sorting and filtering information6:01Sorting and filtering information
- Using the Find and Replace tools7:57Using the Find and Replace tools
- Using the Select Objects tool2:50Using the Select Objects tool
- Working with the Selection Pane4:08Working with the Selection Pane
- Inserting a picture into a worksheet13:46Inserting pictures into worksheets
- Understanding the new picture editing tools4:19Understanding the new picture editing tools
- Inserting and working with ClipArt5:54Inserting and working with Clipart
- Inserting and working with Shapes6:50Inserting and working with Shapes
- Introducing SmartArt graphics6:20Introducing SmartArt graphics
- Introducing the new Screenshot tool4:31Introducing the new Screenshot tool
- Using different types of Hyperlinks7:27Using different types of Hyperlinks
- Working with Text Boxes5:05Working with Text Boxes
- Inserting Headers and Footers into worksheets5:42Inserting Headers and Footers into worksheets
- Working with WordArt5:52Working with WordArt
- Inserting Equations and Symbols3:43Inserting Equations and Symbols
- Utilising Office Themes3:37
Using Office Themes
- Adjusting Page Margins and Orientation4:32Adjusting Page Margins and Orientation
- Changing the Page Size and Print Area5:05Changing the Page Size and Print Area
- Working with Page Breaks3:50Working with Page Breaks
- Adding a worksheet background image1:19Adding a worksheet background image
- Adding column and row headings to reports2:46Adding column and row headings to reports
- Using Gridline and Heading options2:23Using Gridline and Heading options
- Working with different Excel Views5:27Working with different Excel Views
- Working with the Show and Zoom commands2:17Working with the Show and Zoom commands
- Managing multiple workbook windows4:40Managing multiple workbook windows
- Freezing rows and columns6:11Freezing rows and columns
- Comparing workbooks side by side2:57Comparing workbooks side by side
- Using the Spelling Checker and other proofing tools8:36Using the Spelling Checker and other proofing tools
- Inserting and managing worksheet Comments4:10Working with Comments
- Protecting worksheets3:40Protecting worksheets
- Protecting workbooks3:37Protecting workbooks
- Sharing workbooks to allow multi-user editing10:20
Allowing multi-user editing of workbooks
- Using Mark As Final2:47
Using Mark As Final
- Password protecting your workbooks2:59Password protecting your workbooks
- Other ways to protect worksheets and workbooks1:50Other ways to protect your work
- Information Rights Management and Digital Signatures2:17IRM, DRM and Digital Signatures
- Using the Document Inspector3:09The Document Inspector
- Using the Accessibility Checker2:53Using the Accessibility Checker
- Working with the Protected View feature3:11Working with Protected View
- How to insert a Chart4:13How to insert a chart
- Chart Basics3:20Chart Basics
- Modifying the chart design6:32Modifying the chart design
- Modifying the chart layout9:41Modifying the chart layout
- Chart formatting options6:35Chart formatting options
- Chart formatting tips and techniques2:19Chart formatting tips
- Changing the default chart type1:30Changing the default chart type
- The fastest way to insert a chart2:09The fastest way to insert a chart
- Creating and using chart templates3:06Creating and using chart templates
- Advanced data selection techniques2:26Advanced data selection techniques
- Recording a basic macro8:46Recording a basic macro
- Saving a macro enabled workbook2:00Saving a macro enabled workbook
- Macro security settings4:01Macro Security Settings
- Absolute versus Relative cell referencing3:50Absolute versus Relative cell referencing
- Assigning a macro to a button4:41Assigning a macro to a button
- Adding a macro to the Quick Access Toolbar2:22Adding a macro to the Quick Access Toolbar
- Editing a macro8:53Editing a macro
- Troubleshooting a macro5:36Troubleshooting a macro
- Enabling the Developer Tab2:08Enabling the Developer Tab
- Introducing Pivot Tables5:05Introducing Pivot Tables - They aren't so scary after all!
- A quick look around a Pivot Table1:30
A quick look around Pivot Tables
- Adding data to Pivot Tables4:59Adding data to Pivot Tables
- Removing and customizing report data2:17Customizing Report Data
- Formatting Pivot Table information3:51Formatting Pivot Table Information
- Sorting and filtering data6:28Sorting and filtering data
- Working with Report Filters4:08Working with Report Filters
- Customizing the Pivot Table screen layout4:25Customizing the Pivot Table screen layout
- Basic Pivot Table options3:45Basic Pivot Table options
- Working with Report Filter page options4:25Working with Report Filter page options
- Pivot Table configuration options11:26Pivot Table configuration options
- Drilling down into Pivot Table data1:32Drilling down into Pivot Table data
- Data calculation options3:32Data calculation options
- Grouping Pivot Table data5:30Grouping Pivot Table data
- Grouping options relating to Date information5:16Grouping options relating to date information
- Refreshing and modifying source data5:08Refreshing and modifying source data
- How to move a Pivot Table6:50Moving a Pivot Table
- Inserting a Pivot Chart4:12Inserting a Pivot Chart
- How to create a Calculated Field4:05How to create a Calculated Field
- Working with Pivot Table Styles2:19Working with Pivot Table Styles
- Introducing the new Slicer tool6:05Introducing the Slicer tool
- How to insert a Pivot Chart using the Office Ribbon6:39Inserting a Pivot Chart using the Office Ribbon
- Introducing Formulas and Functions7:37Introducing Formulas and Functions
- Formula and function basics5:28Formula and Function Basics
- How to use the SUM function4:59How to use the SUM function
- Understanding Absolute and Relative cell referencing3:15Understanding Absolute and Relative cell referencing
- How to use the CONCATENATE function2:19How to use the CONCATENATE function
- How to use the SUMIF function4:49How to use the SUMIF function
- How to use the VLOOKUP function4:45How to use the VLOOKUP function
- How to use the TRIM function3:47How to use the TRIM function
- How to use the RANDBETWEEN function3:03How to use the RANDBETWEEN function
- How to use the COUNTIF function6:12How to use the COUNTIF function
- How to use the PMT function3:06How to use the PMT function
- Formula auditing tools3:43Formula auditing tools
- Error checking tools for formulas1:06Error Checking formulas
- Evaluating Formulas1:16Evaluating formulas
- Using the Watch Window2:06Using the Watch Window
Requirements
- Basic computing skills
Description
Microsoft Excel is the most used computer application in the world. Because of this, Excel skills are in high demand by businesses of all sizes.
This structured training course will teach you how to use Microsoft Excel 2010 from the most basic of concepts through to the most advanced features.
Each topic in this course is presented in a separate video lesson, allowing you to learn as much or as little as you like at a time. You are also able to watch videos as many times as you like if you need to.
Regardless of your current skill level, this course will teach you how to save time and also get the most from Excel 2010.
Watch your productivity and creativity go through the roof!
Enjoy.
Who this course is for:
- All skill levels