Microsoft Excel for beginners

Learn Excel 365 / 2019 from zero to hero in the shortest time possible

Created by : Rated :4.3 720 views

Last Updated: 2023-12-20 05:12:43 English Course Type: Self Learning

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 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.

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

Section 1 : Introduction 2 Lectures 00:07:40
Lecture 1 :
Introduction Preview
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?

Widhi Muttaqien,

6351 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.