NOW ONLY
AU$249
Save AU$150 (38%)OFF RRP AU$399

Learn How To Excel in Excel
Part 1 : Advanced File Tasks
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. 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.
Course Fast Facts:
- Easy to follow and understand
- Only 6 to 8 hours of study is required
- Unlimited, lifetime access to online course
- Delivered 100% on-line and accessible 24/7 from any computer or smartphone
- You can study from home or at work, at your own pace, in your own time
- Certificate of Completion
Course Delivery
Courses are accessed online via our learning management system by any device including PC, MAC, tablet or Smart Phone.
Recognition & Accreditation
The courses offered by Courses For Success are unique as they are taught in a step by step process enabling students to complete them quickly and easily, so that you can obtain your qualification sooner. All students who complete the course receive a certificate of completion. Courses For Success is committed to high completion rates and therefore 100% student satisfaction.
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
Entry requirements
Students must have basic literacy and numeracy skills.
Minimum education
Open entry. Previous schooling and academic achievements are not required for entry into this course.
Computer requirements
Students will need access to a computer and the internet.
Minimum specifications for the computer are:
Windows:
- Microsoft Windows XP, or later
- Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari)
MAC/iOS
- OSX/iOS 6 or later
- Modern and up to date Browser (Firefox, Chrome, Safari)
All systems
- Internet bandwidth of 1Mb or faster
- Flash player or a browser with HTML5 video capabilities(Currently Internet Explorer 9, Firefox, Chrome, Safari)
Students will also need access the following applications:
Adobe Acrobat Reader
Courses For Success is a global course platform that started in 2008 with 5 courses, since then we have grown to over 10,000 online courses. As our courses are delivered online via the internet, we sell our courses worldwide.
Our courses span across many categories including Academic, Animal, Beauty, Business, Career, Counseling, Creative & Media, Health & Therapy, Hobbies & Trades, IT, Personal Development, Sports & Fitness.
Some of the companies we work with include Groupon, Living Social, CNN, Entrepreneur, Mashable, Reed UK, Stack Social and many more.
The Personal Success Training Program was developed by Courses For Success to help our customers achieve success. Currently, we are offering this program for FREE with every course or bundle purchase this month. This is a limited time offer! We have received thousands of reviews for this program, please see: Personal Success Training Program Reviews
No, anyone who has an interest in learning more about this subject matter is encouraged to take our course. There are no entry requirements to take this course.
No, you do not require a High School Diploma or to have finished school to study this course, this course is open to anyone who would like to take this course.
This course is provided in English, however, due to the digital nature of our training, you can take your time studying the material and make use of tools such as google translate and Grammarly.
All our courses are accessible online on any device. You may complete them at your own pace and at your own time.
After you have completed the payment, you will receive a confirmation email and tax receipt. You will also receive an email containing your course login details (username and password), as well as instructions on how to access and log in to your course via the internet with any device, please check your junk/spam folder in the event that you do not receive the email.
Providing you have internet access you can start this course whenever you like, just go to the login page and insert your username and password and you can access the online material.
Online learning is 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.
You don't need to be a computer expert to succeed with our online training, but you should be comfortable typing, using the internet and be capable of using common software (such as Microsoft word).
There is no time limit for completing this course, it can be studied in your own time at your own pace. Once you have purchased this course you will have unlimited lifetime access, meaning you can access this course whenever you want.
Individual courses are designed to be completed within 6-8 hours.
If you choose a course bundle, simply multiply the above hours by the number of courses included in the bundle.
For example:
- 2 course bundle is 2 x 6-8 hours = 12-16 hours
- 3 course bundle is 3 x 6-8 hours = 18-24 hours
- 5 course bundle is 5 x 6-8 hours = 30-40 hours
- 10 course bundle is 10 x 6-8 hours = 60-80 hours
All the required material for your course is included in the online system, you do not need to buy anything else.
Yes, all our courses are interactive.
Yes, you will be required to complete a multiple-choice test online at the end of your course, you can do this test as many times as you require.
You will receive a Certificate of Completion that is applicable worldwide, which demonstrates your commitment to learning new skills. You can share the certificate with your friends, relatives, co-workers and employers. Also, include it in your resume/CV, professional social media profiles and job applications.
Wendy Sue Hunt - 5 STAR REVIEW
"If you are considering taking any “Courses for Success”, I would highly recommend it. I have always been a firm believer it’s important to always sharpen your skills. You are never too old to learn more. I found the courses very helpful, interesting and easy to understand.
The term “Courses for Success” helped me in my current position to succeed. After completing the courses, I gave my manager the completion certificates. Recently I received a promotion too."
Valencia Marie Aviles - 5 STAR REVIEW
"I had a very good experience with my course. It has helped me to get multiple jobs and prepared me for almost everything I would need to know. The course was very informative and easy to understand and broken up perfectly to be done in a short amount of time while still learning a good amount! I would recommend Courses for Success to anyone trying to get abs certifications for job advancements, it is well worth it!"
ELENA GRIFFIN - 5 STAR REVIEW
"I have absolutely enjoyed the materials from Courses for Success. The materials are easy to understand which makes learning enjoyable. Courses for Success have great topics of interest which make you come back for more.
Thank you Courses for Success for being part of my learning journey and making education affordable!"
Our completion certificates are very valuable and will help you progress in your work environment and show employers how committed you are to learn new skills, you might even get a promotion.
No, it is not equivalent to a college or university credit.
This course will give you the skills you need to help you obtain employment, but it’s up to you if you get the job or not.
Studying and completing this course will show employers that you have the knowledge in this field, additionally you will gain more confidence in this area of expertise.
The Certificates are valid for life and do not need renewing.
Courses are studied online at your own pace and you are free to study as many or as few courses as you wish, we also offer online course bundles that allow you to save on additional courses so that you may get all the topics related to your training goals in one go.
We accept payments via PayPal, Credit Card, Bank Transfer and Amazon Pay for the USA. For payment plans, we offer Sezzle for USA & Canada, Afterpay for Australia & New Zealand. *For faster transaction Credit Card payments are preferred. Please purchase online via our website course product page or contact us at , to pay via bank transfer.

Special Offer
|
Training 2 Or More People?
Empower your business with access to 500+ job & soft skills online training courses. |
SUCCESS PRO - For Business |
Course Summary
Course ID: | 002EX10INOC |
---|---|
Delivery Mode: |
Online |
Access: | Lifetime Course Access |
Time: | Study at your own pace |
Duration: | 6 - 8 Hours |
Qualification: | Certificate |
- Call 1300 478 223
- Chat to us live
- Send us an enquiry
- Print this course page
