课程详情

This course is designed specifically for business professionals to save time and become more efficient in Excel.Excel has lots of features, but not all of them are useful to business professionals. That's why we created this course for you-the busy business professional. You'll learn the features in Excel that are most important for business professionals.Learn to create an HR dashboard, build easy to understand charts in seconds, master the use of the functions that you'll use most often and lots more.Spend Less Time in ExcelRight now, you are spending more time working on your Excel files than you need to. Spend a few minutes watching a video lesson from this workshop and you learn lots of features that will make life easier for you with Excel. After completing this course, you will find yourself working much more efficiently in Excel and saving lots of time spent working on spreadsheets.Easy To Follow Videos!Most video tutorials are created by people that go too fast for students to follow them easily. That is why our "Total Training" videos use our exclusive "Big Red Arrow" that points exactly to the button or menu item that is being referred to.What The Workshop IncludesWe know your time is valuable, so we've broken the workshop into short videos that you can learn from at your own pace. Watch one during your lunch hour and you'll be amazed how much you'll learn!Excel Topics Covered:Workshop Materials Include:16 topics with over 4 hours of video content. And more videos being added all the time!Each video has a corresponding Excel file you can use to follow along with the video.Excel "Cheat Sheets" you can print out and use for reminders as you work in Excel.Essential Excel Shortcuts (12:14) You may have been using Excel for quite awhile already, but take a look at this lesson and learn some time saving shortcuts and other things that you should know as an Excel user.Formatting Cells (17:11) Formatting cells makes the spreadsheet easier to read and use. In this lesson, you will learn different techniques you can use to format your spreadsheet to make it easier for you (and others) to read.How to Build Formulas (19:11) Many Excel users have "fear of formulas". In this lesson, you will learn how to create your own formulas (and really understand them, we promise) which will do all sorts of math problems for you.Really Useful Functions for HR Professionals (33:35) There are over 400 different functions in Excel, but lots of them aren't useful to Human Resource professionals. In this lesson, you will learn the functions most useful in HR and how to use them in your job.Using the VLookup Function (16:27) An incredibly useful function for HR professionals is the infamous "VLookup" function. In this lesson you will learn how others use the VLookup function and how to use it in your own spreadsheets.3D Cell References and Linking Cells (11:01) Many times you will want to pull in numbers or text that are already in a cell in your spreadsheet. In this lesson, you will learn how to create 3D cell references and linked cell references to bring in data in different sheets (or even a different Excel file!) and use them in your formula.Freeze Panes (5:59) If you have long spreadsheets with rows and rows of data, you are spending lots of time scrolling up and down through the sheet. In this lesson, you will learn how to use the "freeze panes" feature in Excel so that you can see your header row even when you scroll down to the bottom of your sheets.Unlock Cells and Protect Sheets (5:59) Want to share your workbook with others but not let them change certain info in cells such as social security numbers, personal info, etc. This lesson shows you how to lock certain cells so that the contents can't be changed by accident.Charts (18:07) Many people prefer looking at a visual representation of the data in a spreadsheet. Excel charts let you illustrate your workbook data graphically to see trends. In this lesson, you will learn how to turn data in your spreadsheet into visual charts.How to Create an HR Dashboard (38:08) The newest trend for Excel users is to create an Excel Dashboard. The Dashboard is a sheet with easy to comprehend visual summaries of your data. In this lesson, you will learn how to create your own Human Resources Dashboard for your company.Tables (13:06) If you have a list of company employees in your spreadsheet, you should try converting that list into an Excel table. Tables have many features, such as sorting and filtering, that will help you organize and view your data. In this lesson, we will show you how to convert your range of data into a table and the many advantages of using a table.Pivot Tables (17:03) Pivot tables are one of Excel's most powerful features. Pivot tables, are a great way to summarize, analyze, explore, and present your data. This lesson will teach you how to create your own Pivot Tables with examples of how you can use them in your job.Sorting and Filtering (7:37) There are many times when you want to sort your data by employee last names or "date of hire", etc. Or maybe you just want to see the employees from a particular department? This is where sorting and filtering come into play. This lesson will show you how to sort and filter your data and also show you how to create subtotals easily.Data Validation (Want a Dropdown List?) (15:44) In Human Resource spreadsheets, there are many instances where you are typing specific data into the cells such as "yes" or "no" or "pass" or "fail". Maybe you'd like to create a dropdown list of your company's departments to choose from. In this lesson, you will learn how to use data validation to constrain what you (or others) can type into certain cells.Printing Your Sheets (15:28) The one thing you'd think would be easy to do in Excel can be frustrating (and a waste of lots of paper). In this lesson, you will learn why you can't just hit the print button in Excel, how to set the printable area of the sheets and lots of other helpful info about printing in Excel.Conditional Formatting (11:30) Do you need to keep your eye on the numbers in certain cells going over a set amount? For example, maybe you have a column of numbers which has your employee hours worked for the week. Now you have to look through that column and find all the hours worked that are over 40 (because you have to pay overtime on these). With Conditional Formatting, you can have all the numbers in that column that are over 40 displayed in a different color! This lesson will teach you how to use conditional formatting to make it easier to identify things in your spreadsheets.Workshop Materials Include:16 topics with over 4 hours of video content. And more videos being added all the time!Each video has a corresponding Excel file you can use to follow along with the video.Excel "Cheat Sheets" you can print out and use for reminders as you work in Excel.

课程标签

0人关注该课程

主题相关的课程