Excel 2013 For Dummies Video Training, Deluxe Edition
- 5 hours on-demand video
- 12 downloadable resources
- 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
- Discover how to:
- Launch Excel and navigate worksheets
- Enter data and use AutoFill
- Print formulas in a worksheet
- Create pivot tables and pivot charts
- Sort and filter data lists
- Share workbooks via SkyDrive
- All Internet browsers, including Internet Explorer, Safari, Chrome, and Firefox
Master Excel essentials with these step-by-step video tutorials, Excel All-in-One For Dummies e-book, Office 2013 cheat sheets, an interactive quiz, an instructional PowerPoint, and more!
This Excel 2013 video training course includes everything you need to go step by step through all the essential tasks involved in using Excel 2013. With over 90 Excel video lessons, you’ll get in-depth video training that provides the show-and-tell, covering the basics of launching and navigating the program, creating and editing spreadsheets, and printing your worksheets. Then you’ll learn how to get organized, analyze your data, create charts and data lists, and share your spreadsheets. You also have access to a customized 800-page e-book along with an array of Office 2013 and Windows 8 cheat sheets to help you learn the quick basics and get you moving along quickly. You will be able to test your knowledge by taking the For Dummies quiz and use the included PowerPoint that includes key instructional information for Excel 2013. In no time, you’ll be an Excel pro!
- Beginner and Intermediate Social Media Marketers
Ready to embark on your journey through Excel? Get started by learning how to launch Excel 2013 on Windows 7 and Windows 8, pin it to your Start screen, and create a shortcut. Then find out how to call it a day by quitting Excel.
Get your backstage pass to gain insight into the workbook file you have open and active. Learn how to modify the workbook’s protection status, manage its versions, change the author, and more using the Backstage view.
Time to cut the ribbon to quickly perform Excel tasks. From selecting tabs and organizing groups to clicking command buttons and launching the Dialog Box, you’ll begin to zip through the Ribbon as you work on your files.
Why not have it your way? Set up the Quick Access toolbar by adding the commands that you want to use. You’ll also be able to move buttons around to customize everything to meet your needs.
The AutoSum tool is worth its weight in gold. Whether it’s SUM, AVERAGE, COUNT, MAX, or MIN, you’ll learn how to use this tool. Then you’ll explore the Quick Analysis tool to make your spreadsheets sparkle with conditional formatting, charts, pivot tables, and more.
What’s in the mini-bar? You’ll explore the mini-bar and how to use the buttons from the Font group of the Home tab. You’ll also utilize the Center and Merge & Center buttons and the Accounting Number Format, Percent Style, Comma Style, Increase Decimal, and Decrease Decimal buttons from the Number group.
Zooming in and out on the worksheet can help you get your bearings, but it can’t bring together two separate sections so that you can compare their data on the screen. To manage this, find out how to split the Worksheet area into separate panes and then scroll the worksheet in each pane so that they display the parts you want to compare.
Data tables let you enter a series of possible values that Excel then plugs into a single formula. We’ll help you create two types of data tables: a one-variable data table that substitutes a series of possible values for a single input value in a formula and a two-variable data table that substitutes series of possible values for two input values in a single formula.
Sometimes when doing what-if analysis, you have a particular outcome in mind, like a target sales amount or growth percentage. When you need to do this type of analysis, we’ll show you how to use Excel’s Goal Seek feature to find the input values to get the desired goal.
If you save your workbook files in the cloud on your Windows Live SkyDrive, we’ll help you easily share them and have other users open them in Excel on their own devices. You’ll also see how they can use their web browser with the Excel Web App if they don’t have Excel.
The comprehensive reference, now completely up-to-date for Excel 2013!
As the standard for spreadsheet applications, Excel is used worldwide - but it's not always user-friendly. However, in the hands of veteran bestselling author Greg Harvey, Excel gets a whole lot easier to understand! This handy all-in-one guide covers all the essentials, the new features, how to analyze data with Excel, and much more. The featured minibooks address Excel basics, worksheet design, formulas and functions, worksheet collaboration and review, charts and graphics, data management, data analysis, and Excel and VBA.
- Covers the changes in the newest version as well as familiar tasks, such as creating and editing worksheets, setting up formulas, and performing statistical functions
- Walks you through the new analysis tools that help make it easier to visualize data with the click of a mouse
- Details new ways to explore your data more intuitively and then analyze and display your results with a single click
Whether you're an Excel newbie or a veteran user to wants to get familiar with the latest version, Excel 2013 All-in-One For Dummies has everything you need to know.