Learn New and Refresh Existing Skills with Skill Builder Pro

Generic selectors
Exact matches only
Search in title
Search in content

Excel 2010 Intermediate Online Course

Learn how to use the Open and Save dialogs to create new files and folders. It also covers file types that are compatible with Excel, how to work with older file formats, and how to protect their workbook against accidental or intentional changes to the data.

Skill Builder Pro is a job skills, soft skills and personal development training platform that has over 300 online courses. Your membership includes access to all courses to learn new skills or refresh your existing skills.

Share on facebook
Share on linkedin
Share on twitter

$499 Save $300 (60%).
Your membership gives you access to all 300 of our courses for 6 months.

7-Day Money Back Refund Guarantee. If you are a business and need multiple seats Click here
3 – 6 Hours
For All Skill Levels
7 day money back guarantee.
  • Description
  • Units of Study
  • FAQs

Learn How To Excel in Excel

Part 1 : Advanced File Tasks Learn how to use the Open and Save dialogues to create new files and folders. It also covers file types that are compatible with Excel, how to work with older file formats, and how to protect their workbook against accidental or intentional changes to the data. Finally, this section will discuss the many file management tools and checkers that are used to scan workbooks for personal information and compatibility issues. Part 2 : Working with Functions and Formulas Discover how to properly reference cells, use mathematical operators, and how to check their formulas for errors. This section also covers how to browse, insert, and use functions to perform complex mathematical operations. Students will learn how to use the IF function, use nested functions to perform multiple operations, and define and use range names. Finally, array formulas will be discussed. Part 3 : Managing Tables Tables are an important part of Excel because they inherently contain a lot of useful functionality, including sorting and filtering. This section teaches participants how to add and edit tables, edit table information, perform sort and filter operations, and even how to use Excel as a database. Part 4 : Adding the Finishing Touches This section details how to round off a spreadsheet by discussing how to check spelling and use the research pane to look up words, facts, and figures. Students will learn how to apply and use theme effects and create text boxes, pictures, and Clip Art. Basic image editing will also be discussed Part 5 : Showing Data as a Graphic This final section will show how to turn data into informative visual aids. Students will learn how to add and edit SmartArt; how to add symbols, special characters, and equations; and also how to add and edit shapes. Finally, the new Sparkline feature will be discussed, showing participants how to add, edit, and customize these useful graphs-in-a-cell. Online Access: Study the course online with an internet connection, by any device including PC, MAC, tablet or Smart Phone. Certificate of completion: A certificate of completion will be provided, when you finish the course.

Advanced File Tasks

  • Section 1.1: Using Windows Explorer within Excel
  • Navigating using Windows Explorer
  • Performing Basic Tasks with Windows Explorer
  • Using Views with Windows Explorer
  • Using the Windows Explorer Navigation Pane
  • Step-By-Step
  • Skill Sharpener
  • Section 1.2: Saving your Files
  • Using AutoRecover
  • Publishing to PDF or XPS
  • Protecting an Entire Workbook
  • Protecting the Current Sheet
  • Opening and Converting Files in XLS Format
  • Saving Spreadsheets in XLS Format
  • Step-By-Step
  • Skill Sharpener
  • Section 1.3: Using File Management Tools, Part One
  • Marking a Workbook as Final
  • Encrypting a Workbook
  • Digitally Signing a Workbook
  • Managing File Properties
  • Managing Versions
  • Step-By-Step
  • Skill Sharpener
  • Section 1.4: Using File Management Tools, Part Two
  • Viewing a Summary of Sharing Issues
  • Using the Document Inspector
  • Using the Accessibility Checker
  • Using the Compatibility Checker
  • Setting Compatibility Options
  • Step-By-Step
  • Skill Sharpener
  • Case Study

Working with Functions and Formulas

  • Section 1.1: Using Formulas in Excel, Part 1
  • Understanding Relative and Absolute Cell References
  • Understanding Basic Mathematical Operators
  • Using Formulas with Multiple Cell References
  • Understanding the Formula Auditing Buttons
  • Step-By-Step
  • Skill Sharpener
  • Section 1.2: Using Formulas in Excel, Part 2
  • Fixing Formula Errors
  • Displaying and Printing Formulas
  • Step-By-Step
  • Skill Sharpener
  • Section 1.3: Exploring Excel Functions
  • What are Functions?
  • Inserting Functions
  • Some Useful and Simple Functions
  • Step-By-Step
  • Skill Sharpener
  • Section 1.4: Using Functions in Excel
  • Using the IF Function
  • Working with Nested Functions
  • Breaking up Complex Formulas
  • Using Functions and AutoFill to Perform Difficult Calculations
  • Step-By-Step
  • Skill Sharpener
  • Section 1.5: Working with Names and Ranges
  • What are Range Names?
  • Defining and Using Range Names
  • Defined Names Commands
  • Selecting Nonadjacent Ranges
  • Using AutoCalculate
  • Step-By-Step
  • Skill Sharpener
  • Section 1.6: Working with Array Formulas
  • What are Array Formulas?
  • Defining Basic Array Formulas
  • Using Functions within Array Formulas
  • Using the IF Function in Array Formulas
  • Step-By-Step
  • Skill Sharpener
  • Case Study

Managing Tables

  • Section 1.1: Working with Tables
  • What is a Table?
  • Creating Tables
  • Modifying Tables
  • Using the Table Tools – Design Tab
  • Adding a Total Row
  • Step-By-Step
  • Skill Sharpener
  • Section 1.2: Working with Records and Fields
  • What are Records and Fields?
  • Adding Records by Inserting Rows
  • Quickly Adding Records to a Data Table
  • Deleting Records or Fields
  • Cleaning up Duplicate Records
  • Step-By-Step
  • Skill Sharpener
  • Section 1.3: Working with Tables and Filters
  • Sorting Data in a Table
  • What is an AutoFilter?
  • Creating a Custom AutoFilter
  • Using an Advanced Filter
  • Using an Advanced Filter with Logical Statements
  • Copying Filtered Records
  • Step-By-Step
  • Skill Sharpener
  • Section 1.4: Using Excel as a Database
  • Filtering with Wildcard Characters
  • Validating your Data
  • Data Validation using Lists
  • Using Database Functions
  • Step-By-Step
  •  Skill Sharpener
  • Case Study

Adding the Finishing Touches

  • Section 1.1: Research Tools
  • Checking Spelling
  • Using the Research Pane
  • Using the Thesaurus
  • Setting your Language
  • Step-By-Step
  • Skill Sharpener
  •  Section 1.2: Using Themes
  • Changing the Theme
  • Customizing Theme Fonts
  • Customizing Theme Effects
  • Managing Theme Files
  • Step-By-Step
  • Skill Sharpener
  •  Section 1.3: Adding Text Boxes
  • Drawing a Text Box
  • Using the Drawing Tools – Format Tab
  • Common Text Box Editing Tasks
  • Inserting WordArt
  • Common WordArt Editing Tasks
  • Step-By-Step
  • Skill Sharpener
  • Section 1.4: Inserting Pictures and ClipArt
  • Adding a Picture from a File
  • Adding Clip Art
  • Adding a Screenshot
  • Overview of the Picture Tools – Format Tab
  • Overview of the Pictures Mini Toolbar
  • Step-By-Step
  • Skill Sharpener
  •  Section 1.5: Editing Pictures
  • Resizing Pictures
  • Moving Pictures
  • Cropping Pictures
  • Rotating and Flipping Pictures
  • Using the Format Picture Dialog
  • Step-By-Step
  • Skill Sharpener
  • Case Study

Showing Data as a Graphic

  • Section 1.1: Inserting SmartArt
  • Inserting SmartArt
  • Adding Text
  • Adding Photos
  • About the SmartArt Tools Tabs
  • Editing SmartArt
  • Step-By-Step
  • Skill Sharpener
  • Section 1.2: Formatting SmartArt
  • Changing the Layout
  • Changing the Color Scheme
  • Changing the Style Scheme
  • Resetting the Graphic
  • Converting the Graphic
  • Step-By-Step
  • Skill Sharpener
  • Section 1.3: Adding Symbols, Equations, and Shapes
  • Inserting a Symbol or Special Character
  • Inserting an Equation
  • Using the Equation Tools – Design Tab
  • Drawing Shapes
  • Common Shape Editing Tasks
  • Step-By-Step
  • Skill Sharpener
  • Section 1.4: Adding Sparklines
  • What are Sparklines?
  • Adding Sparklines
  • About the Sparkline Tools Tab
  • Editing Sparkline Data
  • Removing Sparklines
  • Step-By-Step
  • Skill Sharpener
  • Section 1.5: Editing Sparklines
  • Showing and Hiding Data
  • Changing the Style
  • Changing the Sparkline and Marker Color
  • Setting Sparkline Options
  • Step-By-Step
  • Step-By-Step
  • Skill Sharpener
  • Case Study

Soft skills are the “people skills” that ensure a person is capable of relating effectively with others. Soft skills usually include such personality traits as effective communication, work ethic, problem solving, teamwork, networking, motivation, time management, dispute resolution, flexibility, critical thinking and many similar traits.

Whereas hard skills are usually mechanical skills that have been learned, soft skills are somewhat harder to teach. Effective instruction will enhance latent and dormant abilities in the student. 

Interacting with people is a critical part of most jobs. The better your employees are able to interact with others, the better the results will be. Soft skills can make a crucial difference in internal communication, customer service and sales situations.

People with a broad range of soft skills are valued for their adaptability as they are able to transfer their skills from one workplace role to another with comparative ease.

Employers who have a customer service component in their business are particularly appreciative of employees who have a range of soft skills that are appropriate for customer service roles. Good customer service leaves a lasting impression. Great soft people skills can make all the difference.

Skill Builder Pro is an online membership to over 300 of the most important soft skills courses, that your can study from any device, including computer or mobile phone.
Included are:

  • Certificates and Course Transcripts
  • Free Personal Success Program
  • Free Career Planner Workbook
  • Quizzes and assessments

We offer two types of memberships, one for individuals and the other for businesses or people that need multiple people to access the courses.

The individual membership allows for one person to access the lessons and print off personalized certificates. These can be purchased on a yearly or monthly basis. 

For businesses we offer many different pricing options. Please contact us at support@skillbuilderpro.com if you require more than one membership. 

All packages come with a 7-day money back guarantee. This means that if during the 7 days of your first month or year with Skill Builder Pro you don’t want to continue then we’ll provide you with a full refund.

No, but we offer a 7-day money back guarantee for any plan purchased. If you’re not happy within 7 days we’ll process your full refund immediately, no worries whatsoever.

No, you’re not. You are only tied in for the duration of the plan you choose at the point of purchase. This could be six months or yearly.

Your plan will auto-renew at the end of that period, but if you cancel at any point before then it will not auto-renew. 

We will also send you a message before we process any renew payments.

Joining Skill Builder Pro course couldn’t be easier! Just head on over to our membership page and select the best option that suits your needs. If you have any questions, please contact us from the various methods listed on our contact page.

Online learning is just as easy – if not easier – than a traditional academic situation. By studying an online course, the usual boundaries caused by location and time constraints are eliminated, meaning you are free to study where and when you want at your own pace. Of course, you will need to be able to self-manage your time and be organized, but with our help, you’ll soon find yourself settling into a comfortable rhythm of study.

After you have completed your payment, you will be able to login with the credentials you created at signup. We also send a confirmation email with this info.

You can view all courses available by clicking the courses button top left of our website, once you have found the course you would like to take, go to the course page and select the large red button “Start Course”. This will open a window with the course.

You can also log in by using the log in button top right of website.

The average time required to complete a course is 3 – 6 hours, though you can take as long as you like as you have access to complete the course at your own pace.

Yes, assessments and quizzes are provided so you can test your knowledge to make sure you understand the course content.

All students who complete a course receive a certificate of completion.

You will also receive a transcript of course units and courses completed within Skill Builder Pro.

Skill Builder Pro is a job skill, soft skills, and personal development training platform with over 300 online courses. The courses are accessed online via the internet, and users provided with a login.

The course categories include, business skills, human resources, marketing, personal development, sales, management, workplace compliance and Microsoft.

Upon purchase you will have access to all the courses in Skill Builder Pro for a period of six months and is renewable.

Some of the companies we work with include Stack Social, CNN, Entrepreneur, Mashable, and many more.

We provide a 7-day money-back refund guarantee. Please send an email to support@skillbuilderpro.com to submit this request.

There are no entry requirements to take any of these courses. Everyone is encouraged to take these courses.

You do not require a High School Diploma; these courses are open to anyone who would like to study these topics.

These courses are only provided in English.

All the courses are based online and accessed through the Skill Builder Pro online platform via the internet.

Once you have completed the payment, you will receive a confirmation email and tax receipt. You will also receive a username and password to log into the skill builder Pro Platform. If you have the internet and own a reliable computer or device, you will be able to log in and study the courses. Please remember to check your junk folder if you do not receive the email.

You can start immediately after finalizing the purchase of Skill builder Pro, using the username and password provided with your welcome email. Head here to signup https://skillbuilderpro.com/membership/

You do not need to be an expert, but you should be able to use a keyboard, the internet, and have basic skills with Microsoft.

You will have six months access Skill Builder Pro platform (or longer if you have purchased longer), there are no time limits, and you can take as long as you require to complete each course. Access is renewed at the end of six months.

All 300 job skill, soft skills, and personal development courses included, additionally, new courses added monthly, the online materials include content, diagrams, interactive instructions, and quizzes, plus you will receive a certificate upon completion.

You will receive a Certificate of Completion, which demonstrates your commitment to learning new skills. You can share the certificate with your friends, relatives, co-workers, and potential employers. Plus, you can include it in your resume/CV, professional social media profiles, and job applications.

Taking the initiative and completing these courses shows potential employers you are willing to learn new skills to ensure that you have the necessary skills to achieve your tasks.

The Certificates are valid for life and do not need renewing. 

You can complete as many courses as you like.

We accept payments via PayPal, Credit Card, and Bank Transfer. Contact us at support@skillbuilderpro.com, to pay via bank transfer or PayPal.

If you are a business and wish to purchase for multiple people, please contact us at support@skillbuilderpro.com.

Yes, you can request for an invoice via email at support@skillbuilderpro.com

You can purchase this course as a gift, send an email to support@skillbuilderpro.com, with the details and we can accommodate this.

You can contact our support team at any time through live chat on our website, or email at support@skillbuilderpro.com.


Course Features

Need Help?


What other students have said about us

Vesna Kitanovska
Read More
I am going to realise that (after completing 13 Courses already) how much time I can save studying online. Is becoming a bit "addictive” but in a good way. I love it and every free time I am on to doing my exams or explore what other Courses is available out there to enroll later.
Debra Goodlander
Read More
I am an older manager and have ran into several of the examples you explained over the years with younger employees. Reading this has helped me realize where I may have gone wrong. I will be changing the way I handle all my employees. Thank you.
Philip Anthony Apps
Read More
The Courses have been very detailed and challenging. Different subjects and terminology well laid out and instructive. Key points well presented and course material written in a very informal patient way which keeps the note taking and reading interesting! overall thoroughly enjoyed this course and completing it!
Alicia L
Read More
I loved this course!! It's very informative and straight to the point. I appreciate the opportunity to be able to train for high demand jobs at a cost effective price. Thank you!!! God Bless.”
0 +
different courses
Hours of Classes
0 +
Happy Clients

Learn New Skills and Refresh Existing Skills with Skill Builder Pro

7-Day Money Back Refund Guarantee

To Perfect for individuals and businesses to boost their skills

Need More Info?

Please reach out if you need more info from us.

Log into Skill Builder Pro

Sign in to enjoy all our courses or

Excel 2010 Intermediate Online Course

To complete your assessment and receive your certificate

Lessons Status

Need multiple users?

Please let us know what you are looking for.


Huge July Sale – Now Only $199, Save 60%