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
  • The fundamentals of Excel
  • Different cell references in Excel
  • Formulas and functions like SUM, AVERAGE, XLOOKUP, etc.
  • Present data attractively using formatting and graphical techniques
  • Manage large amounts of data with sorting, filtering, tables, and PivotTables
  • And many more

There are tons of things that you will learn in this online course. It would be too long to explain all of them in this short description text. To see the details, you can check the curriculum section of this course. I will only explain some of them briefly here.

In the first chapter, you will get to know the basics of Microsoft Excel, such as how to work with files, exploring the user interface, how to navigate, and so on.

Then you will learn the basics of working with data in Excel, such as using AutoFill, using formulas, understanding different types of copy-and-paste, learn to use various types of cell references, from the simplest to the complex ones, and so on.

Next, you will learn the ins and outs of data presentation in Excel. From formatting basic texts, numbers, cells, borders, effects, styles, and so on. Then learn various techniques for structuring the table.

In the next section, you will learn about various things related to graphics. Such as inserting and managing image files, creating shape and text box objects, creating SmartArt, creating Charts, and also Sparklines.

In the next chapter, we will discuss advanced data processing techniques. We will discuss things like notes, comments, find and replace techniques, data sorting, filters, Freeze Pane, and so on.

Then after that, we will discuss in detail everything related to tablespivot tables, and how to combine the two features. We'll also cover a variety of conditional formatting features from the basic examples to more complex ones.

And in the final chapter, we will cover different techniques related to printing and exporting, such as defining print areas, managing headers and footers, data protection, exporting to PDF or XPS, etc.

So, join this course now! And become the master of Excel.

  • Basic skills for operating a computer
  • Have Microsoft Excel 365 or 2019 already installed
  • Beginners who want to learn Microsoft Excel from scratch
  • Employees who want to improve their career by leveraging Excel
  • Students and academics who need an effective tool to perform research
  • Managers or CEOs who need to perform data analysis and present them effectively
View More...
  • Section 1 : Introduction 2 Lectures 00:07:40

    • Lecture 1 :
    • Lecture 2 :
    • Conventions and information
  • Section 2 : The basics of Excel 8 Lectures 00:47:01

    • Lecture 1 :
    • Working with Excel files
    • Lecture 2 :
    • Ribbon Menu and Quick Access Toolbar
    • Lecture 3 :
    • UI theme, Background and Options
    • Lecture 4 :
    • The basics of inputting data
    • Lecture 5 :
    • Data types
    • Lecture 6 :
    • Contextual menus
    • Lecture 7 :
    • Data structure
    • Lecture 8 :
    • Navigation
  • Section 3 : Working with data 7 Lectures 00:51:42

    • Lecture 1 :
    • Editing data and AutoFill
    • Lecture 2 :
    • Creating custom AutoFill
    • Lecture 3 :
    • Undo, Redo, Save, and Save-as
    • Lecture 4 :
    • The basics of Formula
    • Lecture 5 :
    • Introduction to Function, SUM and AVERAGE
    • Lecture 6 :
    • XLOOKUP function
    • Lecture 7 :
    • Cut, Copy, and Paste
  • Section 4 : Cell references 6 Lectures 00:44:54

    • Lecture 1 :
    • Cell reference range
    • Lecture 2 :
    • Relative vs Absolute References
    • Lecture 3 :
    • Mixed reference and the ROUND function
    • Lecture 4 :
    • External Worksheet reference
    • Lecture 5 :
    • External Workbook Reference
    • Lecture 6 :
    • Named reference
  • Section 5 : Data presentation 13 Lectures 01:33:32

    • Lecture 1 :
    • Formatting basics in Excel
    • Lecture 2 :
    • Number formatting and Format Painter
    • Lecture 3 :
    • Custom formatting
    • Lecture 4 :
    • Basic date formatting
    • Lecture 5 :
    • Advanced date formatting
    • Lecture 6 :
    • Text formatting
    • Lecture 7 :
    • Text color
    • Lecture 8 :
    • Fill color
    • Lecture 9 :
    • Border line settings
    • Lecture 10 :
    • Border styles and colors
    • Lecture 11 :
    • Column and row sizes
    • Lecture 12 :
    • Text position and orientation
    • Lecture 13 :
    • Cell Styles
  • Section 6 : Managing table structure 3 Lectures 00:20:22

    • Lecture 1 :
    • Organizing table structure
    • Lecture 2 :
    • Hiding columns and rows
    • Lecture 3 :
    • Merging and splitting cells
  • Section 7 : Graphics and Charts 16 Lectures 02:00:01

    • Lecture 1 :
    • Inserting images
    • Lecture 2 :
    • Insert versus Link
    • Lecture 3 :
    • Transformation and snapping
    • Lecture 4 :
    • Managing visual objects in Excel
    • Lecture 5 :
    • Transparency and Cropping
    • Lecture 6 :
    • Shape objects basics
    • Lecture 7 :
    • Lock Drawing, Modifiers and Alignment
    • Lecture 8 :
    • Editing Shapes
    • Lecture 9 :
    • Text box
    • Lecture 10 :
    • Effects and Styles
    • Lecture 11 :
    • Grouping
    • Lecture 12 :
    • SmartArt in Excel
    • Lecture 13 :
    • Creating Charts in Excel
    • Lecture 14 :
    • Managing chart objects and data
    • Lecture 15 :
    • Chart design customization
    • Lecture 16 :
    • Sparkline
  • Section 8 : Advanced data processing 7 Lectures 00:54:25

    • Lecture 1 :
    • Paste types
    • Lecture 2 :
    • Notes and Comments
    • Lecture 3 :
    • Find
    • Lecture 4 :
    • Replace
    • Lecture 5 :
    • Sorting data
    • Lecture 6 :
    • Filters
    • Lecture 7 :
    • Freeze panes
  • Section 9 : Table and PivotTable 6 Lectures 00:47:05

    • Lecture 1 :
    • Excel table basics
    • Lecture 2 :
    • Advanced Excel table
    • Lecture 3 :
    • PivotTable basics
    • Lecture 4 :
    • PivotTable Field, Filter, and Slicer
    • Lecture 5 :
    • PivotTable design
    • Lecture 6 :
    • Connecting Excel table to PivotTable
  • Section 10 : Conditional formatting 7 Lectures 00:51:32

    • Lecture 1 :
    • Conditional formatting basics
    • Lecture 2 :
    • Conditional custom formatting
    • Lecture 3 :
    • Advanced conditional rules
    • Lecture 4 :
    • Rule stacking
    • Lecture 5 :
    • Conditional formatting with graphics
    • Lecture 6 :
    • Active cell in Excel
    • Lecture 7 :
    • Conditional formatting with formulas
  • Section 11 : Printing and exporting 12 Lectures 01:36:35

    • Lecture 1 :
    • Basic printing techniques
    • Lecture 2 :
    • Selective printing
    • Lecture 3 :
    • Adding a Header or Footer
    • Lecture 4 :
    • Header or Footer content and size
    • Lecture 5 :
    • Managing Headers and Footers
    • Lecture 6 :
    • Scale to fit
    • Lecture 7 :
    • Sheet options
    • Lecture 8 :
    • Locking data in Excel
    • Lecture 9 :
    • Protecting Excel files
    • Lecture 10 :
    • Print to PDF and XPS
    • Lecture 11 :
    • Exporting with Insert Object
    • Lecture 12 :
    • Exporting with Copy and Paste
  • 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?

6139 Course Views

7 Courses

Widhi is the CEO of Expose Academy and the founder of several other creative-based companies. He holds a Bachelor's degree in Computer Science and a Master's degree in Business Administration and Information Systems. In addition to his business activities, he is also an academic lecturer in the field of computer graphics. With more than 20 years of experience in the CG industry, he has completed hundreds of projects with clients from all over the world. He has produced thousands of CG images and animations. His deep passion for computer graphics leads him to dive into digital painting, 3D visualization, animation, game development, web design, video and motion graphics.
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.