h264, yuv420p, 1280×720 |ENGLISH, 44100 Hz, 2channels | 8h 24mn | 7.08 GB
It seems every organization, large and small, uses Microsoft Excel to organize and analyze data, and many individuals find it useful for organizing household budgets and other personal information.
Yet many users can find themselves intimidated by Excel-after all, it is an amazingly detailed and flexible application, full of options that can be difficult to navigate or apply correctly if you don’t understand the many functions and menus available to you.
Whether you need to layout a budget, track the progress of an important project, or simply sort information for easy access, Excel has the potential to help you work with data in ways that can make your job easier and your life more organized. Excel is a program with a lot of features and applications, yet it is not always very intuitive for those who are just starting out.
That’s where Microsoft Excel Essentials comes in. The 19 lessons of this course strive to empower users by providing the necessary foundation for working in Excel with ease. Brought to you in partnership with ITProTV and taught by Microsoft Office guru Vonne Smith and her co-hosts Justin Dennison and Daniel Lowrie, these lessons will help you conquer this essential program by introducing you to its interface; guiding you through its many menus and options; identifying crucial elements; and teaching you how to input data, modify worksheets, arrange layouts; and much more. And while this series is designed for bners, it has lots of great tips and tricks for experienced users as well. These lessons use the 2016 edition of Excel and, as we all know, computer software is constantly chag. But rest assured: Everything that you learn in these lessons can be easily adapted to updated editions of the program, as well as to other versions of the program designed for different computer operating systems.
B with the Basics: Navigation and Settings
One of the first hurdles you will need to clear when working in Excel is getting a grasp of the basic functions and knowing how to locate essential tools. Your hosts b with walkthrough demonstrations of the foundational skills that will get you started working in Excel, including simple navigation, starting a workbook, opening and saving files, and how to use basic keyboard shortcuts to simplify your tasks. As you learn about the program’s user interface (UI), Vonne and Justin will help you become more confident in your Excel skills so you can focus on what you need the program to do, rather than spending countless hours combing through menus to find the necessary tools.
Once you are comfortable with navigating the program itself, Vonne and Daniel show you how to work within the basic layout of Excel: the workbook. Excel workbooks are the basic building blocks of the program and understanding how they work is crucial to your success, yet many users can overlook simple aspects of workbooks-such as your settings, what view you are using, or your page layout-that can trip you up later. Workbooks are extremely flexible and can grow unwieldy if you don’t know what you’re looking for, so a strong understanding of something as simple as how to view and move through the file is more crucial than many users realize.
Another deceptively complex element is selecting the areas in your spreadsheet that you want to work with. While it seems like it should be as easy as point-and-click, there are many factors involved and understanding all your options gives you much-needed flexibility to select, move, and otherwise alter your data in a variety of ways, including working with full columns and rows versus single cells and everything in between. With your hosts’ guidance, you will be able to adjust every element to fit your needs and modify them on the fly.
Visualize Your Data
Using Excel is not just a matter of knowing how to create your own tables and worksheets. It’s also about understanding how to interact with and modify data, including how to make it more visually appealing and accessible. As you dig deeper into the basic functions of the program, you will learn how to:
Add borders and shading;
Merge cells and fit text with wrapping;
Move, adjust, and even hide rows/columns;
Copy and paste special formatting;
Style cells and align data; and more.
These and other aesthetic elements may seem superficial, but one of the benefits of Excel is the way it can allow you to visually organize and present important information. As you learn more about how to both input and present your data, Excel bs to feel less like a dry, technical, number-crunching program and more like the flexible, adaptable tool that it is.
Excel at Excel
Excel can be used for organizing just about any kind of information you could need, but how you work with this data relies on how well you understand the formatting used by Excel. Some of the key elements of formatting and layout you will explore include:
Chag cell types to optimize the way your data is presented;
The important difference between “clear” and “delete” commands;
Creating custom solutions when the available options aren’t quite right;
How to work with fractions, percentages, and scientific notation;
Using styles and themes for visual impact and clean presentation; and
Personalizing your workbooks with Format Painter, smart tags, and more.
At some point, you may need to print or otherwise export your data. Since Excel is not formatted like traditional word processing or text-based programs, it is important to know how to adjust layouts and fit your worksheets to the right size and shape for your needs. In the last few lessons, you will learn the essential elements of the Print Preview stage, while also getting an invaluable tour of all the tools at your disposal for proofing and correcting your information before sharing or printing it. Finally, you will close the series by looking at the ins and outs of workbook management, from reorganizing tabs and freezing panes to using different views and working in other windows.
The lessons presented by Vonne and her co-hosts are not an exhaustive introduction to all of Excel’s functions and utilities. Rather, they provide the foundation of a solid understanding of the program which you can build on to suit your own needs and those of your workplace, whether that workplace is a Fortune 500 company or your own home office. Every new user has to b somewhere, and these lessons provide insight into the key elements that you need to move around easily in the program and apply the basic techniques for optimal organization and access. And even if you have experience with Excel, you will learn how to be more effective and efficient with features and shortcuts you may not have previously known about. With help from the ITProTV team, you will learn the basics of how to make this versatile tool work for you.