Excel 2021/365 Starter Pack: Beginner to Intermediate Course

Udemy Certificate USD 129.99
Enroll now →
Excel 2021/365 Starter Pack: Beginner to Intermediate Course

About this course

***Exercise and demo files included***We've combined our Excel 2021/365 for Absolute Beginners and Excel 2021/365 Intermediate courses to give you the ultimate starter pack to jump-start your spreadsheet journey!Whether you're an Excel novice or already have some Excel knowledge, this course can help you get the ball rolling. This course bundle will give you a great Excel foundation or build on those skills you already have. It’s also perfect for students who have beginner to intermediate skills in an older version of Excel and are looking to explore the newest features.Excel 2021 is Microsoft's latest stand-alone version of Excel, which opens up many of the features and functionalities that are available only in Excel 365 through a subscription.The only prerequisite for this course is a working copy of Excel 2021 or Excel 265.This course covers:Becoming familiar with what’s new in Excel 2021Navigating the Excel 2021 interfaceUtilizing useful keyboard shortcuts to increase productivityCreating your first Excel spreadsheetUsing basic and intermediate Excel formulas and functionsEffectively applying formatting to cells and using conditional formattingUsing Excel lists and master sorting and filteringWorking efficiently by using the cut, copy, and paste optionsLinking to other worksheets and workbooksAnalyzing data using chartsInserting pictures in a spreadsheetWorking with views, zooms, and freezing panesSetting page layout and print optionsProtecting and sharing workbooksSaving your workbook in different file formatsDesigning better spreadsheets and controlling user inputHow to use logical functions to make better business decision

What you'll learn

  • navigate the Excel 2021 interface
  • create and format spreadsheets
  • use basic and intermediate Excel formulas and functions
  • apply conditional formatting
  • analyze data using charts
  • link worksheets and workbooks
  • use sorting and filtering for efficient data management

Course objectives

  • help beginners become comfortable using Excel
  • build on existing Excel knowledge for intermediate users
  • introduce new features in Excel 2021

Skills you'll gain

Related courses

Course details are provided by the platform and may change — always confirm on the provider's site. Links may be affiliate links.