Learn Microsoft Excel 2013
- 3.5 hours on-demand video
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to 4,000+ top Udemy courses anytime, anywhere.Try Udemy for Business
- After completing this course you'll have the ability to prove your mastery of Microsoft’s standard spreadsheet application. With the skills learned in these easy to follow videos, any user will be fully competent and capable of working in a variety of business settings.
- Microsoft Excel 2013
In this Microsoft Excel 2013 course, ClipTraining provides a comprehensive instruction starting with the basics and on through the advanced features.
With over 100 Video Tutorials and more then 4 hours of training; ClipTraining helps both the beginner and advanced user visualize what they are learning with step-by-step instruction from a Microsoft Excel Professional.
Watch as the instructor performs progressive operations in each video starting with the Basics of Worksheets. Then moving onto Formatting, Formulas, Illustrations and Charts, Printing, and finishing off with 20 part sections on Advanced Excel Features.
Along with the task-based, to-the-point videos, you'll receive an excellent downloadable 'ClipStart' PDF with helpful tips to get you started.
Take this course to learn all about Excel 2013 and be on your way to becoming a Microsoft Office pro.
- Anyone interested in learning Excel 2013 from beginners to advanced users. This course will help you learn the basics or refresh your knowledge and then provide a deeper understanding of advanced features. These videos are ideal for visual learners.
Let's get started with Microsoft Excel 2013! In this clip, we will take a look around the Excel window, label the parts, and see how to better navigate the new interface.
In this clip we will take a close up look at the main tabs and groups on the ribbon. Group names on the ribbon will cluster similar commands in groups so you can save time looking for a command. See how screen tips can help you learn about a particular ribbon command.
In this clip we'll take a closer look at the Home Tab & the different groups such as Fonts, Editing, and more that we will be able to have quick and easy access to.
No more bland worksheets with default fonts and colors after this clip! Get the facts on how to quickly customize the look of your worksheet using different fonts. You never knew you could be so creative in Excel! See how to use bold, underline, and italics along with alot of other Font options to choose from in this quick clip.
Explore how to precisely position your text; whether in a cell or a group of cells. One example provided in this lesson is how to use the Merge and Center command. This joins the selected cells into one larger cell and then centers the contents. This feature is practical when you need to use labels that span multiple columns.
Ever wonder how to make your text appear on an angle in your worksheet? Or how about to change it back if it is angled? Wonder no more after watching this brief tutorial clip! By using the Dialog Launcher in the Alignment Group we can see how to align and orient our text.
Want to Open an existing workbook? See how easily accessible our recent files are. You also have the ability to use Skydrive to be able to access your files. Need to make sure you don't lose any of your files? Why not pin them so they can stay for as long as you need them, a great feature of Microsoft Excel 2013!
This is an area to use caution! The Options category changes how Excel looks and works -- but be careful! There is no reset button here, so you need to know what you did if you made some changes in this section. Let's take a quick look at some of the options that you have.
This lesson shows off the Status Bar. From here you can also add features to display, such as the minimum and maximum values in cells. You will also learn how to see the sum of data through the Status Bar. Understand how to better utilize this helpful tool by watching this mini lesson.
Templates can be a real time saver in setting up your worksheets. The following templates are automatically installed when you start using Excel 2013: Billing Statement, Blood Pressure Tracker, Expense Report, Loan Amortization, Personal Monthly Budget, Sales Report, and Time Card -- just to name a few!!
Learn how to get around worksheets with keyboard commands like Enter, Tab, Arrow Keys, Page Up /Down, Home Key and more! You'll also be introduced to a couple of commands on the Home Tab in the Editing group on the Find and Select drop down menu. Discover how Excel pinpoints various aspects of your worksheet for you in this clip, for example cells that contain formulas.
Forget about typing January, February, March, etc. Learn how AutoFill can create this series and others like the days of the week, number sequences and dates. Also see how AutoFill can look at a sequential range of numbers and continue building the sequence for you. This is one clip you won’t want to miss!
By now we are all used to search engines automatically suggesting keywords as we type. Not one to be left behind, Microsoft Excel features this same capability. Watch this clip to see how to use this feature and also take a trip into advanced options to make sure your system is properly utilizing this feature.
What is Conditional Formatting? Conditional Formatting allows you to change the appearance of a cell, depending on certain conditions. Formatting your spreadsheet in this way allows you to see at a glance relevant information quickly through adding colorful graphics into the cells. This will be demonstrated through a data bar. Check it out!
Learn how to quickly benefit from pre-configured rules that will show you the details such as the Top/Bottom 10%, and Items or Average in a series of data. This lesson shows you how to apply these and then locate these values in your cell range. An invaluable tool, learn how to use it quickly by watching this clip.
Why just use one set of rules? Learn how to benefit from a graphical representation of your selected rules; includes configuring cell data with multiple rules. Are you making a mess out of it? No problem, you’ll also see how to clean things up with the 'Clear Rules From Selected Cells' command.
What is a Formula? In just a few minutes you’ll learn exactly what they are and when to use them. We'll also discuss operators and we'll see how to enter and edit those formulas. Here’s a hint: Formulas that involve adding, subtracting, multiplying and dividing usually start with an = sign. Watch and learn the rest of the formula in this clip.
Learn how to hide records you are not interested in seeing and only showing records you want to see. The distinction between Filtering and Sorting is that sorting rearranges your data whereas filtering gives you an opportunity to hide (not delete) what you don't want to see. This lesson will show you how to do it.
SmartArt graphics add color, shape, and emphasis to your text and data. It's easy to try out SmartArt graphics such as an organization chart, a time line or cycle. You can preview styles before choosing one, so you don't have to apply styles over and over again to find the one you want. And after you apply a style you can customize it with colors, animation, effects such as shadows, bevels, and glows, and more. This lesson demonstrates how to create and modify an organizational chart through SmartArt.