课程详情

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!

课程标签

0人关注该课程

主题相关的课程