Categories
Disclaimer: Some of the links on this website are affiliate links, meaning we may earn a commission if you click through and make a purchase. This comes at no additional cost to you.
By clicking the button above, you acknowledge that you will be redirected to a third-party website and agree to their terms and conditions.
Log in to manage favorites.
Diploma in AP Calculus BC
Diploma in Administrative Procedures and Office Support
Diploma in Administering Protection to At-Risk Adults
Diploma in Amazon Pay-Per-Click Fundamentals
Diploma in Advanced SQL Server
Diploma in MS Excel 2013 - Intermediate
‘MS Excel 2013 Intermediate’ has been specifically prepared to teach you about advanced formulas and data analysis in spreadsheets. By default an Excel 2013 workbook is saved in the .xlsx file type however the course will teach you how to easily export your workbook from Excel into a variety of other file types. The function library is another important part of MS Excel. You will learn how to use the insert function dialogue box and you will gain an understanding of logical functions statistical functions and the syntax of average functions. Logical and lookup functions can be used extensively in MS Excel to find answers to questions. That is why the relevance of logical functions as well as the application of VLOOKUP and HLOOKUP functions will be highlighted.Did you know that after creating a table there are numerous functions to help you modify the table and organize the data in the table? This course will teach you how to do this and once you have organized the data you will learn how to present the data as a chart. Once a chart is inserted into a spreadsheet you can modify or format it. You will learn the difference between formatting and modifying a chart and how to create trend lines which can be used for forecasting once you know how to use the trend line dialogue box. Gain an understanding of pivot table tools including the Analyze and Design tabs and how to add slicers to your pivot charts. The course will also help you understand the file protection structure in Excel.Furthermore this course examines how to insert and modify graphic objects such as SmartArt which can be layered and grouped. You will learn about layers and hidden layers as well as how to change the stacking order on the same layer. Master how to handle working with a large amount of data by creating multiple worksheets to help organize your workbook and make it easier to find content. The course will also show you how to group worksheets when you want to quickly add information to multiple worksheets at the same time and how to insert comments and hyperlinks. This course is a must for anyone who wants to advance their understanding of MS Excel 2013 by learning to work with advanced formulas and various formatting options in a worksheet.
Disclaimer: Product information, including title, description, and images, is sourced/provided by our affiliate partner, Alison US CA.
Disclaimer: Some of the links on this website are affiliate links, meaning we may earn a commission if you click through and make a purchase. This comes at no additional cost to you.
By clicking the button above, you acknowledge that you will be redirected to a third-party website and agree to their terms and conditions.
Product information, including title, description, and images, is sourced/provided by our affiliate partner, Alison US CA.
Share this product with a friend:
Refer a friend and earn 0.05 CEC when they click the link, plus an additional 1.00 CEC if they register. Share this Product and boost your earnings together!
Log in to manage favorites.
Similar Products
Share this product with a friend:
Refer a friend and earn 0.05 CEC when they click the link, plus an additional 1.00 CEC if they register. Share this Product and boost your earnings together!