You do not know Excel if you do not master these topics.
If you think you can master Excel, this course is for you. After 25+ years of experience working with spreadsheets, we know what Excel worksheets lack or are often missing. We have compiled the ultimate course, with all the features and functions you need to become a master of Excel.
You do not have to go through all 18 hours of training in our Beginner, Intermediate and Advanced Excel courses. We have captured the essence for you in this course.
Specify how a selected cell range should be filled with data!
Helps you quickly and accurately locate data in large worksheets.
Excel allows you to give a clear, concise and descriptive name to a single cell or a range of cells so the information is always readily available!
Editing and deleting cell name ranges can only be done in the NAME MANAGER! This video offers a helping hand.
Reduce errors and increase the readability of your worksheets as the amount of data increases.
Allows you to keep both the cell and the dialog box visible so that you can see the specific and general effects of any changes. This video offers a helping hand.
Allows you to work with complex formulas to see if they are working properly!
Manage how you work with formulas and allow Excel to check for errors in your formulas!
Gives you fast and easy access to your most commonly used commands and options.
Makes your workbook look beautiful and save time with cell styles!
Allows users to show important information in both graphic and workbook data versions.
Allows you to check for a mistype or misspelled word!
Helps describe the data or the worksheet for others.
Automate the process so that related data is organized and merged into one workbook.
Useful for summarizing complicated data from many ranges into a single place. This video offers assistance!
Helps keep your documents safe and your computer secure and healthy!
Helps count cells that only contain numbers in a selected range.
Helps you quickly find data based on specific criteria!
Helps improve the readability of your worksheets.
Helps make navigating through multi-page workbooks easier!
Organize your worksheets by moving sheets, insert and remove sheets, hide and unhide worksheets and refer to cells on other worksheets! This video offers a helping hand.
Change how workbook content is displayed to make managing larger workbooks easier!
Helps organize your data!
Change the order of data in a row or column to quickly find what you are looking for!
Remove from your view, any data that does not meet certain criteria!
Allows you to create complex data filters that filter data on a variety of user-defined criteria.
Indicates what type of summary calculation you're looking for!
Helps keeps your worksheets organized!
Helpful tool that filters PivotTables and PivotCharts data based on user selections.
The advantage of using Web Queries, they are updated every time the information on the website is changed, but only when your computer is connected to the internet!
SONIC Performance Support is a leading provider of e-learning and performance support solutions. We proudly serve individuals, government agencies, schools and businesses of all sizes. SONIC Performance Support provides high-quality video training, that is used by well-known domestic and foreign companies. With video based training, you have a personal coach explaining and demonstrating the task at hand. You can stop the video, perform the task in the application, and rewind if you want to review.