Excel 2013 Worksheet Basics & Formatting
An 11-part course with SONIC Performance Support
Start Free Preview Start CourseCourse Overview
Teacher
SONIC Performance Support is a leading provider of e-learning and performance support solutions. We proudly serve individuals, government agencies, schools and businesses of all sizes. SONIC Performance Support provides high-quality video training,... View ProfileDetails
- Total Time 1 hr, 12 min
- Lessons 11
- Attachments 7
- Exercises 26
-
41 CQ
11 Lessons in This Course
-
9 minFREEMicrosoft Office lesson 1Free5 CQ
Learn how to use Excel's Auto Fill feature to specify how a selected cell range should be filled, creating series of dates, days, times, numbers, and quarters.
Learn how to use Excel's Auto Fill feature to specify how a selected cell range should be filled, creating series of dates, days, times, numbers, and quarters.
-
7 minFREEMicrosoft Office lesson 2Free4 CQ
Using cell names and range names can save you time and energy! Discover how to properly label and use cell names and range names in this Excel 2013 lesson.
Using cell names and range names can save you time and energy! Discover how to properly label and use cell names and range names in this Excel 2013 lesson.
-
3 minMicrosoft Office lesson 32 CQ
In this lesson, learn about the various options available for customizing formulas in Excel, from checking for errors to setting calculation specifications.
In this lesson, learn about the various options available for customizing formulas in Excel, from checking for errors to setting calculation specifications.
-
7 minMicrosoft Office lesson 44 CQ
This lesson demonstrates how to tailor the Quick Access Toolbar in Excel with different features, giving you fast and easy access to your favorite options.
This lesson demonstrates how to tailor the Quick Access Toolbar in Excel with different features, giving you fast and easy access to your favorite options.
-
9 minMicrosoft Office lesson 55 CQ
Learn how to create custom tabs and groups in the Microsoft Excel ribbon, and see how to link the ribbon to your Outlook email account for easy access.
Learn how to create custom tabs and groups in the Microsoft Excel ribbon, and see how to link the ribbon to your Outlook email account for easy access.
-
6 minMicrosoft Office lesson 64 CQ
In this lesson, learn how to use Excel's Spell Check function. See how to add terms to the program's dictionary, use AutoCorrect, and even switch languages.
In this lesson, learn how to use Excel's Spell Check function. See how to add terms to the program's dictionary, use AutoCorrect, and even switch languages.
-
8 minMicrosoft Office lesson 75 CQ
In this lesson, learn how to use Cell Styles in Excel to apply multiple formatting options to cells at the same time for a neat and consistent appearance.
In this lesson, learn how to use Cell Styles in Excel to apply multiple formatting options to cells at the same time for a neat and consistent appearance.
-
2 minMicrosoft Office lesson 82 CQ
It's important to make sure your (and your clients') documents are safe and secure! In this lesson, learn how to customize Excel's Trust Center for your data.
It's important to make sure your (and your clients') documents are safe and secure! In this lesson, learn how to customize Excel's Trust Center for your data.
-
7 minMicrosoft Office lesson 94 CQ
Managing workbooks in Excel is easy! Learn how to move, insert, remove, hide, and unhide worksheets in this lesson with Jillian from SONIC.
Managing workbooks in Excel is easy! Learn how to move, insert, remove, hide, and unhide worksheets in this lesson with Jillian from SONIC.
-
5 minMicrosoft Office lesson 103 CQ
Working with large, complex workbooks in Excel 2013? In this lesson, learn how to manage your workbook tabs by renaming, moving, and color coding them.
Working with large, complex workbooks in Excel 2013? In this lesson, learn how to manage your workbook tabs by renaming, moving, and color coding them.
-
4 minMicrosoft Office lesson 113 CQ
How data is displayed affects its readability. In this lesson, see how to freeze, unfreeze, split, and switch Excel data to make your worksheets user-friendly.
How data is displayed affects its readability. In this lesson, see how to freeze, unfreeze, split, and switch Excel data to make your worksheets user-friendly.
-
1790 min17-part Microsoft Office course53 CQ
Learn how to transform data into whatever form you need with a few clicks! This intermediate course on Excel introduces filtering, sorting, pivot tables, and more for all-star data management.
Learn how to transform data into whatever form you need with a few clicks! This intermediate course on Excel introduces filtering, sorting, pivot tables, and more for all-star data management.
-
621 min6-part Microsoft Office course14 CQ
Want to dive into the best of Excel? In this course, SONIC Performance Support introduces intermediate to advanced data management techniques, from debugging complex formulas to creating web queries.
Want to dive into the best of Excel? In this course, SONIC Performance Support introduces intermediate to advanced data management techniques, from debugging complex formulas to creating web queries.
-
16218 min16-part Management course118 CQ
Does your device come with Microsoft Office 365? In this comprehensive course, get familiar with all the helpful apps this productivity program offers, from Mail to Skype for Business.
Does your device come with Microsoft Office 365? In this comprehensive course, get familiar with all the helpful apps this productivity program offers, from Mail to Skype for Business.
-
8106 min8-part Basic Computing course57 CQ
Need detailed guidance on how to make the best of the Windows 10 operating system? This course familiarizes beginner students with the Windows 10 user interface and its basic capabilities.
Need detailed guidance on how to make the best of the Windows 10 operating system? This course familiarizes beginner students with the Windows 10 user interface and its basic capabilities.
-
27 minMicrosoft Office lesson14 CQ
Learn how to create Excel PivotTables, which provide powerful ways to interact with data through easy-to-read formats, and can summarize large amounts of data.
Learn how to create Excel PivotTables, which provide powerful ways to interact with data through easy-to-read formats, and can summarize large amounts of data.
-
762 min7-part Microsoft Office course33 CQ
New to Microsoft Office? Then you're probably eager to get started with Microsoft Word, the go-to program for creating text documents. Over the course of 13 lessons, instructor Richard Rost will walk you through an overview of Microsoft Word basics. Learn to navigate the program using the Word interface and ribbon. Once you're comfortable, learn to create a document—a business letter—and enter edit, and format text. You'll learn a few keyboard shortcuts and how to print, email, and save files.
with AmicronNew to Microsoft Office? Then you're probably eager to get started with Microsoft Word, the go-to program for creating text documents. Over the course of 13 lessons, instructor Richard Rost will walk you through an overview of Microsoft Word basics. Learn to navigate the program using the Word interface and ribbon. Once you're comfortable, learn to create a document—a business letter—and enter edit, and format text. You'll learn a few keyboard shortcuts and how to print, email, and save files.
-
11137 min11-part Microsoft Office course73 CQ
Learn how to crunch through your PowerPoint slides, create decks you’re proud of, and finish your PowerPoint presentation quickly and professionally with hotkeys and the Quick Access Toolbar!
Learn how to crunch through your PowerPoint slides, create decks you’re proud of, and finish your PowerPoint presentation quickly and professionally with hotkeys and the Quick Access Toolbar!
-
26150 min26-part Microsoft Office course89 CQ
Discover some of Microsoft Excel's most handy formulas, shortcuts, and add-ins in this course. From sorting through data, to using a solver to optimize values, increase your Excel productivity today.
Discover some of Microsoft Excel's most handy formulas, shortcuts, and add-ins in this course. From sorting through data, to using a solver to optimize values, increase your Excel productivity today.
-
12175 min12-part Microsoft Office course94 CQ
Whether you’re a beginner or have Excel experience, this course will help you master one of the most powerful Microsoft Office programs available. Motion Training covers the fundamental skills you need to become a power user, including: proper spreadsheet set up, workbooks, calculations, formulas, functions (such as AutoFill and AutoSum), cell formatting, and charting. All lessons include .xlsx files so you can follow along for practice. Note that videos show Excel 2010.
with Motion TrainingWhether you’re a beginner or have Excel experience, this course will help you master one of the most powerful Microsoft Office programs available. Motion Training covers the fundamental skills you need to become a power user, including: proper spreadsheet set up, workbooks, calculations, formulas, functions (such as AutoFill and AutoSum), cell formatting, and charting. All lessons include .xlsx files so you can follow along for practice. Note that videos show Excel 2010.
-
661 min6-part Microsoft Office course34 CQ
Learn everything you need to know to get up and running with Powerpoint in just 1 hour! This course covers design, style, transitions, animations and a few advanced topics too.
Learn everything you need to know to get up and running with Powerpoint in just 1 hour! This course covers design, style, transitions, animations and a few advanced topics too.