Microsoft Excel – From Beginner to Pro

Go from complete Excel Newbie to Rock Star in just a few hours
What you'll learn:
Be confident in Excel even if you're a complete beginner
Advance your career with your new Excel skills
Enter and format different data type such as text, numbers and dates
Copy and Paste values, formats and formulas with ease
Master tools like AutoFill, FlashFill and Remove Duplicates
Easily Sort, Filter, Find, and Find & Replace data
Find out how Formulas and Functions work in Excel
Learn your first Excel Functions and several advanced Functions
Find out how to print one page, multiple pages and PDFs
Protect and secure your worksheets, workbook structure and files
Create your first Excel Charts
Discover Excel Tables, Pivot Tables and Pivot Charts with Slicers
Requirements:
You do NOT need any prior Excel knowledge to do this course
You need to have Excel 2013, 2016, 2019, 2021 or Microsoft 365 installed on your device
Description:
Go From Excel Newbie To Rock Star In Just a Few Hours!Do you need to learn how to use Excel from the very beginning?Do you wish someone would slow down, explain things properly and talk to you without the jargon?Are you sick of Excel tutorials that you can hardly see because they don't zoom in?Would you like fully interactive lessons with practice files you can download and use in Excel?Well, You've Come To The Right Place!Our "Microsoft Excel - From Beginner to Pro" course gives you everything you need to go from Excel Newbie to total Rock Star in just a few hours.And unlike many other Excel courses, I slow things down, explain things properly and ZOOM IN so you can see everything clearly on your screen.We Start At The Very BeginningFirst up, I take you on a Tour of the main screens and menus so you can find your way around Excel. You'll also learn a few ways to change the look and feel of your Excel screen so you can customise it to your liking.Then we do some Jargon-Busting so you can get to grips with what words like: spreadsheet, workbook, worksheet, row, column and cell actually mean.You will then learn how to create a new spreadsheet, give it a name and save the file to your device or to OneDrive.Then It's Time To Get Into The Good Stuff!Over the next few sections you will learn the Fundamentals of how to manage the Worksheets, Rows, Columns and Cells of your Excel spreadsheets. This includes:Inserting, deleting and renaming worksheetsChanging the height and width of rows and columnsEntering data into cellsMerging and unmerging cellsAnd much moreI will then show you the different Data Formats you can have in your spreadsheet's cells such as: Text, Numbers and Dates and how to easily change the formats if you need to.After that, you will learn a bunch of different ways to Copy and Paste in Excel, including how to paste only values, formats or formulas. Don't miss this!You'll Master Excel's Time-Saving Data ToolsWe then run through some Amazing Tools that will save you lots of time in Excel when using large ranges of data, such as:AutoFill and Flash FillFind and ReplaceRemove DuplicatesSort and FilterEasily Learn Formulas and FunctionsNext up, I explained the Basics of Formulas and Functions in Excel so you can understand how they work before we dive into the lessons on a few of Excel's most basic but popular functions: SUM, AVERAGE, COUNT, MAX and MIN.Once you're ready, you can move on to learning how to use a few more Advanced Functions such as: CONCAT, IF and VLOOKUP.Get On Top of Printing and SecurityI then show you how to set up your Excel spreadsheets properly so you can Print them to one page, multiple pages or PDFs.After that, we'll cover some important security features in Excel such as how to prevent other people from making changes to various parts of your spreadsheets and how to Password Protect your Excel files for added security.Create Your First Charts, Tables and Pivot TablesThen, you'll learn step-by-step how to create your first charts in Excel which are a great way to make large amounts of data easy to read.You'll also learn how to create Excel tables so you can filter and sort your data however you like.Finally, we'll finish the course by learning about how to use Pivot Tables and Pivot Charts, which are powerful tools that you can use to calculate, summarise, and analyse your data.You'll Become An Excel Rock StarI'm confident that I can make you an Excel Rock Star in just a few hours even if you're a total Newbie.So what are you waiting for? Sign up today and take your knowledge of Excel to the next level.See you on the course!
Who this course is for:
This course is perfect if you are new to Excel and you want to start at the beginning
This course if perfect for you if you like well-paced lessons with clear, detailed explanations
This course is perfect for you if you have some experience with Excel but you want to build on your knowledge
Homepage

https://www.udemy.com/course/microsoft-excel-from-beginner-to-pro-course/