Learn the basic topics of Excel 365. Microsoft Excel is a program to design professional, or personal spreadsheets. For this course you will create spreadsheets and formulas, practice data entry and format data.
Skills you’ll gain
Microsoft ExcelSpreadsheetsMicrosoft 365Microsoft Dynamics 365Microsoft Office 365Microsoft Office Specialist (MOS) - ExcelWhat You'll Learn
- Create spreadsheets and build formulas and functions in Microsoft Excel 365
- Practice data entry by entering text, numbers, and dates and editing data
- Format data using font styles, borders, backgrounds, number and date formatting, and conditional formatting
- Manage worksheets by adding, renaming, moving, copying, hiding, and unhiding them
- Navigate the Excel interface including the Ribbon, Quick Access Toolbar, Backstage, and Mini Toolbar
- Work with data efficiently using Autofill, Find and Replace, Format Painter, freezing panes, and Paste Special
Key Takeaways
- This is a beginner course covering the basic topics of Microsoft Excel 365.
- Microsoft Excel is a program used to design professional or personal spreadsheets.
- The course covers creating spreadsheets and formulas, data entry, and formatting data.
- Lessons walk through the Excel interface, including the Title Bar, Quick Access Toolbar, Ribbon, Backstage, and Mini Toolbar.
- The course covers worksheet management tasks such as inserting and deleting columns, freezing and splitting panes, and hiding and unhiding rows and columns.
Frequently Asked Questions
What will I learn in this course?
You will learn the basic topics of Excel 365, including how to create spreadsheets and formulas, practice data entry, and format data.
What level is this Excel course?
It is a beginner course covering the basic topics of Microsoft Excel 365.
What is Microsoft Excel used for?
Microsoft Excel is a program used to design professional or personal spreadsheets.
What topics do the lessons cover?
Lessons cover opening and saving workbooks, entering and editing text, numbers and dates, formatting (font styles, borders, backgrounds, numbers, dates, and conditional formatting), managing worksheets, and formulas and functions, among others.
What skills does this course relate to?
The course relates to Microsoft Excel, Spreadsheets, Microsoft 365, Microsoft Dynamics 365, Microsoft Office 365, and the Microsoft Office Specialist (MOS) - Excel.
Transcript
Show transcript (free preview lesson)
Transcript of the free preview lesson. Remaining lessons unlock with the full course.
Hello, and welcome to KnowledgeCity's course on Excel 365. This is the beginner course. My name is Steve Paulick, and I will be your instructor leading your through the lessons. 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 changes, 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 is 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,8 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.