Microsoft Excel from basic to advanced
Microsoft Excel from basic to advanced
MP4 | h264, 1280x720 | Lang: English | Audio: aac, 44100 Hz | 10h 35m | 5.38 GB
What you'll learn
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 the master of Excel.
Who this course is for:
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 large data analysis and present them effectively
Homepage
