Learn the basic topics of Excel 365. Microsoft Excel is a program to design professional, or personal spreadsheets. In this course you will learn how to get started using Excel, how to create new workbooks, organizing your worksheet and basic formulas.
Skills you’ll gain
Microsoft ExcelSpreadsheetsExcelPackageMicrosoft 365Microsoft Office 365Microsoft Office Specialist (MOS) - ExcelWhat You'll Learn
- Get started using Microsoft Excel 365 and create new workbooks
- Open and save workbooks and navigate the Title Bar and Quick Access Tool Bar
- Organize worksheets by inserting, deleting, hiding, and unhiding rows and columns
- Enter, edit, find, and replace data, and format numbers and dates
- Manage worksheets by adding, renaming, hiding, freezing panes, and splitting panes
- Create basic formulas and functions to add, subtract, multiply, and divide cells
Key Takeaways
- Microsoft Excel is a program used to design professional or personal spreadsheets.
- The course covers getting started in Excel, creating new workbooks, organizing worksheets, and using basic formulas.
- Learners practice data tasks such as entering and editing data, finding and replacing data, and formatting numbers and dates.
- Worksheet organization skills include freezing panes, splitting panes, and adding, renaming, and hiding worksheets.
- Basic calculation skills cover creating and inserting functions, using Auto Calculate, and adding, subtracting, multiplying, and dividing cells.
Frequently Asked Questions
What does this course cover?
This course teaches the basic topics of Excel 365, including how to get started using Excel, how to create new workbooks, organizing your worksheet, and basic formulas.
Is this course suitable for beginners?
Yes. It covers the basic topics of Excel 365, starting with how to get started using Excel and progressing through creating workbooks, organizing worksheets, and basic formulas.
What skills will I gain from this course?
You will build skills in Microsoft Excel, spreadsheets, ExcelPackage, Microsoft 365, Microsoft Office 365, and Microsoft Office Specialist (MOS) - Excel.
What formula and function topics are included?
The course covers creating basic functions, inserting functions, using Auto Calculate, and adding, subtracting, multiplying, and dividing cells.
What worksheet management topics are taught?
Topics include opening and saving workbooks, freezing and splitting panes, adding, renaming and hiding worksheets, and hiding and unhiding rows and columns.
Transcript
Show transcript (free preview lesson)
Transcript of the free preview lesson. Remaining lessons unlock with the full course.
Hello, and welcome to Nautilus City's course on Excel 365. This is the beginner course. My name is Steve Pollock. Now I'll be your instructor leading you through the lesson. In this course, you will learn the basics of Excel 365, and by the end of this course, you will be able to use the basic functions of Excel 365. Now let's talk a little bit about Excel. Excel 365 is a spreadsheet program used to organize information. It can perform complex numerical calculation. When numbers change, Excel can recalculate the answers for you. It can be customized to create charts, tables, graphs, and you can use formulas and program how to handle the data. Excel is part of the Office 365 suite, which includes many different programs. It's a subscription software, so you would pay a yearly or monthly subscription to use it. Excel can work with other office software, such as Word and Access and other programs. MS Office can also be standalone software. Now let's get started with the course.
Learn on the Go
Take your learning anywhere — the KnowledgeCity mobile app lets you watch lessons on the go.