Tech & IT
Business
Coding & Developer
Finance & Accounting
Academics
Office Applications
Art & Design
Marketing
Health & Wellness
Sounds & Music
Lifestyle
Photography
Get Unlimited Learning Access
$29
3 days left at this price!
30-Day Money-Back Guarantee
This plan includes
- Instant access to 11,000+ online courses
- Play & Pause Course Videos
HD Video Recorded Lectures- Learn on Mobile/PC/Tablet
- Quizzes and Real Projects
- Lifetime Course Certificate
- Instructor Chat Support
- Cancel Plan Anytime
Subscribe to Learnfly’s top courses
Get this course, plus 11,000+ of our top-rated courses for one year with Go Annually Plan.
3 days left at this price!
30-Day Money-Back Guarantee
This plan includes
- Instant access to 11,000+ online courses
- Play & Pause Course Videos
- HD Video Recorded Lectures
- Learn on Mobile/PC/Tablet
- Quizzes and Real Projects
- Lifetime Course Certificate
- Instructor Chat Support
- Cancel Plan Anytime
$29
What you'll learn?
- Excel can expand your knowledge and learning by exposing you to new concepts and skills that are relevant and applicable to various fields and domains. You can also use Excel to access and integrate data from different sources, such as web pages, databases, or other applications.
- Excel can boost your career prospects and opportunities by demonstrating your proficiency and competence in a widely used and valued tool. You can also use Excel to create professional-looking reports, dashboards, and presentations that showcase your work and achievements.
- Excel can enhance your productivity and creativity by automating repetitive tasks, creating macros, and using templates. You can also customize the appearance and functionality of Excel to suit your preferences and needs.
- Excel can help you organize and analyse large amounts of data in a clear and efficient way. You can use formulas, functions, charts, tables, and pivot tables to perform calculations, create summaries, and visualize trends.
Course Overview
This course is designed for learners who have some experience with Excel and want to enhance their skills and productivity. In this course, you will learn how to use common formulae and functions, create and format charts and tables, analyse data with pivot tables and slicers, and automate tasks. By the end of this course, you will be able to use Excel as a powerful tool for data analysis and reporting.
Pre-requisites
- Users should have a basic understanding of Excel.
- Users will need the desktop version of Excel installed on a computer
Target Audience
- Anyone wanting increase their knowledge of Excel
Curriculum 36 Lectures 01:11:48
-
Section 1 : Linking Sheets and Files
- Lecture 2 :
- Exercise instructions for Linking sheets
- Lecture 3 :
- Course overview
-
Section 2 : Charts
- Lecture 1 :
- Chart exercise instructions
- Lecture 2 :
- dynamic graphs
- Lecture 3 :
- A Gantt Chart
- Lecture 4 :
- Maps
- Lecture 5 :
- 3dmaps
- Lecture 6 :
- 6.3 Intermeidate charts
- Lecture 7 :
- Pareto Analysis in Excel
- Lecture 8 :
- S curve in Excel
-
Section 3 : Using Names in formulae
- Lecture 1 :
- Names in Spreadsheets
- Lecture 2 :
- QR Codes
-
Section 4 : Conditional Formatting
- Lecture 1 :
- Conditional Formatting
- Lecture 2 :
- Exercise Tracker
- Lecture 3 :
- Weight Loss Tracker
- Lecture 4 :
- Exercise for Conditional formatting and Names
-
Section 5 : Manage Data
- Lecture 1 :
- Outline
- Lecture 2 :
- SubTotals
- Lecture 3 :
- Ratios
-
Section 6 : Logical and Lookup Functions
- Lecture 1 :
- If SumIf and CountIF
- Lecture 2 :
- Timesheet
- Lecture 3 :
- Exercise instructions for IF, SumIf and CountIF
- Lecture 4 :
- Exercise instructions for Lookup functions
- Lecture 5 :
- 7.0 Vlookup and Hlookup functions
- Lecture 6 :
- Invoice
-
Section 7 : SmartArt
- Lecture 1 :
- SmartArt diagrams
- Lecture 2 :
- Dynamic organisation charts
- Lecture 3 :
- SmartArt exercise instructions
-
Section 8 : Pivot Tables
- Lecture 1 :
- Pivot table with calculations
- Lecture 2 :
- A Dashboard using Camera
- Lecture 3 :
- Link Access to Excel
- Lecture 4 :
- Pivot exercise Instructions
-
Section 9 : What IF Analysis
- Lecture 1 :
- Data Analysis
- Lecture 2 :
- Data Analysis exercise Instructions
-
Section 10 : Final Exercise
- Lecture 1 :
- Final Exercise Instructions
Our learners work at
Frequently Asked Questions
-
How do i access the course after purchase?
It's simple. When you sign up, you'll immediately have unlimited viewing of thousands of expert courses, paths to guide your learning, tools to measure your skills and hands-on resources like exercise files. There’s no limit on what you can learn and you can cancel at any time. -
Are these video based online self-learning courses?
Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an indepth knowledge about the topic. -
Can i play & pause the course as per my convenience?
Yes absolutely & thats one of the advantage of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos mulitple times & so on. -
How do i contact the instructor for any doubts or questions?
Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want. -
Do i need a pc to access the course or can i do it on mobile & tablet as well?
Brilliant question? Isn't it? You can access the courses on any device like PC, Mobile, Tablet & even on a smart tv. For mobile & a tablet you can download the Learnfly android or an iOS app. If mobile app is not available in your country, you can access the course directly by visting our website, its fully mobile friendly. -
Do i get any certificate for the courses?
Yes. Once you complete any course on our platform along with provided assessments by the instructor, you will be eligble to get certificate of course completion.
-
For how long can i access my course on the platform?
You require an active subscription to access courses on our platform. If your subscription is active, you can access any course on our platform with no restrictions. -
Is there any free trial?
Currently, we do not offer any free trial. -
Can i cancel anytime?
Yes, you can cancel your subscription at any time. Your subscription will auto-renew until you cancel, but why would you want to?
Instructor
705 Course Views
3 Courses
I have been a Microsoft Office, Project and Visio trainer for IT's Easy Training since 1999. I have trained more than fifteen thousand delegates in various Microsoft applications, with a focus on Excel, Project and Access. I also offer courses on Word, Visio, PowerPoint and Publisher, but less frequently. I am passionate about learning new features and sharing my knowledge with my delegates. I tailor my courses to the business needs of my clients and provide email support and blog updates to help them apply what they learn. I am based in the UK and travel across the country to deliver training sessions.
View More...
