Tutorialspoint

April Learning Carnival is here, Use code FEST10 for an extra 10% off

Microsoft Excel 365 - from basic to advanced

person icon Widhi Muttaqien

4.4

Microsoft Excel 365 - from basic to advanced

Become an Excel master as fast as possible and leverage your business or career

updated on icon Updated on Apr, 2024

language icon Language - English

person icon Widhi Muttaqien

English [CC]

category icon Office Productivity,Microsoft,Excel

Lectures -88

Duration -10.5 hours

4.4

price-loader

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

In this online course, you will learn Microsoft Excel from the zero level to the expert level, in the shortest time possible, through an easy learning process. I designed the curriculum very carefully to maximize its effectiveness. After learning from this course, in sha Allah, you will have real and applicable competencies that can be utilized to skyrocket your business or your career.

About the author

Hi, my name is Widhi Muttaqien. I am an entrepreneur, who also an academic lecturer in the information system and computer graphics fields. By the time I record this video, I have more than 50,000 students globally around the world. In terms of formal education, I have a bachelor degree in IT with a concentration in software development. I also have a master degree in business management as well as information systems. For more than 20 years, I have been using Microsoft Excel for a variety of needs, be it for business or for academic purposes. I used Excel for bookkeeping or finance, student data management, academic research, project management, data analysis, and so on.

What you will learn

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 Smart Art, 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 a master of Excel.

Goals

What will you learn in this course:

  • Build a solid foundation of understanding Microsoft Excel
  • Use modern formulas and functions in Excel such as SUM, AVERAGE, and XLOOKUP
  • Manage large data easier with Sorting, Filter, Table, and PivotTable
  • Design attractive data presentation utilizing various formatting and graphic techniques
  • Thoroughly understand various types of cell references in Excel
  • Learn from a professional with more than 20 years of experience

Prerequisites

What are the prerequisites for this course?

  • Operating a computer in general
  • Have Microsoft Excel 365 or 2019 already installed
Microsoft Excel 365 - from basic to advanced

Curriculum

Check out the detailed breakdown of what’s inside the course

Introduction
2 Lectures
  • play icon Introduction 03:28 03:28
  • play icon Conventions and information 04:30 04:30
The basics of Excel
8 Lectures
Tutorialspoint
Working with data
7 Lectures
Tutorialspoint
Cell references
6 Lectures
Tutorialspoint
Data presentation
13 Lectures
Tutorialspoint
Managing table structure
3 Lectures
Tutorialspoint
Graphics and Charts
16 Lectures
Tutorialspoint
Advanced data processing
7 Lectures
Tutorialspoint
Table and PivotTable
6 Lectures
Tutorialspoint
Conditional formatting
7 Lectures
Tutorialspoint
Printing and exporting
12 Lectures
Tutorialspoint

Instructor Details

Widhi Muttaqien

Widhi Muttaqien

e


Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515