Excel For Beginners! Top 30 Hottest Tutorials,Tips & Tricks!

Name: Excel For Beginners! Top 30 Hottest Tutorials,Tips & Tricks!
Rating: 4.1 (1272 reviews)

Learn by doing in small, easy to understand bite sized chunks! Learn VLOOKUP,Macros,Operators,Custom Formats and More!

Created byWaqar Ahmad

Last updated 1/2021

English

English [Auto],

What you'll learn

You will learn some of the most commonly used Features of Excel at a comfortable pace!
You will learn to Filter, Sort and Organize large sets of Data!
You will build the foundational knowledge needed to become Excel Power Users.
You will have the support of an Excel Trainer with over a decade of experience!
You will learn what a VLOOKUP and how to use it!
You will learn how to design and build your first Macro!
You will learn to be comfortable in your newly found Excel Shoes!

Course content

5 sections • 30 lectures • 2h 16m total length

Setting up for Success! Creating Shortcuts for Excel1:33
Learn how to set up Excel for quick access by pinning to the taskbar, pinning to the start menu, and creating a desktop shortcut in Windows 10.
Opening our first Workbook and checking out Excel Templates!2:45
Navigating Excel and Introducing the File Menu2:02
The Quick Access Toolbar3:51

Introducing the Excel Ribbon and Tabs4:07
Explore the Excel ribbon and tabs, including File, Home, Insert, and Data. See how each tab groups commands for inserting charts and formulas, organizing data, and reviewing workbooks.
Lets Customize the Ribbon!4:41
Lecture 7: Entering Data into our Worksheet4:33
Navigate and enter data in excel by using the cell pointer and name box to locate j14, differentiate numbers, text, and formulas, and use equals to create formulas.
Working with Auto Fill and Flash Fill in Excel!3:39
Organizing Worksheets in Excel!5:07
Brrr!! Freezing Panes, Cells and Rows!3:37
Learn how to freeze and unfreeze rows and columns in Excel to keep headers visible while scrolling, using top row, first column, and intersection techniques.
Handling Data, Rows & Columns in Excel3:04
Finding & Replacing Data in Excel4:47
Learn to use Excel's find and replace tool to locate repeated data across a workbook and automatically update it, including options like search scope, case, match, and replacing all instances.

Simple and Custom Sorting In Excel7:24
Table Design & Filtering Data3:40
Arranging and Hiding Columns and Rows4:40
Resize and format cells in Excel by adjusting column width and row height, use auto fit, and learn to hide or reveal rows, columns, and worksheets.
Arranging Cells and Text Data5:11
Discover how to format and arrange cells in Excel by applying styles, merging cells, and using wrap text, shrink to fit, and alignment for clean, readable data layouts.
Introducing Number Formatting in Excel4:40

Introducing the Format Painter2:20
Conditional Formatting2:32
Apply conditional formatting in Excel to highlight sales data with data bars, color scales, and icon sets, revealing trends, outliers, and profit patterns in the global superstore dataset.
Working with Multiple Conditional Formats2:28
How to Format Text Data Types3:22
Creating your own Custom Formatting Rules!4:57
Introduction to Formulas!4:47
Master Excel formulas by learning arithmetic and comparison operators, the order of operations, and using parentheses to control precedence with practical examples.
How to Enter Formulas in Excel5:05

Calculating Percents & Absolute References!9:45
Explore calculating percentages and using absolute references in Excel with real-world scenarios, including applying sales tax, dollar accounting formats, and the sum function.
The AutoSum Tool & Contiguous vs. Non-Contiguous Data Ranges5:13
Learn to use auto sum and the status bar quick sum, and differentiate contiguous versus non-contiguous data ranges for totals in Excel.
Calculating Date & Time6:05
Creating Validation Rules for Data Entry6:19
The VLookup Made EASY!7:13
Hi everyone and welcome to the session on VLookups! I've designed this to be able to be understood by not speaking about it in terms of Excel! Everyone does that and I think that If you can apply a real life situation to learning VLOOKUP, you'll have an easier time remembering how it works and why it works the way it does! Use the "Vlookup Practice".XLS file attached in the resources section of this lecture so that you can practice along with our example!

BEST OF LUCK!
Lecture 30: Building and Running our First Macro!6:47

Requirements

Access to ANY version of Microsoft Excel (We will be using Student 2019)
A Desire to learn a valuable skill!
A Desire to be known as the Excel Guy or Gal in their place of work or business!
Just a Few Minutes a day!

Description

If you were like me many years ago, you'd be terrified if someone asked you to do anything in excel! Custom Formatting? Formulas? Yikes!!! This very feeling is why I created Excel Made Easy - A Break down Step by Step Approach! With over 15 years of Excel Experience and 10 of those in Data Analysis each and every day, I know what the world of Excel can look like and its a beautiful one at that and with these skills is how I created Excel For Beginners - Top Tutorials, Tips and Tricks!

I know what you're thinking - BUT WAQAR! Excel is so complicated and has so many hard to use tools! And My answer to that is You're right and wrong! Excel has many tools and they're all unique in the way they function but "Excel Made Easy" is taught in a way that allows you to take the complicated stuff, break it down and FULLY understand it before moving on. I built this course with the absolute beginner in mind and I ASSUME YOU KNOW NOTHING! With this approach I can guarantee that my course provides more value than you bargain for but never less.

In this course, you'll learn Excel in the easiest way possible and I've kept it as affordable as possible for my students!

Don't just take my word for it! See it first hand from Reviews by thousands of satisfied students!

---------------------------

Excellent course. I have just started a new job after a 2 year layoff and your course helped me remember a lot of what I had forgotten. Thank you. - RC

---------------------------

THE WAY THEY ARE UNDERSTANDING US IN VERY SIMPLE AND POLITE MANNER IS GOOD! - Himashu Sachdeva

----------------------------

I am planning to learn business analytics and wanted a quick refresher of Excel fundamentals. It is important to familiarize with the software, its functionality and features to make the most of it. I recommend it to anyone who wants to learn Excel. - Zahid

----------------------------

clear teachings and very explanative presentation - Adejare Buhari Tope

----------------------------

What are you waiting for? Come join the thousands of students learning Excel in the easiest way possible on Udemy in HD.

Your Instructor,

Waqar

Who this course is for:

Someone who has never heard or worked with Excel
Students who aren't ready for advanced Excel concepts just yet!
Beginner students who would like to learn Excel from scratch!
Folks who need a fresher in Excel after not using it for some time.

Excel For Beginners! Top 30 Hottest Tutorials,Tips & Tricks!

What you'll learn

Explore related topics

Course content

A kick start to Excel!4 lectures • 10min

Moving onto the Details!8 lectures • 34min

Digging Deeper! Sorting Data, Table Design, Number Formatting and More!5 lectures • 26min

Formatting Various Data Types!7 lectures • 26min

Bonus Content6 lectures • 41min

Requirements

Description

Who this course is for: