When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
Microsoft Excel from Basic to Advanced
Unlock creativity with Skillshare! Learn acrylic painting, AI writing, graphic design, and photography.
This Course Includes
skillshare
0 (0 reviews )
10 hours 35 minutes 
english
Online - Self Paced
course
SkillShare
About Microsoft Excel from Basic to Advanced
Introduction
Conventions and information
Working with Excel files
Ribbon Menu and Quick Access Toolbar
UI theme, Background, and Options
The basics of inputting data
Data types
Contextual menus
Data structure
Navigation
Editing data and AutoFill
Creating custom AutoFill
Undo, Redo, Save, and Save As
The basics of Formula
Introduction to Function, SUM, and AVERAGE
XLOOKUP function
Cut, Copy, and Paste
Cell reference range
Relative vs Absolute cell references
Mixed reference and the ROUND function
External Worksheet reference
External Workbook Reference
Named reference
Formatting basics in Excel
Number formatting and Format Painter
Custom formatting
Basic date formatting
Advanced date formatting
Text formatting
Text color
Fill color
Border line settings
Border styles and colors
Column and row sizes
Text position and orientation
Cell Styles
Organizing table structure
Hiding columns and rows
Merging and splitting cells
Inserting images
Insert versus Link
Transformation and Snapping
Managing visual objects
Transparency and Cropping
Shape objects basics
Lock Drawing, Modifiers, and Alignment
Editing Shapes
Text box
Effects and Styles
Grouping
SmartArt in Excel
Creating Charts in Excel
Managing Charts objects and data
Chart design customization
Sparkline
Paste types
Notes and Comments
Find
Replace
Sorting data
Filters
Freeze panes
Excel Table basics
Advanced Excel Table
PivotTable basics
PivotTable Field, Filter, and Slicer
PivotTable Design
Connecting Excel Table to PivotTable
Conditional formatting basics
Conditional custom formatting
Advanced conditional rules
Rule stacking
Conditional formatting with graphics
Active cell in Excel
Conditional formatting with formulas
Basic printing techniques
Selective printing
Adding a Header or Footer
Header or Footer content and size
Managing Headers and Footers
Scale to fit
Sheet options
Locking data in Excel
Protecting Excel files
Print to PDF and XPS
Exporting with Insert Object
Exporting with Copy and Paste
What You Will Learn?
- 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..