Course Overview
Teacher
Paula is a Qualified CPA with over 15 years' experience in the fields of Accountancy, Business Management, Process improvement, Operations management and Training. All across a broad range of industries and sectors. Paula is also well know as Key... View ProfileDetails
- Total Time 48 min
- Lessons 7
- Attachments 10
- Exercises 15
-
28 CQ
7 Lessons in This Course
-
10 minAnalytics lesson 16 CQ
Need to know the basics of the VLOOKUP function in Microsoft Excel? In this lesson, learn how to use VLOOKUP exact match and approximate match.
with PaulaNeed to know the basics of the VLOOKUP function in Microsoft Excel? In this lesson, learn how to use VLOOKUP exact match and approximate match.
-
10 minAnalytics lesson 26 CQ
In this Excel spreadsheets lesson, get an explanation of the match and index functions before learning practical, everyday examples for using both functions.
with PaulaIn this Excel spreadsheets lesson, get an explanation of the match and index functions before learning practical, everyday examples for using both functions.
-
3 minMicrosoft Office lesson 32 CQ
In this advanced Excel or Google Sheets lesson, learn how to perform a lookup that returns values from the left by combining INDEX and MATCH.
with PaulaIn this advanced Excel or Google Sheets lesson, learn how to perform a lookup that returns values from the left by combining INDEX and MATCH.
-
3 minProductivity lesson 42 CQ
In this Excel spreadsheets lesson, learn how to combine the VLOOKUP function with the MATCH function to create a more dynamic and robust formula.
with PaulaIn this Excel spreadsheets lesson, learn how to combine the VLOOKUP function with the MATCH function to create a more dynamic and robust formula.
-
4 minMicrosoft Office lesson 53 CQ
Learn how to extract specific text from a string and combine it with the VLOOKUP function in this Excel spreadsheet lesson about the MID function.
with PaulaLearn how to extract specific text from a string and combine it with the VLOOKUP function in this Excel spreadsheet lesson about the MID function.
-
8 minMicrosoft Office lesson 65 CQ
In this advanced Excel lesson, learn how to use the CHOOSE function for Excel and Google Sheets to look up and return data from different tables.
with PaulaIn this advanced Excel lesson, learn how to use the CHOOSE function for Excel and Google Sheets to look up and return data from different tables.
-
7 minMicrosoft Office lesson 74 CQ
In this Excel spreadsheets and Google Sheets lesson, learn how to carry out simple and complex HLOOKUP formulas to increase data functionality.
with PaulaIn this Excel spreadsheets and Google Sheets lesson, learn how to carry out simple and complex HLOOKUP formulas to increase data functionality.
-
564 min5-part Teaching Skills course36 CQ
Need a little help creating an e-learning course? In this course, online educator Paula demonstrates how to use tools like Google Sheets and Google Forms to increase student course engagement.
with PaulaNeed a little help creating an e-learning course? In this course, online educator Paula demonstrates how to use tools like Google Sheets and Google Forms to increase student course engagement.
-
624 min6-part Accounting course15 CQ
In this course, learn the role of a bookkeeper and their importance in the business accounting process, from tracking different types of transactions to understanding the accounting equation.
with PaulaIn this course, learn the role of a bookkeeper and their importance in the business accounting process, from tracking different types of transactions to understanding the accounting equation.
-
556 min5-part Microsoft Office course31 CQ
Learn how use Microsoft Excel 2013 for bookkeeping with this course from E-Learning Educators. You'll learn how to enter in daybook data, edit it, as well as sort and analyze it using built-in tools.
with PaulaLearn how use Microsoft Excel 2013 for bookkeeping with this course from E-Learning Educators. You'll learn how to enter in daybook data, edit it, as well as sort and analyze it using built-in tools.
-
1079 min10-part Accounting course45 CQ
In this comprehensive course on the nuts and bolts of accounting, learn about sales tax, how to record business transactions in daybooks, prepare invoices, as well as how to code your transactions.
with PaulaIn this comprehensive course on the nuts and bolts of accounting, learn about sales tax, how to record business transactions in daybooks, prepare invoices, as well as how to code your transactions.
-
5 minTeaching Skills lesson3 CQ
If you have a passion and knowledge to share, online teaching can be extremely satisfying. In this lesson, discover seven reasons why you should teach online!
with PaulaIf you have a passion and knowledge to share, online teaching can be extremely satisfying. In this lesson, discover seven reasons why you should teach online!
-
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.