Find the date that falls after a number of workdays.Find the number of workdays between two dates.Find the number of days between two dates.Figure out dates by using formulas in Excel 2010 Learning Outcomes.Module 13: Figure out dates by using formulas in Excel 2010 Save time by creating and running macros in Excel 2010 Lesson Summary.Edit an existing macro to change what it does.Save time by creating and running macros in Excel 2010 Learning Outcomes.Module 12: Save time by creating and running macros in Excel 2010
CURSO EXCEL 2016 DOWNLOAD HOW TO
How to create a basic chart in Excel 2010 Lesson Summary.How spreadsheet data appears in a chart.How to create a basic chart in Excel 2010 Learning Outcomes.Module 11: How to create a basic chart in Excel 2010 The IF Function - What it is and how to use it Lesson Summary.The IF Function - What it is and how to use it Learning Outcomes.Module 10: The IF Function - What it is and how to use it Use Excel tables to manage information Lesson Summary.Use Excel tables to manage information Learning Outcomes.Module 9: Use Excel tables to manage information Sparklines - Use tiny charts to show data trends Lesson Summary.Sparklines - Use tiny charts to show data trends Learning Outcomes.Module 8: Sparklines - Use tiny charts to show data trends Understand Data at a glance with Conditional Formatting Lesson Summary.Understand Data at a glance with Conditional Formatting Learning Outcomes.Module 7: Understand Data at a glance with Conditional Formatting VLOOKUP - What it is and when to use it Lesson Summary.Using absolute cell references with VLOOKUP.Using more than one spreadsheet with VLOOKUP.VLOOKUP - What it is and when to use it Learning Outcomes.Module 6: VLOOKUP - What it is and when to use it More about cell references and formulas.Create your first spreadsheet Lesson Summary.Keep column titles in sight as you scroll.Get more(or less) columns, rows, spreadsheets.Create your first spreadsheet Learning Outcomes.Basic Tasks in Excel 2010 Lesson Summary.Create an Excel table, formula and chart your data.Create, save, print, and apply templates to a workbook.Basic Tasks in Excel 2010 Learning Outcomes.What's new in Excel 2010 Lesson Summary.Collaborate on a worksheet in the browser.Create workbooks with more visual impact.Obtain powerful analysis from your desktop.Make fast, effective comparisons from lists of data.Access the right tools, at the right time.What's new in Excel 2010 Learning Outcomes.Making the switch to Excel 2010 Lesson Summary.Work between new and old Excel versions.Making the switch to Excel 2010 Learning Outcomes.
Module 1: Making the switch to Excel 2010 Every office has its ‘Excel experts’ who stand apart from their peers so sign up for this training course to become one of them. The program is a vital business budgeting tool and is employed worldwide by a range of industries. You can use Microsoft Excel 2010 to keep track of almost any data, from work schedules to stocks and beyond. We also lay out the steps required to calculate dates using formulas and check conditions with the ‘IF’ function before we describe the ‘save’ and ‘run’ macros. This course explains how to work with formulas and functions before covering the use of ‘VLOOKUP’ to search through a spreadsheet’s data. It can automatically perform calculations once you add in the formula, which makes it a great tool for analyzing data in accounts, budgets, billings and many other areas. We demonstrate how to visually represent data to indicate trends, patterns and comparisons across charts, tables or other templates.Įxcel 2010 boasts many improvements and new features. We present practical exercises and sample spreadsheets to show you how Excel handles basic math while we add and delete columns and rows and prepare the worksheet for printing. We explore the program’s menus and examine the different tasks it can perform.
CURSO EXCEL 2016 DOWNLOAD FULL
This course teaches you how to make full use of the revised 2010 version of Microsoft Excel.
0 kommentar(er)
