Microsoft Excel 2013 - Intermediate Course
Master using formulas and functions to make Excel work for you with this free online Excel Intermediate course.
Description
This free online Excel 2013 Intermediate course starts by looking at the different views that Excel has, which is useful when you need to print specific parts of a spreadsheet or when you're looking at large files. The course then moves onto explaining how formulas work in Excel and how to work with multiple workbooks at a time.
Next, the course introduces you to incredibly useful functions in Excel like Find and Replace and Conditional Formatting. The course goes into depth on how to create great looking charts and graphs in Excel to help you bring your data to life - essential for any Excel user. You'll then learn about some of the most used Excel functions, specifically Lookup functions (VLOOKUP) and logical functions (IF).
Finally, the course starts you on your journey to really using Excel as a Data Analysis tool and you'll learn how to share and protect your workbooks for when multiple people are accessing them. Start this course today - You've learnt the basics, now it's time to take your Excel to the next level.
Start Course NowModules
Introduction to Excel, Formulas, Functions and Workbooks
-
Learning Outcomes
-
Inserting Comments
-
Workbook Views, Zoom and Freeze
-
Printing; Headers, Footers and Margins
-
Overview of Formulas and Functions
-
Cell References
-
Names
-
Finding Errors; New Excel Functions
-
Multiple Workbooks and Windows; Comparing Workbooks
-
Go to; Find and Replace Options
Charts, Formatting and Common Functions
-
Learning Outcomes
-
Applying, Clearing and Managing Rules
-
Chart Types; Chart Recommendation
-
Basic Formatting
-
Selecting Data, Positioning and Printing Charts
-
Saving Workbooks; PDF and CSV Formats
-
Sorting
-
Filtering
-
Tables
-
VLOOKUP
-
Text Function
-
Date and Time Functions
-
Logical Functions
Analyzing Data, Protecting Worksheets and Extra Tools
-
Learning Outcomes
-
Financial Analysis Case Study - Part 1
-
Financial Analysis Case Study - Part 2
-
Quick Analysis Tool
-
Adding and Formatting Shapes, Picture, Clip Art, WordArt and SmartArt
-
Protecting Worksheets
-
Protecting Workbooks
-
Sharing and SkyDrive
-
Trust Center; Export; Inspect Workbook
-
Summary; More Help
Course assessment
Learning Outcomes
Having completed this course you will be able to:
- Describe how to work with comments in Excel
- Explain how to use all the different Excel views including Print Preview
- Describe how formulas work
- Create awesome looking charts and graphs in Excel
- Explain how to use functions like VLOOKUP, Text functions and Logical functions like IF
- Describe how to use Excel to perform data analysis
- Discuss working with multiple workbooks
Certification
All Alison courses are free to enrol, study and complete. To successfully complete this Certificate course and become an Alison Graduate, you need to achieve 80% or higher in each course assessment. Once you have completed this Certificate course, you have the option to acquire an official Certificate, which is a great way to share your achievement with the world. Your Alison Certificate is:
Ideal for sharing with potential employers - include it in your CV, professional social media profiles and job applications
An indication of your commitment to continuously learn, upskill and achieve high results
An incentive for you to continue empowering yourself through lifelong learning
Alison offers 3 types of Certificates for completed Certificate courses:
Digital Certificate - a downloadable Certificate in PDF format, immediately available to you when you complete your purchase
Certificate - a physical version of your officially branded and security-marked Certificate, posted to you with FREE shipping
Framed Certificate - a physical version of your officially branded and security-marked Certificate in a stylish frame, posted to you with FREE shipping
All Certificates are available to purchase through the Alison Shop. For more information on purchasing Alison Certificates, please visit our FAQs. If you decide not to purchase your Alison Certificate, you can still demonstrate your achievement by sharing your Learner Record or Learner Achievement Verification, both of which are accessible from your Dashboard. For more details on our Certificate pricing, please visit our Pricing Page.