Enjoying the preview?
This is the free first lesson. Get full access — request a demo or sign in.
Worksheet Basics
Learn how to work with text, values, rows, columns, worksheets, and tabsPreview the first lesson free — get full access to all 6 lessons.
Beginner Provider : Douglas Bush 6 Lessons · 12m in Arabic, German, English, Spanish, French, Portuguese, Chinese
Course Description
Excel offers an extensive set of options for formatting a spreadsheet, including many that are unique to Excel. Formatting can be added to a spreadsheet in several ways, including the format as table feature, which includes additional options for data management. You can change the overall layout and design of a spreadsheet by inserting and deleting worksheets, rows, and columns.
In this course, you’ll learn how to organize your data in an effective way, then apply formatting to titles, headings, text, and values to achieve a more professional appearance. You’ll see how easy it is to convert a simple spreadsheet into a table, complete with formatting and built-in filtering and sorting options. You’ll also learn how to work with rows, columns, worksheets, and tabs.
What You'll Learn
- Create well-designed spreadsheets by formatting titles, headings, text, and values for a professional appearance
- Modify the spreadsheet structure by inserting and deleting worksheets, rows, and columns
- Convert a simple spreadsheet into a table using the Format as Table feature
- Work with rows, columns, worksheets, and tabs to change a spreadsheet's layout and design
- Apply built-in filtering and sorting options that come with converting data to a table
- Organize data effectively before applying formatting in Excel
Key Takeaways
- Excel offers an extensive set of formatting options for spreadsheets, including many that are unique to Excel.
- Formatting can be added in several ways, including the Format as Table feature, which provides additional options for data management.
- Converting a simple spreadsheet into a table adds formatting along with built-in filtering and sorting options.
- You can change a spreadsheet's overall layout and design by inserting and deleting worksheets, rows, and columns.
- Organizing data effectively first, then formatting titles, headings, text, and values, gives a spreadsheet a more professional appearance.
Frequently Asked Questions
What will I learn in the Worksheet Basics course?
You will learn how to organize your data effectively, apply formatting to titles, headings, text, and values for a more professional appearance, convert a spreadsheet into a table with built-in filtering and sorting, and work with rows, columns, worksheets, and tabs.
What topics does this course cover?
The course covers formatting titles and headings, formatting text, formatting values, converting to tables with Format as Table, rows and columns, and worksheets and tabs.
What skills does this course help me build?
It builds skills in Microsoft Excel, spreadsheets, document formatting, SpreadsheetML, tabular data, and tabular form.
How do I create a table from a spreadsheet in this course?
The course shows how to use the Format as Table feature to convert a simple spreadsheet into a table, complete with formatting and built-in filtering and sorting options.
