Excel Productivity Tips
A 26-part course with Bitesize Business School
Start Free Preview Start CourseCourse Overview
Teacher
I'm a software engineer and entrepreneur. I've also started several businesses. Bitesizebschool.com is the latest, where I write about applying business principles to the real world and solving technology issues that every online business faces. I'm... View ProfileDetails
- Total Time 2 hr, 30 min
- Lessons 26
- Attachments 9
- Exercises 66
-
89 CQ
26 Lessons in This Course
-
10 minFREEMicrosoft Office lesson 1Free6 CQ
Bitesize Business School helps you get started with Excel by demonstrating how to open a new document and template, save a file, and explore the Ribbon.
Bitesize Business School helps you get started with Excel by demonstrating how to open a new document and template, save a file, and explore the Ribbon.
-
7 minMicrosoft Office lesson 24 CQ
In this beginner-friendly lesson from Bitesize Business School, gain an overview of using Excel formulas, with a focus on the all-important SUM formula.
In this beginner-friendly lesson from Bitesize Business School, gain an overview of using Excel formulas, with a focus on the all-important SUM formula.
-
10 minMicrosoft Office lesson 36 CQ
Learn how to separate text values into separate cells, apply a formula down an entire column, and much more in this lesson on working with Excel formulas.
Learn how to separate text values into separate cells, apply a formula down an entire column, and much more in this lesson on working with Excel formulas.
-
2 minMicrosoft Office lesson 42 CQ
Do you want to learn how to combine text from different cells into one cell? Discover how to use the CONCATENATE function in Microsoft Excel.
Do you want to learn how to combine text from different cells into one cell? Discover how to use the CONCATENATE function in Microsoft Excel.
-
2 minMicrosoft Office lesson 52 CQ
In this Microsoft Excel lesson from Bitesize Business School, learn how to use the SUMPRODUCT function to perform multi-column summation with ease.
In this Microsoft Excel lesson from Bitesize Business School, learn how to use the SUMPRODUCT function to perform multi-column summation with ease.
-
2 minMicrosoft Office lesson 62 CQ
In this beginner-friendly lesson from Bitesize Business School, learn how to calculate the number of days and years between two dates in Excel.
In this beginner-friendly lesson from Bitesize Business School, learn how to calculate the number of days and years between two dates in Excel.
-
6 minMicrosoft Office lesson 74 CQ
Learn how to use the VLOOKUP function, or vertical lookup, to identify a value within a table and find its corresponding value in Microsoft Excel.
Learn how to use the VLOOKUP function, or vertical lookup, to identify a value within a table and find its corresponding value in Microsoft Excel.
-
12 minMicrosoft Office lesson 87 CQ
In this lesson from Bitesize Business School, learn how to format phone numbers in Microsoft Excel using the SUBSTITUTE formula and formatting presets.
In this lesson from Bitesize Business School, learn how to format phone numbers in Microsoft Excel using the SUBSTITUTE formula and formatting presets.
-
6 minMicrosoft Office lesson 94 CQ
Being able to sort through Excel spreadsheets is an important skill that allows you to identify numbers and analyze data with ease. Learn how in this lesson.
Being able to sort through Excel spreadsheets is an important skill that allows you to identify numbers and analyze data with ease. Learn how in this lesson.
-
3 minMicrosoft Office lesson 102 CQ
In this lesson from Bitesize Business School, discover how Excel defines a value, and understand how to find and remove duplicate numbers and names in a table.
In this lesson from Bitesize Business School, discover how Excel defines a value, and understand how to find and remove duplicate numbers and names in a table.
-
7 minMicrosoft Office lesson 114 CQ
Follow along with this lesson to learn how to highlight cells and make data in an Excel spreadsheet more visual with conditional formatting.
Follow along with this lesson to learn how to highlight cells and make data in an Excel spreadsheet more visual with conditional formatting.
-
3 minMicrosoft Office lesson 122 CQ
Have you ever noticed how Microsoft Excel automatically formats certain types of data in a spreadsheet? Learn about Excel's AutoFormat feature in this lesson.
Have you ever noticed how Microsoft Excel automatically formats certain types of data in a spreadsheet? Learn about Excel's AutoFormat feature in this lesson.
-
5 minMicrosoft Office lesson 133 CQ
Learn how to make a pie chart in Excel, change its title, update its data source, and make sure the chart accurately reflects any changes you make to the table.
Learn how to make a pie chart in Excel, change its title, update its data source, and make sure the chart accurately reflects any changes you make to the table.
-
3 minMicrosoft Office lesson 142 CQ
Microsoft Excel 2013 features a Quick Analysis tool that allows you to select data and quickly browse valuable information about it. Learn how to use it today!
Microsoft Excel 2013 features a Quick Analysis tool that allows you to select data and quickly browse valuable information about it. Learn how to use it today!
-
4 minMicrosoft Office lesson 153 CQ
Learn how to split the screen view and arrange multiple sheets in a tiled formation so that you can view and edit multiple Excel worksheets at once.
Learn how to split the screen view and arrange multiple sheets in a tiled formation so that you can view and edit multiple Excel worksheets at once.
-
4 minMicrosoft Office lesson 163 CQ
Being able to freeze rows and columns in a spreadsheet comes in handy, especially when working with long spreadsheets. Learn how to freeze them in this lesson.
Being able to freeze rows and columns in a spreadsheet comes in handy, especially when working with long spreadsheets. Learn how to freeze them in this lesson.
-
3 minMicrosoft Office lesson 172 CQ
In this lesson from Bitesize Business School, learn how to access Microsoft Excel keyboard shortcuts using the Alt key; then start saving time!
In this lesson from Bitesize Business School, learn how to access Microsoft Excel keyboard shortcuts using the Alt key; then start saving time!
-
3 minMicrosoft Office lesson 182 CQ
Whether you want to reformat it, copy it, or more, learn how to select data in Excel using keyboard shortcuts in this lesson from Bitesize Business School.
Whether you want to reformat it, copy it, or more, learn how to select data in Excel using keyboard shortcuts in this lesson from Bitesize Business School.
-
6 minMicrosoft Office lesson 194 CQ
Learn how and where to access an exhaustive list of all of the shortcut keys for your version of Excel. Then, review a couple of the most important shortcuts.
Learn how and where to access an exhaustive list of all of the shortcut keys for your version of Excel. Then, review a couple of the most important shortcuts.
-
3 minMicrosoft Office lesson 202 CQ
In this lesson from Bitesize Business School, learn how to make an organizational chart in Excel using SmartArt. Then, see how to use the chart in PowerPoint.
In this lesson from Bitesize Business School, learn how to make an organizational chart in Excel using SmartArt. Then, see how to use the chart in PowerPoint.
-
6 minMicrosoft Office lesson 214 CQ
Did you know that you can build a database in Excel? It's true—and it's so easy! Learn how to make an Excel database in this Bitesize Business School lesson.
Did you know that you can build a database in Excel? It's true—and it's so easy! Learn how to make an Excel database in this Bitesize Business School lesson.
-
3 minMicrosoft Office lesson 222 CQ
Create a clean, focused spreadsheet—that only shows the data that you're working with—by learning how to hide and unhide columns and rows in Microsoft Excel.
Create a clean, focused spreadsheet—that only shows the data that you're working with—by learning how to hide and unhide columns and rows in Microsoft Excel.
-
2 minMicrosoft Office lesson 232 CQ
In this lesson from Bitesize Business School, learn how to color tabs in Microsoft Excel to stay organized, easily look up important data, and more.
In this lesson from Bitesize Business School, learn how to color tabs in Microsoft Excel to stay organized, easily look up important data, and more.
-
10 minMicrosoft Office lesson 246 CQ
In this lesson, learn how to use the Solver in Microsoft Excel to define and solve problems, then make sound business decisions based on concrete data.
In this lesson, learn how to use the Solver in Microsoft Excel to define and solve problems, then make sound business decisions based on concrete data.
-
6 minMicrosoft Office lesson 254 CQ
Did you know that you can import data from the Federal Reserve into a spreadsheet? Learn how to use the FRED add-in for Excel to extract Fed data with ease.
Did you know that you can import data from the Federal Reserve into a spreadsheet? Learn how to use the FRED add-in for Excel to extract Fed data with ease.
-
8 minMicrosoft Office lesson 265 CQ
Do you want to learn how to extract data from multiple sources—including the Internet—with ease? Learn how to use Microsoft Excel's Power Query in this lesson.
Do you want to learn how to extract data from multiple sources—including the Internet—with ease? Learn how to use Microsoft Excel's Power Query in this lesson.
-
10121 min10-part UI/UX Design course66 CQ
CSS animations and transitions allow web developers to create dynamic graphical user interface without JavaScript. Learn how to improve user experience with relatively simple CSS coding and syntax.
CSS animations and transitions allow web developers to create dynamic graphical user interface without JavaScript. Learn how to improve user experience with relatively simple CSS coding and syntax.
-
880 min8-part Entrepreneurship course44 CQ
Join in with this course from Bitesize Business School to review the basics of branding. Covered are tips for creating a cohesive brand using the perfect company name, logo, website, and more.
Join in with this course from Bitesize Business School to review the basics of branding. Covered are tips for creating a cohesive brand using the perfect company name, logo, website, and more.
-
10126 min10-part Web Development course67 CQ
Ready to level up your web development skills? If you want to add a more powerful user experience to the web pages you create, this jQuery overview course can help you get there faster.
Ready to level up your web development skills? If you want to add a more powerful user experience to the web pages you create, this jQuery overview course can help you get there faster.
-
548 min5-part Audio Editing course26 CQ
This course from Bitesize Business School walks through each element for setting up your own mini home recording studio, from equipment to techniques, for recording online classes, podcasts, and more!
This course from Bitesize Business School walks through each element for setting up your own mini home recording studio, from equipment to techniques, for recording online classes, podcasts, and more!
-
13146 min13-part UI/UX Design course80 CQ
Learn the fundamentals of responsive web design, and follow along with several demonstrations on how to implement a fluid, grid-based layout, flexible images, and media queries in your site's code.
Learn the fundamentals of responsive web design, and follow along with several demonstrations on how to implement a fluid, grid-based layout, flexible images, and media queries in your site's code.
-
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.
-
79593 min79-part Microsoft Office course337 CQ
Pivot tables make data analysis and visualization fun! This extensive course explores how to apply the powerful Microsoft Excel pivot table feature to create reports that impress any audience.
with MyExcelOnlinePivot tables make data analysis and visualization fun! This extensive course explores how to apply the powerful Microsoft Excel pivot table feature to create reports that impress any audience.
-
889 min8-part Analytics course49 CQ
Want to improve your website’s SEO? In this course, Collin from White List Marketing Firm shares how to reach the top of Google search results using simple, proven white hat SEO strategy.
with Collin McAdamsWant to improve your website’s SEO? In this course, Collin from White List Marketing Firm shares how to reach the top of Google search results using simple, proven white hat SEO strategy.
-
16187 min16-part Analytics course100 CQ
Google Analytics is an essential tool for any online marketer. In this course for beginners, get a comprehensive overview of how to use it to track and report valuable data about your website.
with EduonixGoogle Analytics is an essential tool for any online marketer. In this course for beginners, get a comprehensive overview of how to use it to track and report valuable data about your website.
-
11122 min11-part Entrepreneurship course66 CQ
Growing a business is much easier with a solid brand in place. Digital marketing expert Dr. Gigi Johnson reveals how to analyze web data to design the launch—or re-launch—of your business.
with Dr. Gigi JohnsonGrowing a business is much easier with a solid brand in place. Digital marketing expert Dr. Gigi Johnson reveals how to analyze web data to design the launch—or re-launch—of your business.
-
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.