fbpx

Learn New and Refresh Existing Skills with Skill Builder Pro

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

Excel 2016 Part One Online Course

Gain an advanced level of understanding for the Microsoft Excel environment, and the ability to guide others to the proper use of the program’s full features – critical skills for those in roles such as accountants, financial analysts, and commercial bankers. You will create, manage, and distribute professional spreadsheets for a variety of specialized purposes and situations.

Skill Builder Pro is a job skills, soft skills and personal development training platform that has over 300 online courses. You will have 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%)​

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 to create, manage, and distribute professional spreadsheets

Excel 2016 continues with Microsoft Excel 2016 Part Two, building on skills learned in Part One. This course offers lessons for Microsoft’s spreadsheet program. Learning outcomes:
  • Creating advanced formulas
  • Analyzing data with logical and lookup functions
  • Organizing worksheet data with Tables
  • Visualizing data with Charts
  • Analyzing data with PivotTables, Slicers, and PivotCharts
  • Inserting graphics
  • Enhancing workbooks
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.

Lesson 1: Creating Advanced Formulas

  • TOPIC A: Apply Range Names
  • Range Names
  • Adding Range Names Using the Name Box
  • Adding Range Names Using the New Name Dialog Box
  • Editing a Range Name and Deleting a Range Name
  • Using Range Names in Formulas
  • Activity 1-1
  • TOPIC B: Use Specialized Functions
  • Function Categories
  • The Excel Function Reference
  • Function Syntax
  • Function Entry Dialog Boxes
  • Using Nested Functions
  • Automatic Workbook Calculations
  • Showing and Hiding Formulas
  • Enabling Iterative Calculations
  • Activity 1-2
  • Summary
  • Review Questions

Lesson 2: Analyzing Data with Logical and Lookup Functions

  • TOPIC A: Use Text Functions
  • Text Functions
  • The LEFT and RIGHT Functions
  • The MID Function
  • The LEN Function
  • The TRIM Function
  • The UPPER, LOWER, and PROPER Functions
  • The CONCATENATE Function
  • The TRANSPOSE Function
  • Activity 2-1
  • TOPIC B: Use Logical Functions
  • Logical Functions
  • Logical Operators
  • The AND Function
  • The OR Function
  • The IF Function
  • Activity 2-2
  • TOPIC C: Use Lookup Functions
  • Lookup Functions
  • The LOOKUP Function
  • The VLOOKUP Function
  • The HLOOKUP Function
  • Activity 2-3
  • TOPIC D: Use Date Functions
  • The TODAY Function
  • The NOW Function
  • Serializing Dates and Times with Functions
  • Activity 2-4
  • TOPIC E: Use Financial Functions
  • The IPMT Function
  • The PPMT Function
  • The NPV Function
  • The FV Function
  • Activity 2-5
  • Summary
  • Review Questions

Lesson 3: Organizing Worksheet Data with Tables

  • TOPIC A: Create and Modify Tables
  • Tables
  • Table Components
  • The Create Table Dialog Box
  • The Table Tools – Design Contextual Tab
  • Styles and Quick Style Sets
  • Customizing Row Display
  • Table Modification Options
  • Activity 3-1
  • TOPIC B: Sort and Filter Data
  • The Difference Between Sorting and Filtering
  • Sorting Data
  • Advanced Filtering
  • Filter Operators
  • Removing Duplicate Values
  • Activity 3-2
  • TOPIC C: Use Subtotal and Database Functions to Calculate Data
  • SUBTOTAL Functions
  • The Subtotal Dialog Box
  • Summary Functions in Tables
  • Database Functions
  • Activity 3-3
  • Summary
  • Review Questions

Lesson 4: Visualizing Data with Charts

  • TOPIC A: Create Charts
  • Charts
  • Chart Types
  • Chart Insertion Methods
  • Resizing and Moving the Chart
  • Adding Additional Data
  • Switching Between Rows and Columns
  • Activity 4-1
  • TOPIC B: Modify and Format Charts
  • The Difference Between Modifying and Formatting
  • Chart Elements
  • Minimize Extraneous Chart Elements
  • The Chart Tools Contextual Tabs
  • Formatting the Chart with a Style
  • Adding a Legend to the Chart
  • Activity 4-2
  • TOPIC C: Create a Trendline
  • Trendlines
  • Types of Trendlines
  • Adding a Trendline
  • The Format Trendline Task Pane
  • Activity 4-3
  • TOPIC D: Create Advanced Charts
  • Dual Axis Charts
  • Creating Custom Chart Templates
  • Viewing Chart Animations
  • Activity 4-4
  • Summary
  • Review Questions

Lesson 5: Analyzing Data with PivotTables, Slicers, and PivotCharts

  • TOPIC A: Create a PivotTable
  • PivotTables
  • Start with Questions, End with Structure
  • The Create PivotTable Dialog Box
  • The PivotTable Fields Pane
  • Summarize Data in a PivotTable
  • The “Show Values As” Functionality of a PivotTable
  • External Data
  • PowerPivot
  • PowerPivot Functions
  • Activity 5-1
  • TOPIC B: Filter Data by Using Slicers
  • Slicers
  • The Insert Slicers Dialog Box
  • Activity 5-2
  • TOPIC C: Analyze Data with PivotCharts
  • PivotCharts
  • Creating PivotCharts
  • Applying a Style to a PivotChart
  • Activity 5-3
  • Summary
  • Review Questions

Lesson 6: Inserting Graphics

  • TOPIC A: Insert and Modify Graphic Objects
  • Graphical Objects
  • Inserting Shapes
  • Inserting WordArt
  • Inserting Text Boxes
  • Inserting Images
  • The Picture Tools – Format Contextual Tab
  • The Drawing Tools – Format Contextual Tab
  • The SmartArt Tools Contextual Tabs
  • Activity 6-1
  • TOPIC B: Layer and Group Graphic Objects
  • Layering Objects
  • Grouping Objects
  • Positioning Objects
  • Activity 6-2
  • TOPIC C: Incorporate SmartArt
  • About SmartArt
  • The Choose a SmartArt Graphic Dialog Box
  • About the Text Pane
  • Activity 6-3
  • Summary
  • Review Questions

Lesson 7: Enhancing Workbooks

  • TOPIC A: Customize Workbooks
  • Comments
  • Hyperlinks
  • Watermarks
  • Background Pictures
  • Activity 7-1
  • TOPIC B: Manage Themes
  • About Themes
  • Customizing Themes
  • Activity 7-2
  • TOPIC C: Create and Use Templates
  • Templates
  • Template Types
  • Creating a Template
  • Modifying a Template
  • Activity 7-3
  • TOPIC D: Protect Files
  • Recovering Lost Data
  • The Changes Group
  • Worksheet and Workbook Protection
  • The Protect Worksheet Option
  • The Protect Workbook Option
  • Activity 7-4
  • TOPIC E: Preparing a Workbook for Multiple Audiences
  • Displaying Data in Multiple International Formats
  • Utilize International Symbols
  • Modifying Worksheets Using the Accessibility Checker
  • Managing Fonts
  • Activity 7-5
  • Summary
  • Review Questions

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

  • Only 3 to 6 hours of study is required
  • Delivered 100% on-line 24/7
  • Study from home or at work, at your own pace, in your own time
  • Certificate of Completion

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 2016 Part One Online Course

Need multiple users?

Please let us know what you are looking for.

Days
Hours
Minutes
Seconds

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