Have a question that doesn't appear to be addressed here? Email me using my handy Contact Jan form.
These are the features you’ll find most useful when you’re having to write a long document such as a term paper, a thesis, or a novel.
Prerequisites:
Here’s what you can expect to learn:
From there we’ll switch gears and move onto sharing data between the MSOffice applications with these three methods:
Lastly, we’ll look at MS Word’s advanced editing tools:
If you ever need to print out a ton of address labels, or even print addresses on a stack of envelopes, this feature will be your lifesaver!
Prerequisites:
This is probably the shortest outline ever. But don’t let that fool you; there’re a lot of steps involved.
You will learn how to:
These are the features you’ll find most useful when you’re having to write a long document such as a term paper, a thesis, or a novel.
Prerequisites:
Here’s what you can expect to learn:
Then use those features to move on to:
The features in this class will really help you to add some flare to your flyer or newsletter.
We’ll begin with theme options on the Design tab.
Then we’ll explore:
Many of the features you’ll learn in this lesson are helpful for creating documents that require special layouts such as financial reports, advertising flyers, or newsletters.
In order to add some flare to your flyer or newsletter, I suggest you continue with Word 365 104: Document Formatting and Graphics.
You will learn about:
This lesson will allow you to unleash your creativity!
Here are the main features you’ll be learning:
Knowing how to create or insert existing tables or charts can be a real time saver when creating your presentation. In order for you to get the most out of this lesson, it is strongly suggested you fulfill the prerequsites listed here. If I feel you are struggling with this material, it may be necessary to go through the prerequisites with you instead.
Prerequisites:
In this lesson I’ll teach you how to:
Then we get into Excel charts:
Lastly, we get in to more details of PPT Tables vs. Excel Tables
This may seem like one of the more complex areas of PowerPoint, but after learning how it all works, you’ll be solving a TON of mysteries!
You’ll learn:
PowerPoint is one of the easiest Microsoft Office Applications. This lesson will get you through all the basics well enough to where you can create an effective PowerPoint Presentation when done.
We’ll begin by getting you familiar with the screen:
Then we get into creating your presentation:
Then the really fun stuff:
Once you’re comfortable with the basics of how formulas are put together, these will actually be a piece of cake for you to master!
BTW – If you’re not that comfortable with the three types of formulas, I strongly suggest you review the Excel 101 Course: Formatting and Formulas.
We’ll begin with some settings and tips that will help you to really “see” and troubleshoot formulas:
From there we’ll explore some of the more usefull funtion formulas:
We’ll wrap up this lession with one of the more interesting (some say confusing) concepts when it comes to formulas:
Abosulute vs. Relative
At the very end there’s an appendix with some of the more common function type formulas. Once you feel comfortable with the previous funtions, you’ll find that having these in your hip pocket will be very handy.
Excel is what is known as a “flat file” database. That means that you can sort and extract data out of a single spreadsheet (vs. multiple spreadsheets), all based on criteria that you specify.
BTW – If you’re not that comfortable with the three basic types of formulas, I strongly suggest you review the Excel 101 Course: Formatting and Formulas.
We’ll begin by getting you familiar with some standard database terminology.
Then we’ll introduce you to some easy database functions with which you might already be familiar:
From there you’ll learn about some that may not be so familiar:
Pivot Tables are next:
And we’ll wrap up this lesson with a couple more interesting Excel features:
The true power of Excel is really magnified when you start working with Multiple Sheets within a single spreadsheet file.
BTW – If you’re not that comfortable with the three types of formulas, I strongly suggest you review the Excel 101 Course: Formatting and Formulas.
We’ll begin with the basics of finding the sheet tabs and then talk about:
From there we’ll have you start working with the grouping feature:
Then onto the really cool way you can…
Lastly, we’ll bring it all together with the very useful lookup function. That begins with:
Charting in any application might be one of the most challenging tasks.
In this lesson you’ll learn the one simple tip that takes all that confusion away. The light bulb will go off immediately and you’ll be volunteering to put everything in a chart.
Here’s a run down on what’s gonna get you started on your way to becoming a charting expert:
As I upload more MS Excel lessons (There will be 6 all together), you’ll learn about all the other really cool things you can do in this application, thus, making this one of the most powerful applications you can ever learn. Don’t get discouraged by having just one or two lessons under your belt at this point: Just knowing the stuff in these two lessons alone will put you miles ahead of any applicant that’s never dared to even try to learn Excel. And that will look very impressive on your resume!
The goal is to make you a lot more comfortable when you walk into a computer store and they start talking in a whole ‘nother language. After you go through this course, you’ll be a lot more familiar with these topics.
Technical computer terms such as:
Plus, you’ll learn helpful information about,
When you’re new to computers, it can be very confusing when it comes to trying to figure out what the mouse is doing when you cick in different parts of the screen. This course will help you to understand that, as well as what those different parts of the screen actually do. We’d like you to know that there’s not much you can do to break your computer short of beating it with a hammer out of frustration.
Here are some of the things you’ll be amazed at learning about:
After you get your mouse under control, then there’s the screen:
And then we get you into the really cool stuff: Working with Multiple Windows:
There’s nothing more frustrating then spending hours on a document only to not be able to find it after you close it. UGH!
This is the best course you’ll ever take when it comes to learning how files are store on your computer and having some control over it.
Even though these things may sound boring at first, you’re going to be thrilled when the light bulb goes off in your head:
You’ll then be getting into how to use all this stuff when you’re working in MS Word or any other application. They all share the same file folder, aka, File Explorer tool.
Here’s what else will prove to be invaluable:
Whether you’re brand new to Word, or you’ve been at it for a while, you’ll be joining many others who are surprised at how much this application can do. And bonus, how easy it all is once you’re aware of it.
Just to get you comfortable before getting into some real work, you’ll learn about,
And, hopefully you went through the PC Basics 103 Lesson that talked you through how to use the File Explorer tool, becasue this is where you’ll really be seeing it’s value. A lot of people are tempted to skip this part of the lesson, but once you get through it, trust me, you’ll be soooo grateful to know it. It’s one of those things that you need when you least expect it.
You learn,
Once you’re through the housekeeping, you’ll get into the nitty gritty of,
I’ll bet you thought you learned everything in the Word 365 101: Getting Started class, right? Well, that wasn’t even the tip of the iceberg! I hope that if you were tempted to skip that course because you’ve been using Word for awhile, that you decide to go back and, at the very least, review the supporting document. Everything you learn here, is going to take off from what you learn there.
This course kicks off with Templates:
Then you’ll learn about one of the coolest things that can go into a template: Styles
Fom there, you’ll get into the basics of working with Macros and why you might want to. (Yes, it’s a weird word, but a powerful feature of all Office Applications.)
As I upload more MS Word lessons (There will be 8 all together) , you’ll learn about all the other tools that can go into Templates, thus, making this one application that can carry a lot of weight on your resume.
I’ll bet you’re like a lot of other people who stay away from Excel because you believe you have to be really good at math to understand it. Yeah, I get it, I used to think that too. But guess what? That’s not true. Excel is set up so we all get to start at the same level no matter how far you went up in math classes in high school. From basic adding & subtracting to Calculus, everyone has to start at the same place in this application. Is that a relief or what?
So you all have to start with the basics of learning what’s going on with this screen: You know, things like,
Then we get into formulas.
Once you’re comfortable knowing the secret of how these are created in Excel, you’ll be on your way to making the application sing and dance. You’ll learn,
After getting all excited that formulas are much easier than you might’ve thought, we’ll then have you cool down with some fun formatting techniques.
Lastly, you’ll need to learn how to print out the final product, so we’ll definitely go over that.
As I upload more MS Excel lessons (There will be 6 all together), you’ll learn about all the other really cool things you can do in this application, thus, making this one of the most powerful applications you can ever learn. Don’t get discouraged by having just one lesson under your belt at this point: Just knowing the stuff in this lesson alone will put you miles ahead of any applicant that’s never dared to even try to learn Excel. And that will look very impressive on your resume!
Maintaining a team dynamic has become more challenging over the last few years since more and more of you have begun working from your homes. That’s why it’s so important that you know how to use one of the most popular, easy to use, and easy to learn, remote communication tools in the world: Zoom
Being able to list this highly desired skill on your resume puts you way ahead of your competition.
You will learn…
