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
What you'll learn?
- 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
Course Overview
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 tables, pivot 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.
Pre-requisites
- Basic skills for operating a computer
- Have Microsoft Excel 365 or 2019 already installed
Target Audience
- 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
Curriculum 87 Lectures 10:34:49
Section 1 : Introduction
- Lecture 2 :
- Conventions and information
Section 2 : The basics of Excel
- 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
- 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
- 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
- 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
- Lecture 1 :
- Organizing table structure
- Lecture 2 :
- Hiding columns and rows
- Lecture 3 :
- Merging and splitting cells
Section 7 : Graphics and Charts
- 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
- 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
- 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
- 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
- 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
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
6868 Course Views
7 Courses