All in One Offer! | Access Unlimited Courses in any category starting at just $29. Offer Ends in:

Browse Library

  • Business Solutions
  • Become an Instructor
  • 0
    Shopping Cart

    Your Cart is empty. Keep shopping to find a course!

    Browse Courses
Free
3 days left at this price!

This plan includes

  • Limited free courses access
  • Play & Pause Course Videos
  • Video Recorded Lectures
  • Learn on Mobile/PC/Tablet
  • Quizzes and Real Projects
  • Lifetime Course Certificate
  • Email & Chat Support
Get Unlimited Learning Access
$29
3 days left at this price!
30-Day Money-Back Guarantee

This plan includes

  • Access to 11,000+ Courses
  • Ads free experience Courses
  • Play & Pause Course Videos
  • HD Video Recorded Lectures
  • Learn on Mobile/PC/Tablet
  • Quizzes and Real Projects
  • Lifetime Course Certificate
  • Instructor Direct Support
  • Email & Chat Support
  • Cancel Anytime
$29
$29
$29
  • 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.

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.

  • Users should have a basic understanding of Excel.
  • Users will need the desktop version of Excel installed on a computer
  • Anyone wanting increase their knowledge of Excel
View More...
  • Section 1 : Linking Sheets and Files 3 Lectures 00:39:46

    • Lecture 1 :
    • Lecture 2 :
    • Exercise instructions for Linking sheets
    • Lecture 3 :
    • Course overview
  • Section 2 : Charts 8 Lectures 00:53:19

    • 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 2 Lectures 00:16:19

    • Lecture 1 :
    • Names in Spreadsheets
    • Lecture 2 :
    • QR Codes
  • Section 4 : Conditional Formatting 4 Lectures 00:29:44

    • 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 3 Lectures 00:20:39

    • Lecture 1 :
    • Outline
    • Lecture 2 :
    • SubTotals
    • Lecture 3 :
    • Ratios
  • Section 6 : Logical and Lookup Functions 6 Lectures 00:33:35

    • 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 3 Lectures 00:10:17

    • Lecture 1 :
    • SmartArt diagrams
    • Lecture 2 :
    • Dynamic organisation charts
    • Lecture 3 :
    • SmartArt exercise instructions
  • Section 8 : Pivot Tables 4 Lectures 00:00:00

    • 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 2 Lectures 00:00:00

    • Lecture 1 :
    • Data Analysis
    • Lecture 2 :
    • Data Analysis exercise Instructions
  • Section 10 : Final Exercise 1 Lectures 00:00:00

    • Lecture 1 :
    • Final Exercise Instructions
  • 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?

2386 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...
  • Unmatched Variety and Value!
    Learnfly's monthly subscription offers unlimited access to a vast range of courses. Affordable pricing, compared to competitors, makes it the ultimate choice for continuous learning.
    Jessica M.

    4.7

    JM
  • Top-Notch Quality, Affordable Rates!
    High-quality courses with certified instructors make Learnfly stand out. The affordable pricing is a game-changer for those seeking premium education.
    Alex P.

    4.5

    AP
  • Certified Excellence Every Time!
    Learnfly's courses, taught by certified instructors, ensure top-notch learning experiences. The course completion certificates add significant value to one's skill set.
    Sarah R.

    4.3

    SR
  • Round-the-Clock Support!
    Learnfly goes the extra mile with 24/7 course support. Their dedication to helping students succeed is commendable.
    Ryan K.

    4.1

    RK
  • Learn Anywhere, Anytime!
    Whether on mobile, PC, or tablet, Learnfly's platform offers flexibility. Learning on the go has never been easier.
    Emily S.

    4.7

    ES
  • Job-Ready Skills!
    Learnfly's job-oriented courses equip learners with practical skills for the workplace. An investment in career growth!
    Jake M.

    4.2

    JM
  • Budget-Friendly Brilliance!
    Learnfly's pricing is a steal for the quality and variety of courses offered. Quality education without breaking the bank.
    Olivia T.

    4.5

    OT
  • Instructor Excellence Unleashed!
    Learn from the best with Learnfly's certified instructors. The platform ensures that knowledge is imparted by industry experts.
    Daniel L.

    4.0

    DL
  • Achievement Unlocked!
    Learnfly not only offers courses but also recognizes your efforts with course completion certificates. A sense of accomplishment with every course finished.
    Maya H.

    4.6

    MH
  • Learning Revolution!
    Learnfly's platform is a revolution in education. Access to unlimited courses at affordable rates is a game-changer.
    Ethan W.

    4.7

    EW
  • principles-of-data-cleaning

    Principles of Data Cleaning

    By : Phikolomzi Gugwana

    Lectures 25 Beginner 0:34:10
  • microsoft-power-bi-a-complete-hands-on-training

    Microsoft Power BI-A Complete Hands...

    By : Deepesh Vashistha

    Lectures 41 Beginner 3:35:28

Students learning on Learnfly works with Fortune 500 companies around the globe.

Sign Up & Start Learning
By signing up, you agree to our Terms of Use and Privacy Policy
Reset Password
Enter your email address and we'll send you a link to reset your password.