Online training - access your course anytime, anywhere! Call us on 1300 009 924
Courses
Technology
Information Technology & Operations
Cloud Computing
Cyber Security
Data Science & Engineering
Programming & Web Development
Systems, Networking & Support
Business
Business & Leadership
Human Resources
Marketing & Social Media
Business Analytics
Project Management
Work, Health & Safety
Community & Health
Community Services & Counselling
Ageing & Disability Support
View all courses
View All IT Operations Courses
Short Courses
General IT Skills
Cert III
Information Technology
IT - Basic Cloud Computing
IT - Cyber Security Awareness
IT - Programming
IT - Web Development
Bootcamps
Professional Diploma in UX Design
Professional Certification in User Interface Design
Cert IV
Information technology
IT - Networking
IT - Programming
IT - Systems Administration Support
IT - Web Development
Diploma
Information Technology
IT - Advanced Networking
IT - Cloud Engineering
IT - Cyber Security
Bachelor
Bachelor of Games Development
Bachelor of Animation
Diploma
IT - Cloud Engineering
Cert III
IT - Basic Cloud Computing
Bootcamp
Cloud Architect
AWS Cloud Architect
Azure Cloud Architect
Short Courses
Basic Cyber Security
CompTIA Security+ Certification
Cert III
IT - Cyber Security Awareness
Bootcamp
Cyber Security Specialist
Cyber Security Professional
Diploma
IT - Cyber Security
Bootcamp
Data Scientist
Data Analyst
Big Data Engineer
Artificial Intelligence Engineer
Short Courses
Programming
Cert III
IT - Programming
IT - Web Development
Cert IV
IT - Programming
IT - Web Development
Bootcamp
Professional Diploma in UX Design
Professional Certification in User Interface Design
Automation Test Engineer
Full Stack Web Developer - MEAN Stack
Bachelor
Bachelor of Games Development
Bachelor of Animation
Short Course
Networking
DevOps Specialist
Cert IV
IT - Networking
IT - Systems Administration Support
Diploma
IT - Advanced Networking
View All Business & Leadership Courses
Short Course
Team Management
Emotional Intelligence & Personal Wellbeing
Advanced Leadership and Management
Introduction to Leadership & Management
Certificate in Xero
Certificate in Xero Payroll
Cert IV
Business
Business (Administration)
Business (Leadership)
Business (Operations)
Leadership and Management
Entrepreneurship and New Business
Cert III
Business
Business Administration
Diploma
Business
Business (Leadership)
Business (Operations)
Business (Organisational Development)
Leadership and Management
Short Course
Team Management
Human Resources
Cert IV
Human Resource Management
Diploma
Human Resource Management
Short Courses
Social Media Marketing
Social Media Essentials
Personal Branding
Linkedin Marketing
Facebook Marketing
YouTube Marketing
Social Media Strategy
Cert IV
Marketing & Communications
Diploma
Marketing & Communication
Social Media Marketing
Short Courses
CBAP Certification Course
Tableau Certification Training
University Program
Professional Certificate Program in Business Analysis
Professional Certificate Program in Data Analytics
Bootcamp
Business Analyst
Data Analyst
Short Courses
Introduction to Project Management
ITIL 4 Foundation Certification Course
Cert IV
Certificate IV in Project Management Practice
Bootcamp
PMP® Plus
Diploma
Project Management
Cert IV
Work Health and Safety
Diploma
Work Health and Safety
View all Community Services Courses
Short Courses
Introduction to Community Services
Alcohol and Other Drugs Skill Set
Short Course in Counselling
Cert III
Community Services
Cert IV
Mental Health
Alcohol and Other Drugs
Dual Certificate IV in Alcohol and Other Drugs and Mental Health
Diploma
Counselling
Community Services (Case management)
Advanced Diploma of Community Sector Management
Bachelor
Bachelor of Counselling
Bachelor of Social Work
View all Ageing & Disability Support Courses
Cert III
Individual support (Ageing)
Individual support (Disability)
Individual support (Ageing & Disability)
For Organisations
About Upskilled for Business
EOFY 2024
Tech Academy
Microsoft Training
EPI Training
CompTIA Courses
ITIL Courses
Leadership Academy
Business Communication
Leadership & Management
View all courses
Microsoft Training Portfolio
Microsoft 365 Apps - Custom Training
Microsoft Excel
Excel Beginner Course
Excel Intermediate Course
Excel Expert Course
Microsoft Azure
AZ-900T00 - Azure Fundamentals Course
AZ-104T00 - Azure Administrator Course
AZ-305T00 - Designing Microsoft Azure Infrastructure Solutions
AZ-400T00 - Designing and Implementing Microsoft DevOps Solutions
DP-203T00 - Data Engineering on Microsoft Azure
Microsoft Power BI
PL-300 - Power BI Data Analyst Course
Microsoft 365
MS-900T01 - Microsoft 365 Fundamentals
MS-700T00 - Managing Microsoft Teams
MD-102T00 - Microsoft 365 Endpoint Administrator
MS-102T00 - Microsoft 365 Administrator
Microsoft Security, Compliance, and Identity
SC-900 - Security, Compliance, and Identity Fundamentals
AZ-500T00 - Microsoft Azure Security Technologies
SC-200 - Microsoft Security Operations Analyst
Microsoft Sharepoint
55215 - SharePoint Online Power User
55238 - SharePoint Online for Administrators
EPI Training Portfolio
EPI Foundation Courses
Data Centre Foundation Certificate (DCFC®)
EPI Design/Build Courses
Certified Data Centre Professional (CDCP®)
Certified Data Centre Specialist (CDCS®)
Certified Data Centre Expert (CDCE®)
Certified Network Cabling Design Professional (CNCDP®)
EPI Maintenance/Operations Courses
Certified Data Centre Facilities Operations Specialist (CDFOS®)
Certified Data Center Facilities Operations Manager (CDFOM®)
Certified Data Centre Environmental Sustainability Specialist (CDESS)
IT Infrastructure and Networks
CompTIA Network+ Training
CompTIA Linux+
CompTIA A+ Core 1
CompTIA A+ Core 2
Cyber Security
CompTIA Security+ Training
CompTIA Cybersecurity Analyst (CySA+)
CompTIA PenTest+
ITIL® 4 Foundation Course
2-Day Business Communication Credential
4-Day Leadership Excellence Credential
Emotional Intelligence and Personal Wellbeing
CareerTalk
Tech Job Portal
SkillsTalk Blog
Career advice
Change jobs
Develop your career
Financial advice
Find a job
Return to work
Work from home
News
Study advice
Study online
Continue your education
Pathways to university
Self Improvement
Government Assistance
All study advice
Jobs by industry
Business Industry
IT Industry
Community Services Industry
Explore Job Roles
View all
Courses by career
Small Business Owner
Human Resource Officer
Business Administrator
Business Leader / Manager
Marketing Manager
Work Health & Safety
Project Manager
Web Developer
Cyber Security
IT Systems Administrator
Disability Support Worker
Counselling
View all
Studying with us
FAQ's
Studying at Upskilled
Upskilled Partner Short Courses
Additional Learning Content
Ways to Pay
How to Enrol
Student Support
Individual Course Questions
View all
More Info
Online Learning
Qualifications
Career Outcomes
All FAQs
Government funding
Australia wide
South Australia
Queensland (HigherLevels)
Queensland (Certificate 3 Guarantee)
ACT
Northern Territory
Why Upskilled
Why Upskilled
Student stories
Meet our trainers
About Upskilled
About Upskilled
Who we work with
Jobs at Upskilled
Meet the team
Enrol now
Enquire now
Enquire

Microsoft Excel Intermediate Course

Boost your Excel skills with our Intermediate Course. Explore advanced formulas, functions, formatting, and charting techniques for efficient data handling. Whether a professional or an Excel enthusiast, this course elevates your expertise.
 

Upcoming Sessions:
  • 18th Apr 2024
  • 9th May 2024
Enquire now
*By providing your information, you agree to our Privacy Policy and to receiving email and other forms of communication from Upskilled. You are able to opt-out at any time.
100% online
Enrol now
Vendor Aligned Technical Training
1 Day Virtual Classroom
10+ Topics
Purchase online now

$350.00

ONE EASY PAYMENT
 
Ready to enhance your Excel skills? Microsoft Excel 2016 - Intermediate (Level 2) is for those with basic Excel knowledge, covering advanced topics.

Enrol Now & Gain Essential Microsoft Excel skills!

 
Enrol now

Microsoft Excel Intermediate is your gateway to expanding your Excel expertise and crafting highly efficient workbooks. This course dives deep into advanced formula and function techniques, advanced formatting, charting features, and sophisticated data manipulation tools such as goal seeking. Gain the skills and knowledge to boost your productivity and take your Excel proficiency to the next level.
 

Enhance your technical skills and explore fresh opportunities. Enrol today and commence your path to mastering Microsoft Excel with Upskilled Tech Academy

 

Who is this course for?

  • Professionals seeking advanced data analysis and reporting skills.
  • Individuals aiming to streamline data manipulation and informed decision-making.
  • Students and academics for academic and research purposes.
  • Small business owners managing data efficiently.
  • Data enthusiasts wanting to excel in data-driven tasks.
  • Anyone passionate about mastering Excel for various applications.

Course Detail

Join our comprehensive one-day virtual classroom for Excel 2016 - Intermediate (Level 2). Discover advanced formula and function techniques, formatting, charting features, and data manipulation tools. Master diverse worksheet techniques, page setup, formatting, functions, defined names, goal seeking, Quick Analysis tools, table management, and chart enhancement.


While the courses are using Excel 2016 content, the trainers work hard to make it relevant to the latest 2019, 2021, and 365 versions of Office, ensuring the content is forward-compatible. Labs are offered in 2016, and students can use their own version of Office, ensuring that the learning experience is compatible with the everyday versions students use.

Course Structure

This course will provide in-depth coverage of the following topics:

  • Data Filling
  • Worksheet Techniques
  • Page Setup
  • Borders and Formatting
  • Functions and Formulas
  • Defined Names
  • Number Formatting
  • Conditional Formatting
  • Goal Seeking
  • Quick Analysis Tools
  • Worksheet Tables
  • Chart Elements
  • Chart Formatting
Upskilled Certificate of Attendance

Entry requirements

Start date

Microsoft Excel 2016 - Intermediate (Level 2) (relevant to the latest 2019, 2021, and 365 versions) assumes that participants possess the knowledge required to create, edit, print, and chart simple worksheets. Understanding ranges and copying data is also essential for this course, as it builds upon these foundational skills.

Rest assured, our course structure is designed to provide a clear and accessible learning path, ensuring that learners can confidently advance their Excel expertise beyond the basics.

FAQs

What is Microsoft Excel - Level 2 Course?

Microsoft Excel 2016 - Level 2 is an advanced Excel course designed to expand your spreadsheet expertise. In this course, you will delve into complex formulas, advanced formatting techniques, data manipulation tools, and more. It's a comprehensive program that empowers you to create highly productive workbooks, making you proficient in handling intricate data tasks.

 

Who will benefit from this Microsoft Excel course?

  • Professionals seeking to enhance their Excel skills for more advanced data analysis and reporting.
  • Individuals looking to streamline their data manipulation processes and make informed decisions.
  • Students and academics wanting to master Excel's advanced features for academic and research purposes.
  • Small business owners aiming to create sophisticated reports and streamline data management.
  • Data enthusiasts who want to take their spreadsheet proficiency to the next level and excel in data-driven tasks.

 

Do I need any prior knowledge of Excel?

To get the most out of Microsoft Excel 2016 - Level 2, it's beneficial to have prior experience in creating, editing, printing, and charting simple worksheets. Understanding ranges and data copying is also important as this course builds upon these foundational skills. If you have a basic grasp of Excel, you're ready to dive into Level 2.

 

Is this course suitable for both individuals and organisations to use?

Yes, this course is suitable for both individuals and organisations. Whether you're looking to enhance your personal Excel skills or upskill your team for more efficient data management and analysis, Microsoft Excel 2016 - Level 2 offers valuable benefits for both individuals and organisations.

 

What can I expect after completing this course?

After completing the Microsoft Excel 2016 - Level 2 course, you can expect to gain advanced Excel skills that will significantly improve your data management and analysis abilities. You'll become proficient in creating efficient workbooks, using complex formulas, applying advanced formatting, and utilising data manipulation tools. These skills are valuable for personal use and can also enhance your career opportunities.

 

What's next?

We're here to help.
Talk to an Upskilled Education Consultant
about which course is best suited to you.

Get in touch
1300 472 713

Enquire today

Sounds just like the course you're after? Speak with a career consultant to discover what it's like to study the Microsoft Excel Intermediate Course. Send us an enquiry and we'll get in touch.

*By providing your information, you agree to our Privacy Policy and to receiving email and other forms of communication from Upskilled. You are able to opt-out at any time.

Download course guide

Want to know all about this course? Get our course brochure to discover what it's like to study Microsoft Excel Intermediate Course. Submit your details and simply click 'Download'.

Download course guide

Want to know all about this course? Get our course brochure to discover what it's like to study . Submit your details and simply click 'Download'.

*By providing your information, you agree to our Privacy Policy and to receiving email and other forms of communication from Upskilled. You are able to opt-out at any time.

Enrol Online Now - It's easy and simple.

Thank you for choosing Microsoft Excel Intermediate Course - delivered by .

Fill out your details below to enrol today. Once we have your payment details, you'll receive your course login within the next working day.

Course price (GST inclusive):
350.00
Credit card details:
Payment succeeded, Please wait.

 
We value your security
When purchasing from Upskilled Pty Ltd, your credit card information is entered into a secure server encrypted using 128-bit Secure Socket Layer (SSL) technology - the current state of the art for Internet security.

The information is sent to your card issuer's bank over a secure, proprietary connection. When the authorisation process is complete - this takes around five seconds - you receive an approval or decline response in your browser, and Upskilled is informed appropriately to initiate the enrolment process.

If you have any questions regarding this payment, please contact our customer support centre at support@upskilled.edu.au.

Privacy
By providing your information, you agree to our Privacy Policy and to receiving email and other forms of communication from Upskilled. You are able to opt-out at any time.

Terms and Conditions
Please click the following link to read the Upskilled Terms and Conditions
https://www.upskilled.edu.au/terms-and-conditions

Enquire now

Start your next course with Upskilled. Enter your details in the form below.

*By providing your information, you agree to our Privacy Policy and to receiving email and other forms of communication from Upskilled. You are able to opt-out at any time.

Enquire now

Start your next course with Upskilled. Enter your details in the form below.

*By providing your information, you agree to our Privacy Policy and to receiving email and other forms of communication from Upskilled. You are able to opt-out at any time.