Microsoft Excel Ninja Basics - Learn to be an Excel Ninja!

Name: Microsoft Excel Ninja Basics - Learn to be an Excel Ninja!
Rating: 4.5 (10 reviews)

Master the basics of Excel - Navigation, Basic calculations/formulas, shortcuts, pivot tables with examples and more!

Created byDawson Q

Last updated 8/2022

English

English [Auto],

What you'll learn

Navigating around MS Excel: getting started with your first workbook + basic terminologies
Excel keyboard shortcuts + good habits
Use basic Excel formulas and functions (e.g. SUM)
Learn how to manipulate and handle data
Application of these skills in the real world and more!

Course content

2 sections • 17 lectures • 1h 37m total length

Introduction - Welcome to the course!1:37
Learn the basics of Excel and create your first workbook to begin data analysis and management. Build efficiency at work, school, and everyday life with beginner-friendly guidance for new users.
Basics: Opening, closing, saving workbooks [Optional]3:12
Basics: Good for beginners. Skip this part if you are well-versed in this aspect :-)
Navigating around Excel + Basic Terminologies [Optional]5:41
Basics: Good for beginners. Skip this part if you are well-versed in this aspect :-)
Getting your data into workbook + Creating a Table [Optional]5:43
Basics: Good for beginners. Skip this part if you are well-versed in this aspect :-)
Cell formatting + Good habits/shortcuts14:31
Master cell formatting in Excel, including currency, date, time, and numbers, while using essential shortcuts for copy, paste, cut, and transpose; cultivate the habit of saving your workbook.
Basic Functions + Calculations15:24
Learn to create, insert, protect sheets; color and center data, perform calculations with equals and +, -, *, /, and functions like sum, average, product, and if using absolute references.
Sample application: Expense Tracker Table9:51
Build an expense tracker table in Excel, learn to use count, average, and sum formulas, format as currency, and apply if logic to track budget exceedance.
Quick Review

Using Find and Replace5:25
Do refer to the Resources tab to try out these functions yourself (also relevant for use in future lectures) :)
Using Sort and Filter5:14
Master sorting and filtering in Excel to focus on specific data groups, order by date or region, and display only targeted names like Andrew, boosting data clarity and workflow efficiency.
Separating text using Text-to-columns function8:10
Learn how to use text to columns to split names or items into separate columns. Choose delimited or fixed width, adjust spaces or commas as delimiters, and set the destination.
Combining two or more cells together4:04
Learn how to combine two or more items in Excel using the concatenate function or the ampersand operator, including inserting spaces between names.
Removing duplicated data/entries3:19
Learn to remove duplicates in Excel by selecting a cell in the table, choosing remove duplicates under data, and selecting which columns to compare, keeping the first entry.
Transpose + Sequence6:39
In this lesson, we look at how to use the transpose function, and how to efficiency get a range of numbers for use as serial number quickly.
Spell check2:33
Learn to use spell check from the review tab to proofread an entire worksheet, including comments and graphics. Customize language, accept corrections, or ignore terms.
Pivot Table, Pivot Charts4:51
Knowing how to use pivot tables is important - these tables allow anyone to filter and extract important details about the data set they are working with in a number of ways and perspectives. From these pivot tables, charts can also be created to allow people to better visualise the data.

Learn about pivot table and pivot charts in this lesson.
BONUS: Sample data for practice0:52
Practice makes perfect with Excel by using the bonus sample data and practice resources to explore different views, perform analysis, and apply the knowledge from these lessons.
Congratulations! You've completed the course, and have mastered the basics!0:40
Celebrates mastering the basics of Excel and encourages you to explore its features, maximize its use, and apply Excel to CS and everyday life.

Requirements

An open mind that is keen to learn new things.
Don’t worry, you’re at the right place - this course assumes that you have no prior knowledge/interaction with excel.
No prior programming experience needed!

Description

Did you know that nearly 80% of all middle-skill job openings require their potential employees to use spreadsheet software such as Microsoft Excel?*
That’s because Excel is a powerful tool that can be used for data analysis and management, allowing users to gather useful insights into the data that they are working with. It can also be used for "fun" applications, such as to play tic-tac-toe, etc.
Gone are the days where you have to calculate 101 columns of monthly expenses yourself or sketch a graph by hand just to understand your expenses – you can do all these with Excel, at a lesser time!
This course allows you to get started with Excel – starting from the bare basics as getting the fundamentals right is key to mastering Excel. Don't feel overwhelmed, we will go through the basics slowly :)

*according to the report, first discovered by Lauren Weber at the Wall Street Journal.

Money-back guarantee:

Don't worry - there's a 30 day money back guarantee - there's nothing for you to lose when you sign up for this course! Get started today!

Tags: Online Excel, Microsoft Excel, Learn Ms Excel, Basics, Excel Tutorials, Formulas, Shortcuts, Examples, Easy, Productivity, Analyse, Online courses, Certificate courses, Training, Shortcuts, Pivot Table

Who this course is for:

New learners who have no prior knowledge/interaction with Excel and want to harness the power of Excel.
Lifelong learners (it doesn’t matter if you’re 15 or 90 – this course will be suitable for you!)
Students
Aspiring professionals who are keen to learn Excel to increase their value in the job market
Anyone who wants to learn how to unlock the potential of their data (i.e. conduct basic calculations)

Microsoft Excel Ninja Basics - Learn to be an Excel Ninja!

What you'll learn

Explore related topics

Course content

Introduction - Get the basics right!7 lectures • 56min

Data manipulation and handling + how to apply these skills in your work10 lectures • 42min

Requirements

Description

Who this course is for: