Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
Just about everyone will find him or herself having to use Microsoft Excel at work at one point or another, and Excel 2010 is one of the most popular and powerful versions around. That means that everyone could benefit from devoting some time to mastering the program. Excel mastery will not only have a huge impact on your own productivity, but also it can look hugely impressive to your boss.
With our Ultimate Microsoft Excel 2010 Training Course, you’ll find basic and advanced courses for Microsoft Excel 2010.
This bundle includes:
Courses included with this bundle:
Learn Microsoft Excel 2010 for Beginners
Our professional instructor will talk you through Excel 2010’s features, starting with the basics like creating files to editing existing documents. Secondly, you’ll move onto moving and managing data across rows and columns, as well as different sheets, in addition to introducing your first formulas. Formatting workbooks comes next, in addition to adding attractive charts and graphs to display your work. You’ll then progress to sorting and filtering data, linking multiple files and, finally, working with some more advanced formulas.
Learn Microsoft Excel 2010 - Advanced
Discover methods to make your exceptions stand out so you can attack the anomalies and use the data to make your operations better. During this Advanced level course, Excel’s tools are covered in depth and include discussions on setting up live charts, Sparklines, color scales, and icon sets. Your data will become alive as you identify key action items and understand the meaning behind the numbers. Learn how to use Pivot Tables combined with Pivot Charts in powerful ways. By the end of this course, you will be able to move columns and rows to understand more easily than ever before how the numbers relate.
Where else can you find so many extra tools to help you gain advanced skills in Excel?
What people are saying:
“This would have to be the most enjoyable on-line course I have ever done. The material is nicely laid out, the presenter talks at a nice pace and explains things clearly. I highly recommend this course to those seeking Excel tuition.”
- Paul Schrooder
“Cindy is very clear and has organized the course brilliantly. Her explanation and covering of topics is granular enough to pick up once the course if over. Even though I am quite used to using most of what is covered, it was always interesting to hear her describe the features and was not bored!”
- Sam Malone
"Simon Sez IT is one of the best resources if you are looking for Microsoft Office tutorials."
“Truly outstanding course. I have been in accounting/controllership for over 40 years. I decided to review the basics of Excel just to make sure I knew it all. I didn't know it all and this highly detailed, cover everything course did show me new stuff. Cindy's teaching style is the way it should be done. For someone starting out, very highly recommended.”
- Pierre Nantais
“Very clear easy to follow instructions and extremely well presented. Love the layout and how easy it is to navigate to the section you want. Very quick response to any queries you may have. Some companies wanted to charge over £200 for 4 hours! This is great, you work at your own pace, fit it in around your "hectic" lifestyle and you don't feel overwhelmed or afraid to look at a spreadsheet. I've gone from novice to understanding quite a lot from what I've learned so far and I'm not even half way through the course.”
- Debbie Lee
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Intro to Excel 2010|
Introduction and Overview of Excel CoursePreview
IMPORTANT - Read this to ensure the best video quality!
Overview of the Excel WindowPreview
Working with the Mouse
|Section 2: Getting Started Creating a New Workbook|
Entering Text and NumbersPreview
Creating Basic Formulas
Order of Operations
Working withe Ranges
|Section 3: Saving Workbooks|
Working with Save and Save As Commands
|Section 4: Navigating Workbooks|
Opening a File
Working with Larger Files
Freeze Panes Options
Split Screen Option
|Section 5: Printing|
Page Setup OptionsPreview
Headers and Footers
Fit to print on one page
|Section 6: Working with Rows, Columns, and Cells|
Adding and Deleting Rows, Columns, and Cells
Changing Column and Row Widths
|Section 7: Moving Data|
Cut, Copy and Paste
|Section 8: Formulas and Functions|
Overview of Formulas
Create Formulas using Functions - Part 1
Create Formulas using Functions - Part 2
|Section 9: Working with Worksheets|
Adding, Deleting and Renaming Sheets
Additional Sheet Tab Options
|Section 10: Formatting Worksheets|
Borders and Shading
Format as Table
Using Format Painter
Fill Handle and Custom Lists
|Section 11: Charts|
Types of Charts
Using Graphics to Enhance Charts
|Section 12: Working with Names|
Creating Range Names
Using Names in Formulas
|Section 13: Sorting and Filtering|
|Section 14: Outlining and Subtotaling|
Creating an Outline - Part 1
Creating an Outline - Part 2
|Section 15: Working with Views|
New Window Option
Arrange File Options
Creating a Workspace
|Section 16: Linking Files|
Creating Formulas between Files
Working with Links
|Section 17: Advanced Formula Creation|
|Section 18: Additional Excel Features|
Text to Columns Option
|Section 19: Conclusion|
|Section 20: Intro to Excel 2010 Advanced - Basic Steps for Charts & Graphs|
Introduction to Advanced Excel 2010Preview
Four Basic Steps When Creating Charts/GraphsPreview
Additional Features to Help Create Charts/Graphs
Additional Features to Help Create Charts/Graphs Part 2
|Section 21: Layout Tab|
Detailed Formatting for Charts/GraphsPreview
Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With 80+ courses and 4,000+ video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 250,000 Udemy students in over 180 countries, Simon Sez IT is the preferred eLearning choice for individuals and businesses everywhere.