More results...
Master spreadsheets with our Microsoft Excel 365 Online Course! Build and manage worksheets with confidence, harness basic functions and formulas, and turn your data into a powerhouse. Enjoy the flexibility to learn on your terms with our user-friendly, self-paced online platform.
Skill Builder Pro is a job skills, soft skills and personal development training platform that has over 250+ online courses. Your purchase includes access to all courses to learn new skills or refresh your existing skills.
Your purchase gives you access to all 250+ of our courses
7-Day Money Back Refund Guarantee. If you are a business and need multiple users Click here
TOPIC A: Getting Started with Excel Online
Logging into Office 365
Launching Excel Online
The Excel Online Interface
Creating a New Workbook
Closing Excel Online
Activity 1-1: Getting Started with Excel Online
TOPIC B: Getting to Know Excel
What are Spreadsheets, Worksheets, and Workbooks?
What are Columns, Rows, Cells, and Ranges?
Navigating in Excel
Excel Formulas
Activity 1-2: Getting to Know Excel
TOPIC C: Managing Workbooks
Opening a Workbook
Editing Your Workbook in Excel Desktop
Accessing Save Options
Using the Accessibility Checker
Printing a Workbook
Sharing a Workbook
Activity 1-3: Managing Workbooks
TOPIC D: Getting Help in Excel Online
Using Tell Me
Accessing Advanced Help Options
Getting Accessibility Help
Activity 1-4: Getting Help in Excel Online
Summary
Review Questions
TOPIC A: A Closer Look at Formulas
The Formula Bar
Elements of an Excel Formula
Mathematical Operators
The Order of Operations
Types of References
Activity 2-1: A Closer Look at Formulas
TOPIC B: Using Formulas and Functions
About Functions
Creating a Function with AutoComplete
Using the Insert Function Dialog Box
Using AutoSum
Viewing AutoSum Calculations in the Status Bar
Automatic Workbook Calculations
Activity 2-2: Using Formulas and Functions
TOPIC C: Working with Data
Selecting Cells
The Cut, Copy, and Paste Commands
Using Paste Options
Moving Data with Drag and Drop
The Undo and Redo Commands
Using AutoFill
Using Flash Fill
Activity 2-3: Working with Data
TOPIC D: Working with Rows and Columns
Inserting Rows and Columns
Deleting Rows and Columns
Clearing Data from Cells
Changing Column Width and Row Height
The Hide and Unhide Options
Activity 2-4: Working with Rows and Columns
TOPIC E: Sorting and Filtering Data
The Difference Between Sorting and Filtering
Sorting Data
Enabling Filtering
Using the Filter Dialog Box
Using Text Filters
Clearing a Filter
Activity 2-5: Sorting and Filtering Data
Summary
Review Questions
TOPIC A: Formatting Text
What is a Font?
The Font Group
The Format Painter
Creating Links
Activity 3-1: Formatting Text
TOPIC B: Formatting Cells
Applying a Border
Applying a Fill
Changing the Number Format
Customizing Number Formats
Activity 3-2: Formatting Cells
TOPIC C: Aligning Cell Content
Alignment Options
The Indent Commands
The Wrap Text Command
Merge & Center Options
Activity 3-3: Aligning Cell Content
TOPIC D: Using Find & Select Tools
The Find Command
The Replace Command
The Go To Command
Activity 3-4: Using Find & Select Tools
TOPIC E: Applying Conditional Formatting
What is Conditional Formatting?
Applying Conditional Formatting Rules
Setting Conditional Formatting Options
Clearing Conditional Formatting
Activity 3-5: Applying Conditional Formatting
Summary
Review Questions
TOPIC A: Inserting Pictures
Inserting Pictures
Resizing Pictures
Rotating Pictures
Deleting Pictures
Adding Alternative Text
Activity 4-1: Inserting Pictures
TOPIC B: Inserting Shapes
Inserting Shapes
The Drawing Tools – Format Contextual Tab
Resizing Shapes
Deleting Shapes
Activity 4-2: Inserting Shapes
TOPIC C: Formatting Shapes
Changing the Shape Type
Applying a Style
Customizing Shape Fill and Outline
Adding Alternative Text
Activity 4-3: Formatting Shapes
Summary
Review Questions
TOPIC A: Inserting Tables
What is a Table?
Creating a Table
Customizing Row Display
Inserting and Deleting Table Rows and Columns
Sorting and Filtering Table Data
Activity 5-1: Inserting a Table
TOPIC B: Inserting Charts
Chart Types
Chart Elements
Inserting a Chart
The Chart Tools – Chart Contextual Tab
Moving Charts
Resizing Charts
Activity 5-2: Inserting Charts
TOPIC C: Modifying Charts
Switching Row and Column Display
Using the Select Data Command
Changing the Chart Type
Adding a Chart Title
Modifying Chart Labels
Modifying Chart Axes
Activity 5-3: Modifying Charts
Summary
Review Questions
Lesson 6: Using Pivot-Tables
TOPIC A: Inserting PivotTables
What is a PivotTable?
Creating a PivotTable
The PivotTable Fields Task Pane
Working with PivotTable Data
Activity 6-1: Inserting PivotTables
TOPIC B: Working with PivotTable Data
Expanding and Collapsing Data
Refreshing Data
Renaming Fields
Summarizing Values
Changing Value Display
Activity 6-2: Working with PivotTable Data
TOPIC C: Sorting and Filtering PivotTable Data
Sorting Data
Using the Filters Pane
Using Label and Value Filters
Clearing Filters
Activity 6-3: Sorting and Filtering PivotTable Data
Summary
Review Questions
TOPIC A: Using Comments
Inserting Comments
Showing and Hiding the Comments Pane
Editing Comments
Deleting Comments
Activity 7-1: Working with Comments
TOPIC B: Managing Worksheets (Part One)
Viewing Worksheets
Inserting Worksheets
Deleting Worksheets
Duplicating Worksheets
Worksheet References in Formulas
Activity 7-2: Managing Worksheets (Part One)
TOPIC C: Managing Worksheets (Part Two)
Hiding and Unhiding Worksheets
Reordering Worksheets
Renaming Worksheet Tabs
Changing Tab Color
Activity 7-3: Managing Worksheets (Part Two)
TOPIC D: Changing View Options
Using the Workbook Views Group
Showing and Hiding Workbook Elements
The Freeze Panes Options
Activity 7-4: Changing View Options
Summary
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 course platform with access to over 250+ of the most important soft skills courses, that your can study from any device, including computer or mobile phone.
Included are:
We offer options, for individuals and the other for businesses or people that need multiple people to access the courses.
The individual purchase allows for one person to access the lessons and print off personalized certificates. These can be purchased on a yearly basis.
For businesses we offer many different pricing options. Please contact us at support@skillbuilderpro.com if you require more than one user.
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 have access to Skill Builder Pro for 1 year.
Purchasing Skill Builder Pro course couldn’t be easier! Just head on over to our purchase page and fill in your details. 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 250+ 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 12 months and can be renewed if required.
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 12 months access Skill Builder Pro platform, there are no time limits, and you can take as long as you require to complete each course.
All 250+ 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.
What other students have said about us
To Perfect for individuals and businesses to boost their skills
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 course platform with access to over 250+ of the most important soft skills courses, that your can study from any device, including computer or mobile phone.
Included are:
We offer options, for individuals and the other for businesses or people that need multiple people to access the courses.
The individual purchase allows for one person to access the lessons and print off personalized certificates. These can be purchased on a yearly basis.
For businesses we offer many different pricing options. Please contact us at support@skillbuilderpro.com if you require more than one user.
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 have access to Skill Builder Pro for 1 year.
Purchasing Skill Builder Pro course couldn’t be easier! Just head on over to our purchase page and fill in your details. 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 250+ 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 12 months and can be renewed if required.
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 12 months access Skill Builder Pro platform, there are no time limits, and you can take as long as you require to complete each course.
All 250+ 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.
Thanks for being a part of Skill Builder Pro
Please let us know a bit more information about how many people you would like to add.