Tutorialspoint
Subscription Includes
$ 249   8.77

Microsoft Excel 365 - 2019 from basic to advanced

Created by Widhi Muttaqien, Last Updated 10-Feb-2021, Language:English

Microsoft Excel 365 - 2019 from basic to advanced

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

Created by Widhi Muttaqien, Last Updated 10-Feb-2021, Language:English

What Will I Get ?

  • 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

Requirements

  • Operating a computer in general
  • Have Microsoft Excel 365 or 2019 already installed

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.

Course Content

Widhi Muttaqien

Entrepreneur and Computer Graphics expert

I’m an entrepreneur and also an academic lecturer in Computer Graphics field. I’ve been teaching and doing hundreds of CG related projects for more than 2 decades now. I have a bachelor degree in software development and a master degree in business management and information system.