Description
Explore the essentials of Microsoft Excel 2013 for finance and accounting professionals with this comprehenisve selection of courses including creating workbooks, worksheets and data, manipulating data, formatting cells and worksheets, presenting data and more. This 10 pack of courses is designed to power up your skills in Microsoft Excel 2013.
Pack inclusions:
- Customising options and views in Excel 2013
- Creating workbooks, worksheets and data in Excel 2013
- Saving and printing data in Excel 2013
- Reviewing and protecting content in Excel 2013
- Creating and customising visual elements in Excel 2013
- Manipulating data in Excel 2013
- Formatting cells and worksheets in Excel 2013
- Formatting data in Excel 2013
- Presenting data in tables and charts in Excel 2013
- Performing calculations using functions in Excel 2013
These courses form part of the SkillsNet short course suite. Buy this SkillsNet value pack and save!
You will have 365 days to access to this course.
Audience
Anyone looking to expand their skills using Microsoft Excel 2013.
Choose an offering for each one of the bundle components then click on 'Add To Cart' button below:
Customizing Options and Views in Excel 2013 (Update Avail.)
Description
Excel 2013 allows you to customize options and views to create a personalized environment. You can change how data displays by hiding and unhiding rows and columns; enable Show options; and also change the zoom level. You can switch workbook views from Normal to Page Layout, to Page Break Preview, or create custom views. This course will also cover the ways to arrange windows including Arrange All, Freeze Panes, Split, and View Side by Side. It will also show you how to change the defaults for creating new workbooks and personalize the Ribbon and Quick Access Toolbar. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.Learning objectives
- Hide and show worksheet data and elements in Excel 2013
- Change how worksheet data displays in Excel 2013
- Create a custom worksheet view
- Create appropriate worksheet views in Excel 2013
- Change how worksheet windows display in Excel 2013
- Arrange worksheet windows in Excel 2013
- Change default options for new workbooks in Excel 2013
- Personalise the ribbon and quick access toolbar in Excel 2013
- Customise your default options in Excel 2013
Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification
Offerings
There are no Offerings available for this course.
Formatting Cells and Worksheets in Excel 2013 (Update Avail.)
Description
Excel 2013 provides a number of tools and features that allow you to visually enhance the appearance of worksheets and workbooks. Data and cells can be manipulated and customized using various positioning and formatting features. This course explores formatting cells and text, using tools such as the Format Painter. It shows how to change the way text is presented to make it more visually appealing, including formatting fonts, and applying borders and fills. This course also covers aligning and orienting data, and merging and splitting cells. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.Learning objectives
- Change font formatting in Excel 2013
- Apply borders and fills and create a cell style
- Copy formatting with Format Painter in Excel 2013
- Choose how to format data in Excel 2013
- Change the alignment, indentation, and orientation of data in Excel 2013
- Merge cells and wrap text in Excel 2013
- Decide how to align data in Excel 2013
Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification
Offerings
There are no Offerings available for this course.
Formatting Data in Excel 2013 (Update Avail.)
Description
Excel 2013 provides a number of tools and features that allow you to visually enhance the appearance of data, automatically fill data, and create hyperlinks to various places. This course covers formatting numbers in currency, date, and percentage formats. It also covers ways of automatically filling data through Auto Fill and Flash Fill. Finally, this course covers creating hyperlinks to a web site, another place in the workbook, a new document, and e-mail. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.Learning objectives
- Format numbers in Excel 2013
- Decide how to format numbers in Excel 2013.
- Use Auto Fill to copy and fill a series in Excel 2013
- Extract or add data using Flash Fill in Excel 2013
- Choose how to automatically populate cells in Excel 2013
- Create and modify a hyperlink in an Excel 2013 workbook
- Decide how to add hyperlinks to a worksheet in Excel 2013
Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification
Offerings
There are no Offerings available for this course.
Manipulating Data in Excel 2013 (Update Avail.)
Description
Excel 2013 provides multiple features for organizing and managing data, including sorting and filtering tools that are essential to data analysis. Using data organization features, you can sort, filter, and group and outline data so that you can focus on its key parts. Properly arranged data using the commands in the Data tab allows you to present your data in a logical and easy to understand manner. This course explores organizing data in Excel 2013 using the built-in features. It also covers converting text to columns for easy of splitting text. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.Learning objectives
- Sort data in Excel 2013
- Group data in Excel 2013
- Decide how to sort and group data in Excel 2013
- Filter data in Excel 2013
- Choose how to filter data in Excel 2013
- Convert text to columns in Excel 2013
- Decide how to convert text to columns in Excel 2013
Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification
Offerings
There are no Offerings available for this course.
Performing Calculations Using Functions in Excel 2013 (Update Avail.)
Description
Excel 2013 provides you with the tools that allow you to perform calculations on your workbook data. Being able to use formulas to do complicated calculations not only simplifies your work but also helps to reduce the number of errors that can arise in such complex tasks. This course introduces the basic concepts and terminology associated with formulas and functions. It also covers various ways of referring to cells and cell ranges and demonstrates how to use basic functions including logical and IF-type functions. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.Learning objectives
- Create a basic formula in Excel 2013
- Reference cells in formulas in Excel 2013
- Create a named range in Excel 2013
- Reference cells and create a named range in Excel 2013
- Use basic functions in Excel 2013
- Decide the best way to use basic formulas and functions in Excel 2013
- Create formulas using basic logical functions in Excel 2013
- Create an IF-type formula in Excel 2013
- Decide how to create IF-type functions and nested formulas in Excel 2013
Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification
Offerings
There are no Offerings available for this course.
Presenting Data in Tables and Charts in Excel 2013 (Update Avail.)
Description
Using the tables and charts features in Excel 2013, you can create attractive and well-organized representations of worksheet and workbook data. Both tables and charts can be easily inserted and customized. This course demonstrates how to effectively use and customize tables and charts in Excel 2013; it explores available table styles and chart types and the best use of each type. And the course shows how to change the different elements of a table or chart to provide an effective visualization of your data. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.Learning objectives
- Create a table in Excel 2013
- Format a table and customise a table style in Excel 2013
- Decide how to create a table in Excel 2013
- Create a chart in Excel 2013
- Add elements to a chart in Excel 2013
- Change the appearance of a chart in Excel 2013
- Decide how to create a chart in Excel 2013
Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification
Offerings
There are no Offerings available for this course.
Creating Workbooks, Worksheets, and Data in Excel 2013 (Update Avail.)
Description
Excel 2013 allows you to create worksheets and workbooks to manage and manipulate data easily. You can cut, copy, and paste data. You can also navigate within data cells, and worksheets. Not only can you manage the data at this level, you can group, color-code, and organize the worksheets within the workbook. This course will cover creating and opening workbooks, moving around in Excel 2013, moving data, and organizing worksheets. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.Learning objectives
- Create a new workbook and open a workbook in Excel 2013
- Decide how to create a new workbook in Excel 2013
- Move around Excel and enter data
- Cut, copy, and paste in Excel 2013
- Edit data in Excel 2013
- Delete or hide a worksheet
- Organise and modify worksheets in Excel 2013
- Choose the best way to organise and modify worksheets in Excel 2013
Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification
Offerings
There are no Offerings available for this course.
Saving and Printing Data in Excel 2013 (Update Avail.)
Description
Excel 2013 makes it easy to save and print workbooks and worksheets. When you create an Excel workbook, you will most likely want to save it, and in many instances, print it as a hard copy or share with someone else. You can save in various formats since Excel 2013 supports many file types. This course covers saving data, and preparing for printing including setting print options, page setup, print titles, headers and footers, and row and column headings. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013Learning objectives
- Save a workbook in Excel 2013
- Change the default save options in Excel 2013
- Recover a workbook in Excel 2013
- Choose how to save a file and recover an unsaved file
- Print a workbook
- Configure the page layout in Excel 2013
- Decide how to print a workbook in Excel 2013
Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification
Offerings
There are no Offerings available for this course.
Reviewing and Protecting Content in Excel 2013 (Update Avail.)
Description
Excel 2013 provides tools that allow you to manage multiple workbooks as well review and protect them while creating and sharing content. You can consolidate data, control recalculation, merge and manage versions of a workbook. Excel also provides the track changes feature allowing you to track, accept, or reject changes. When reviewing comments, you can edit, add, or delete comments. In addition, the spell checker reviews the spelling and allows you to change, ignore, or add to the dictionary. Finally, Excel allows you to protect a range, worksheet, or workbook with a password. This course will help prepare learners for the Microsoft Certification Exam 77-427: Excel 2013 Expert Part One, and Exam 77-428: Excel 2013 Expert Part Two, which certifies individuals as Microsoft Office Specialist (MOS): Excel Expert 2013.Learning objectives
- Consolidate data and merge workbooks in Excel 2013
- Decide how to consolidate data in Excel 2013
- Choose how to merge workbooks in Excel 2013
- Use Track Changes in Excel 2013
- Add and edit comments in Excel 2013
- Spell check a workbook in Excel 2013
- Decide how to use comments and track changes in Excel 2013
- Protect sheets and workbooks in Excel 2013
- Choose how to protect workbooks in Excel 2013
Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Expert level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification
Offerings
There are no Offerings available for this course.
Creating and Customizing Visual Elements in Excel 2013 (Update Avail.)
Description
Excel has more than just charts to offer in the way of visual presentation. Graphic tools such as pictures, shapes, SmartArt, WordArt, and screenshots are all ways to enhance the visual impact of documents that tend to be dominated by numbers and text. The course shows how to insert and edit shapes, text boxes, and pictures. We'll see how to add a SmartArt graphic and we'll demonstrate how to add watermarks to your spreadsheets. We'll also look at how you can use workbook themes to enhance the presentation of your data. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.Learning objectives
- Add text boxes and shapes in Excel 2013
- Add a text box and shape in Excel 2013
- Insert a picture in Excel 2013
- Insert a SmartArt Graphic in Excel 2013
- Add and edit pictures and SmartArt in Excel 2013
- Apply a watermark in Excel 2013
- Change the workbook theme in Excel 2013
- Add a watermark and create a theme in Excel 2013
Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification
Offerings
There are no Offerings available for this course.