Learn Microsoft Excel 2010 the Easy Way
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
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.
Impress your colleagues and wow your boss by developing your spreadsheet skills with our Microsoft Excel 2010 Beginners course. Microsoft Excel 2010 is still one of the most popular and widespread editions of Microsoft’s famous spreadsheet program, but it can seem very overwhelming to the novice getting to grips with the software.
In this 7 hour Microsoft Excel 2010 Beginners course, you’ll go from shunning sums to cheerily calculating, and by the end of the course you’ll be comfortable with every aspect of the layout and basic functionality of Microsoft Excel 2010.
Our professional instructor will talk you through Excel 2010’s features, starting with the basics, from creating files to editing existing documents. You’ll start with creating a new workbook and entering text and numbers, moving onto saving and printing your documents, and working with larger and more complex workbooks. Next 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 move onto sorting and filtering data, linking multiple files, and, finally, working with some more advanced formulas.
With this informative course, you’ll learn the skills you need to make an impact with attractive, functional spreadsheets that help you do your job better.
Plus, when you sign up for our class, you’ll also get these 3 BONUSES:
What people are saying:
"Simon Sez IT is one of the best resources if you are looking for Microsoft Office tutorials."
Note: All videos are high-definition and are therefore best viewed enlarged and with the HD setting on.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction to Excel|
Introduction and Overview of Excel 2010 CoursePreview
IMPORTANT - Read this to ensure the best video quality!
Overview of the Excel WindowPreview
Working with the Mouse
|Section 2: Creating a New Workbook|
Entering Text and Numbers
Creating Basic Formulas
Order of Operations
Working with 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 Options
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 FormulasPreview
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: Assessment Test|
Excel 2010 Quiz
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.