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
Get Unlimited Learning Access
$29
1 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.
$348 $244 a year Save 30%
1 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
$244
  • Learn the basics of Microsoft Excel
  • Enter and format data
  • Learn to use Functions and Formulas
  • Visualise Data using Charts
  • Printing and Reporting
  • Analyse data with Scenario Manage and Goal Seek
  • Learn the Basics of Pivot Tables
  • Data Validation

Embark on your journey to Excel proficiency with our "Microsoft Excel Fundamentals for Beginners" course. Tailored specifically for beginners, this course demystifies Excel, making it accessible and engaging. From the basics of spreadsheet creation to the intricacies of data analysis, you’ll acquire the skills needed to navigate and utilize Excel with confidence.

What You'll Learn:

  • Excel Basics Uncovered: Start with an easy-to-follow introduction to the Excel interface. Learn how to navigate through the basic features and tools essential for any Excel user.

  • Creating Your First Spreadsheet: Step-by-step guidance on building your first spreadsheet. Learn how to organize data effectively and perform basic operations.

  • Formatting for Clarity and Impact: Discover the secrets of text formatting to make your data clear and visually appealing.

  • Introduction to Formulas and Functions: Gain a solid understanding of Excel's core formulas and functions. Start transforming raw data into insightful information.

  • Charting and Visualization Basics: Learn how to create basic charts and graphs. Visualize your data for better understanding and presentation.

  • Exploring Pivot Tables and Basic Data Analysis Tools: Get started with Pivot Tables, simple data analysis tools, and other features like Goal Seek and Scenario Manager.

Experience a hands-on learning journey with our course, featuring a series of bite-sized lectures and demonstrations led by Kevin, your instructor. Each lecture is meticulously crafted to enhance your understanding and foster practical application. This approach ensures you grasp the essentials of Excel in an easily digestible format.

Complementing these lectures, our course offers hands-on exercises, quizzes and assignments designed to reinforce your learning. You'll get to practice what you've learned in the lectures, allowing you to solidify your newfound skills. This practical approach is key to ensuring that you don't just learn Excel techniques but also become proficient in applying them effectively.

To reinforce your learning, we recommend using the textbook “Using Microsoft Excel – 2023 Edition” along with the course for additional information and practice you can do on your own. Link here.

If there's anything you'd like to know more about or any particular areas of Excel you're interested in exploring, please let me know. This course is designed to be dynamic and responsive to your needs and interests. Your feedback and questions are not only welcome but encouraged, as they help us tailor the course to better suit your needs.

  • Access to a Computer with Microsoft Excel installed. Ideally Microsoft 365 to follow along with the lectures, but any version is acceptable
  • A willingness to learn
  • Beginners
  • New Office Workers or Students
  • Anyone that wants to learn how to build spreadsheets and analyse data with Microsoft Excel
View More...
  • Section 1 : Introduction 9 Lectures

    • Lecture 1 :
    • Lecture 2 :
    • What is a Spreadsheet?
    • Lecture 3 :
    • Home Screen, New and Open
    • Lecture 4 :
    • Titlebar & Quick Access Toolbar
    • Lecture 5 :
    • The Ribbon
    • Lecture 6 :
    • Formula Bar
    • Lecture 7 :
    • Status Bar
    • Lecture 8 :
    • Summary
    • Summary Quiz
    • Lecture 9 :
    • Workbooks & Worksheets
  • Section 2 : Building Spreadsheets 24 Lectures

    • Lecture 1 :
    • Introduction
    • Lecture 2 :
    • Entering Data
    • Lecture 3 :
    • Number Formats
    • Lecture 4 :
    • Using Functions & Formulas
    • Lecture 5 :
    • Assignment 1
    • Lecture 6 :
    • Average Function
    • Lecture 7 :
    • CountIF Function
    • Lecture 8 :
    • Assignment 2
    • Lecture 9 :
    • VLookup Function
    • Lecture 10 :
    • Assignment 3
    • Lecture 11 :
    • Date & Time Functions
    • Lecture 12 :
    • Relative, Absolute & Mixed Cell References
    • Lecture 13 :
    • Count Function
    • Lecture 14 :
    • Adding & Deleting Rows & Columns
    • Lecture 15 :
    • Merging Cells
    • Lecture 16 :
    • Cut, Copy, Paste & Paste Special
    • Lecture 17 :
    • Freeze & Split Panes
    • Lecture 18 :
    • Sorting Data
    • Lecture 19 :
    • Filtering Data
    • Lecture 20 :
    • Introduction to Cell Borders & Shading
    • Lecture 21 :
    • Introduction to Conditional Formatting
    • Lecture 22 :
    • Introduction to Excel Tables
    • Lecture 23 :
    • Table Design Ribbon Tab
    • Lecture 24 :
    • Summary
    • Building Spreadsheets Summary
  • Section 3 : Saving, Printing & Exporting Workbooks 8 Lectures

    • Lecture 1 :
    • Introduction
    • Lecture 2 :
    • Saving Workbooks
    • Lecture 3 :
    • Opening Workbooks
    • Lecture 4 :
    • Preparing a Worksheet for Printing
    • Lecture 5 :
    • Page Margins
    • Lecture 6 :
    • Print Selection
    • Lecture 7 :
    • Exporting Workbooks
    • Lecture 8 :
    • Summary
    • Saving, Printing & Exporting Workbooks
  • Section 4 : Creating Charts 6 Lectures

    • Lecture 1 :
    • Introduction
    • Lecture 2 :
    • Types of Chart
    • Lecture 3 :
    • Inserting a Chart
    • Lecture 4 :
    • Customizing a Chart
    • Lecture 5 :
    • Assignment 4
    • Lecture 6 :
    • Summary
    • Creating Charts Summary
  • Section 5 : Data Validation 5 Lectures

    • Lecture 1 :
    • Introduction
    • Lecture 2 :
    • Introduction to Data Validation Rules
    • Lecture 3 :
    • Adding Validation Rules
    • Lecture 4 :
    • Assignment 5
    • Lecture 5 :
    • Summary
    • Data Validation Summary
  • Section 6 : Data Analysis 9 Lectures

    • Lecture 1 :
    • Introduction
    • Lecture 2 :
    • Introduction to Basic Data Analysis
    • Lecture 3 :
    • Goal Seek
    • Lecture 4 :
    • Assignment 6
    • Lecture 5 :
    • Scenario Manager
    • Lecture 6 :
    • Assignment 7
    • Lecture 7 :
    • Introduction to Pivot Tables
    • Lecture 8 :
    • Assignment 8
    • Lecture 9 :
    • Summary
    • Data Analysis Summary
  • Section 7 : Sharing & Collaboration 2 Lectures

    • Lecture 1 :
    • Introduction
    • Lecture 2 :
    • Sharing a Workbook
  • Section 8 : Macros & Automation 3 Lectures

    • Lecture 1 :
    • Introduction
    • Lecture 2 :
    • Recording a Macro
    • Lecture 3 :
    • Executing a Recorded Macro
  • Section 9 : Summary & Next Steps 2 Lectures

    • Lecture 1 :
    • Wrap up & Summary
    • Lecture 2 :
    • Bonus
  • 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?

90 Course Views

1 Courses

With an impressive tenure exceeding two decades in the computer industry, Kevin Wilson is a proven authority on computers and technology highlighted by extensive experience, and a master's degree in computer science software engineering. His expertise seamlessly extends across a vast array of IT sectors from the artistic arenas of graphic and web design, digital film and photography to the intricate spheres of computer programming and software engineering. His skills also extend to the strategic domains of corporate network development, as well as building computer systems, and IT support. In his capacity as the Senior Writer and Director at Elluminet Press Ltd, Kevin has penned multiple tech-related books that have found favor among home computer users, students and professionals around the world. His contributions in the classroom as a computer science lecturer and IT trainer further demonstrate his knowledge and continue to help people understand computer technology. Kevin's work is well respected among students in England, South Africa, Canada, and the United States. Beyond writing, he lends his technical expertise as a reviewer and consultant to many other computer publications and textbooks. His philosophy, "If you can't explain something simply, then you haven't understood it well enough," is the driving force behind his acclaimed Exploring Tech Series, in which complex technical topics are broken into smaller, comprehensive steps that are easy to understand for both students, professionals, and the average computer user. In addition to this, along with his team, Kevin has written and produced numerous video training courses using visual effects, computer graphics and clear presentation covering a variety of subjects including computer hardware, Microsoft Office, and Python Computer Programming.
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
  • enabling-and-managing-office-365

    Enabling and Managing Office 365

    By : Microsoft

    Lectures 13 Beginner 0:0:0
  • mcsa-microsoft-windows-server-2016-70-740-certification-course

    MCSA Microsoft Windows Server 2016 ...

    By : Lazaro (Laz) Diaz

    Lectures 33 Beginner 3:23:31
  • the-complete-walkthrough-of-end-to-end-azure-services

    The complete walkthrough of end to ...

    By : Varma - TOGAF Certified Enterprise Architect

    Lectures 176 Beginner 23:21:33
  • active-directory-on-windows-server-2016-best-practices

    Active Directory on Windows Server ...

    By : Alexandru Serghie

    Lectures 27 Intermedite 0:55:31
  • microsoft-windows-server-2016-hands-on-training-part-i

    Microsoft Windows Server 2016 - Han...

    By : Prof. K Krahenbill

    Lectures 61 Intermedite 5:43:6

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.