fbpx

Learn New and Refresh Existing Skills with Skill Builder Pro

Generic selectors
Exact matches only
Search in title
Search in content
sfwd-courses

Excel 2013 Expert Online Course

This course delves into Conditional Formatting in a way that users can grasp and exploit this feature. It covers how to apply conditional formatting, apply multiple rule sets, create custom rule sets, view and manage rules, and clear custom formatting rules.

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
Advanced
For All Skill Levels
7 day money back guarantee.
  • Description
  • Units of Study
  • FAQs

Learn How To Excel in Excel

Using Conditional Formatting This course delves into Conditional Formatting in a way that users can grasp and exploit this feature. It covers how to apply conditional formatting, apply multiple rule sets, create custom rule sets, view and manage rules, and clear custom formatting rules. Working with Slicers Slicers allow you to quickly filter any data that is displayed within a PivotTable. In this course students are shown how to insert and use a slicer, rename a slicer, change slicer settings, format a slicer, and clear a slicer. Using Power View, Part One Power View has many applications for upper-level users of Excel 2013. Students will learn in this course how to enable Power View, create a Power View, add and remove fields, arrange fields, and filter and sort data. Using Power View, Part Two Power View is such a useful tool that it deserves an extra-close look which takes place here in Part Two. This course looks at how to: refresh data, choose a visualization, change tile display, and set display options. Using the Inquire Add-In The Inquire Add-In is only available in the Office Professional Plus 2013 and Office 365 Professional Plus editions. This course shows students how to install the Inquire add-in, generate a workbook analysis report, view a relationship diagram or report, view cell relationships, and compare two workbooks. Working with Tables Tables are efficient for dealing with ranges of data. Students will get the most from the course as they learn what tables are and how to create, resize, and clear tables, as well as how to choose a table style. Working with Records and Fields Records and fields are the building blocks of data. Covered in this course is what they actually are and how to add fields by inserting columns, add records by inserting rows, and delete records or fields. Using Excel as a Database Databases are an assemblage of data which can be manipulated in many ways. This course takes a look at how to filter data with wildcard characters, validate data with lists or formulas, and how to use database functions. Using Custom AutoFill Lists An AutoFill list is a series or sequence of numbers or text strings that can be filled into cells automatically when you drag your mouse pointer down a column or across a row. This course will show users how to create and use a custom AutoFill list, and how to modify and delete a custom AutoFill list. Using Comments Comments allow users to engage with the material and each other through making messages added to Excel files. This course gives students the knowledge how to insert, edit, navigate, and delete comments. Tracking Changes When changes are made to a file it’s very handy to know what has been changed and when and by who. This course touches upon how to track and review changes, set options for tracking changes, and stop tracking changes. Linking, Consolidating, and Combining Data When working with multiple files with interrelated data it’s handy to make the most of linking. This course covers how to link and consolidate workbooks, consolidate worksheets, and pivot consolidated data. 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.

Using Conditional Formatting

  • Applying Conditional Formatting
  • Applying Multiple Rule Sets
  • Creating Custom Rule Sets
  • Viewing and Managing Rules
  • Clearing Custom Rules

Working with Slicers

  • Inserting and Using a Slicer
  • Renaming the Slicer
  • Changing Slicer Settings
  • Formatting a Slicer
  • Clearing the Slicer

Using Power View, Part One

  • Enabling Power View
  • Creating a Power View
  • Adding and Removing Fields
  • Arranging Fields
  • Filtering Data
  • Sorting Data

Using Power View, Part Two

  • Refreshing Data
  • Choosing a Visualization
  • Changing Tile Display
  • Setting Display Options

Using the Inquire Add-In

  • Installing Inquire
  • Generating a Workbook Analysis Report
  • Viewing Workbook and Worksheet Relationships
  • Viewing Cell Relationships
  • Comparing Two Workbooks

Working with Tables

  • What is a Table?
  • Creating Tables
  • Resizing the Table
  • Choosing a Table Style
  • Clearing the Table

Working with Records and Fields

  • What are Records and Fields?
  • Adding Fields by Inserting Columns
  • Adding Records by Inserting Rows
  • Deleting Records or Fields

Using Excel as a Database

  • Filtering with Wildcard Characters
  • Validating Your Data
  • Data Validation Using Lists
  • Data Validation Using Formulas
  • Using Database Functions

Using Custom AutoFill Lists

  • Creating a Custom AutoFill List
  • Using a Custom AutoFill List
  • Modifying a Custom AutoFill List
  • Deleting a Custom AutoFill List

Using Comments

  • Inserting Comments
  • Editing Comments
  • Navigating Through Comments
  • Deleting Comments

Tracking Changes

  • Tracking Changes
  • Reviewing Changes
  • Setting Options for Tracking Changes
  • Stopping Tracking Changes

Linking, Consolidating, and Combining Data

  • Linking Workbooks
  • Consolidating Workbooks
  • Consolidating Worksheets
  • Pivoting Consolidated Data 

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?

Reviews

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.”
Previous
Next
0 +
different courses
0
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 2013 Expert Online Course

To complete your assessment and receive your certificate

Need multiple users?

Please let us know what you are looking for.

Days
Hours
Minutes
Seconds

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