Discover what is new in Excel 2013:
Here is a brief overview of what you will learn in CustomGuide’s Excel 2013 Courseware.
Excel 2013 is a product used by individuals and business professionals around the world, ranging from biologists to accounting professionals and students. Excel 2013 Training has something for everyone! In Excel 2013 you will learn how to create workbooks, navigate multiple windows, using help, and about new features in Excel 2013.
Editing a Workbook
Ready to roll your sleeves up and start building a spreadsheet? In this course you will learn how to enter and edit cell data, fix typos, remove data you no longer need, hide rows and columns, and why using AutoFill is your new best friend!
I bet you’re wondering how to make this boring pile of data into a visually appealing pile of data that is easy to understand. Well, not to worry because in this Excel 2013 training you will learn how to format text, cell alignment, create borders and backgrounds, Excel 2013 Training apply cell styles, insert images, and other special effects. Who said data had to be boring with Excel 2013?
Now that you understand spreadsheets, it’s time to dig a little deeper and turn your data into meaningful and informative information. In this course you will learn how to build IF Formulas, Financial Formulas, VLOOKUP, and Text Formulas. Learn how to interpret formula errors, reference external worksheets, and work with range names, sums, and averages.
Viewing and Managing Worksheets
It is no surprise that most of your time will be spent managing your worksheets, which is why it is important that you understand how to navigate them properly. In this course you will learn how to view, move, rename worksheets, freeze rows and columns, and how to hide worksheets and gridlines.
Excel 2013 offers a variety of charts and options that will save you time while keeping your data organized and easier to understand. In this course you will learn how to create a chart, change layout styles, format chart elements, create sparklines, and how to work with titles and legends.
To print and distribute your worksheets you will need to configure a few settings to make sure your worksheets don’t print out the wrong way. In this course you will learn about changing page size and scale, setting the print area, viewing page breaks, adding titles and headlines, creating headers and footers, and adjusting page margins and orientation.
Working with Data and Tables
If working with charts is not your cup of tea and you’re looking for a simple way to build and analyze data, then using data tables is the perfect solution! In this course you will learn how to sort and filter data, use quick analysis, work with data tables, remove duplicates and total, filter with slicers, and the power of data validation.
Collaborating with Excel
If your workbook requires collaborating with other people then you’re in luck! With Excel 2013 you have a variety of collaboration tools, making it easier than ever to work with others. In this course you will learn about working with cell comments, sharing workbooks, tracking changes, password protecting a worksheet, and saving worksheets for web page viewing.
Working with PivotTables
PivotTables are not just for geeks, they’re for anyone who has a large amount of data that needs consolidation. It’s a useful and powerful data analysis tool that will summarize, analyze, and present you data. In this course you will learn how to create PivotTables and PivotCharts, change calculations, group PivotTable Values, and how to work with timelines.