CBT Nugget’s detailed video series carefully explains this new interface and how to make the most out of Excel 2007's updated features.
Trainer Emily Berry fast-forwards you through the program. She shows you exactly what you need to know to accomplish your familiar tasks within the changed interface. The skills you learn will make your workload more manageable and impress current and future employers. Emily’s videos map directly to Microsoft certification exam 77-602 for the MCAS: Using Microsoft Office Excel 2007. Your only course prerequisite is a willingness to try out all the cool tools demonstrated in the videos.
Here's what you'll learn from the Microsoft Excel Video Series:
1: “Introduction to Excel 2007” - This video walks you through the Excel 2007 interface, including the Office 2007 Ribbon and the Office button. The basic spreadsheet layout, changing worksheet views, analyzing data on-the-fly and things you must know about saving files in the new 2007 format are all covered.
2: “Excel 2007 Basics” - This video begins your journey of creating and manipulating data in Excel workbooks. Inserting text and numbers and AutoSumming values are demonstrated, as well as the advantages of the AutoFill command. Inserting and modifying rows and columns is another important component of spreadsheet manipulation discussed in this video.
3: “Excel 2007 Spreadsheet Formatting” - Audiences sometimes feel overwhelmed by the amount of information stored in a spreadsheet. But with a few easy formatting tricks, the information can be easily understood and smartly displayed. Although Excel 2007 uses many formatting commands from earlier editions, there are also new styles and features, such as formatting data in a table.
4:“Use Excel 2007 as a Database” - Excel can be a powerful tool for storing and extracting data. The Sort and Filter commands are easy to use, and they facilitate data searching and analysis. This video also covers various formulas that can display such information as the maximum value in a specific field or the average of all data in a column.
5: “Charts in Excel 2007” - Charts are one of the best ways to reach your audience. With a quick glance, charts make it easy to understand the goal of your detailed spreadsheet. Excel 2007 has many tools and techniques for creating and modifying charts. In fact, you can create over seventy different types of charts. But charts aren’t the only type of graphic you can insert into your spreadsheet. Illustrations, such as pictures and Smart Art, can also be utilized to express your point visually.
6: “Collaborate Data Using Excel 2007” - Excel 2007 enhances collaboration among teams. Many people can update and share their results within the same file. As the owner of the file, you can limit what cells are editable and even who is allowed to access the information. This video covers how to share, protect and manage changes to worksheets and workbooks.
7: Consolidate Data Using Excel 2007” - Sometimes normal business processes generate many separate worksheets that need to be combined for better reporting and analysis. Using the Consolidate tool, you'll manage worksheets by combining many related cell ranges into one cumulative range. Not only is there a tool that consolidates, there are also formulas you can create to summarize data
8: “Pivot Tables in Excel 2007” - Pivot tables are a handy way of displaying unwieldy data in an easy-to-interpret model. These tables allow you to cross-tabulate information. The easy-to-use interface allows you to click-and-drag to rearrange data. You can also sort, filter and format the data as a table.
9: “Basic Formulas in Excel 2007” - A major component of most spreadsheets is calculating data. This video sets you on the path to creating and modifying formulas. The insert function and the formula ribbon contain many of the tools you will use to reference and calculate data in your formulas. The difference between relative and absolute references is also explained here.
10: “Conditional Formulas in Excel 2007” - It’s likely that analyzing data will be based on conditions. This Video covers using "If" formulas to conditionally summarize data. Conditional logic can also be the foundation for looking up data from a range and displaying the appropriate value based on set criteria.
11: “Data Integrity in Excel 2007” - This video covers auditing and troubleshooting formulas, as well as enforcing data integrity. There are special tools you can use to view cells that precede the formula or that depend on the outcome of the formula’s calculations. The Display Formula button can also assist troubleshooting endeavors by making it easy to see all the formulas in your sheet at once. Excel 2007 even allows you to set data validation rules, which limit the type of information accepted into the worksheet.
12: “Summarize Data in Excel 2007” - Worksheets often contain large amounts of similar data. The outlining and subtotaling features built into Excel 2007 help you easily summarize your spreadsheets. Conditional formatting brings your work to the next level by focusing on particular pieces of data, based on criteria. Conditional formatting can even utilize formulas to modify the way text looks.
13: “Prepare for Printing in Excel 2007” - The majority of worksheets will either be delivered electronically or printed. This Video covers preparing workbooks for distribution, including setting print options.
14: “Data Security in Excel 2007” - Data security is paramount for computer users. The nature of many spreadsheets is to collect and analyze confidential information. This video covers important points about encrypting, setting passwords and using digital signatures. It also covers the extra steps you can take to protect your information and your computer.
15: “What-If Analysis” - Using Excel 2007's data tables, scenarios and goal seeking tools, you can model your data based on different inputs. This Video introduces you to all the available tools you’ll use when running what-if analysis.
The MCAS: Excel 2007 Video Series includes :
Trainer Emily Berry fast-forwards you through the program. She shows you exactly what you need to know to accomplish your familiar tasks within the changed interface. The skills you learn will make your workload more manageable and impress current and future employers. Emily’s videos map directly to Microsoft certification exam 77-602 for the MCAS: Using Microsoft Office Excel 2007. Your only course prerequisite is a willingness to try out all the cool tools demonstrated in the videos.
Here's what you'll learn from the Microsoft Excel Video Series:
1: “Introduction to Excel 2007” - This video walks you through the Excel 2007 interface, including the Office 2007 Ribbon and the Office button. The basic spreadsheet layout, changing worksheet views, analyzing data on-the-fly and things you must know about saving files in the new 2007 format are all covered.
2: “Excel 2007 Basics” - This video begins your journey of creating and manipulating data in Excel workbooks. Inserting text and numbers and AutoSumming values are demonstrated, as well as the advantages of the AutoFill command. Inserting and modifying rows and columns is another important component of spreadsheet manipulation discussed in this video.
3: “Excel 2007 Spreadsheet Formatting” - Audiences sometimes feel overwhelmed by the amount of information stored in a spreadsheet. But with a few easy formatting tricks, the information can be easily understood and smartly displayed. Although Excel 2007 uses many formatting commands from earlier editions, there are also new styles and features, such as formatting data in a table.
4:“Use Excel 2007 as a Database” - Excel can be a powerful tool for storing and extracting data. The Sort and Filter commands are easy to use, and they facilitate data searching and analysis. This video also covers various formulas that can display such information as the maximum value in a specific field or the average of all data in a column.
5: “Charts in Excel 2007” - Charts are one of the best ways to reach your audience. With a quick glance, charts make it easy to understand the goal of your detailed spreadsheet. Excel 2007 has many tools and techniques for creating and modifying charts. In fact, you can create over seventy different types of charts. But charts aren’t the only type of graphic you can insert into your spreadsheet. Illustrations, such as pictures and Smart Art, can also be utilized to express your point visually.
6: “Collaborate Data Using Excel 2007” - Excel 2007 enhances collaboration among teams. Many people can update and share their results within the same file. As the owner of the file, you can limit what cells are editable and even who is allowed to access the information. This video covers how to share, protect and manage changes to worksheets and workbooks.
7: Consolidate Data Using Excel 2007” - Sometimes normal business processes generate many separate worksheets that need to be combined for better reporting and analysis. Using the Consolidate tool, you'll manage worksheets by combining many related cell ranges into one cumulative range. Not only is there a tool that consolidates, there are also formulas you can create to summarize data
8: “Pivot Tables in Excel 2007” - Pivot tables are a handy way of displaying unwieldy data in an easy-to-interpret model. These tables allow you to cross-tabulate information. The easy-to-use interface allows you to click-and-drag to rearrange data. You can also sort, filter and format the data as a table.
9: “Basic Formulas in Excel 2007” - A major component of most spreadsheets is calculating data. This video sets you on the path to creating and modifying formulas. The insert function and the formula ribbon contain many of the tools you will use to reference and calculate data in your formulas. The difference between relative and absolute references is also explained here.
10: “Conditional Formulas in Excel 2007” - It’s likely that analyzing data will be based on conditions. This Video covers using "If" formulas to conditionally summarize data. Conditional logic can also be the foundation for looking up data from a range and displaying the appropriate value based on set criteria.
11: “Data Integrity in Excel 2007” - This video covers auditing and troubleshooting formulas, as well as enforcing data integrity. There are special tools you can use to view cells that precede the formula or that depend on the outcome of the formula’s calculations. The Display Formula button can also assist troubleshooting endeavors by making it easy to see all the formulas in your sheet at once. Excel 2007 even allows you to set data validation rules, which limit the type of information accepted into the worksheet.
12: “Summarize Data in Excel 2007” - Worksheets often contain large amounts of similar data. The outlining and subtotaling features built into Excel 2007 help you easily summarize your spreadsheets. Conditional formatting brings your work to the next level by focusing on particular pieces of data, based on criteria. Conditional formatting can even utilize formulas to modify the way text looks.
13: “Prepare for Printing in Excel 2007” - The majority of worksheets will either be delivered electronically or printed. This Video covers preparing workbooks for distribution, including setting print options.
14: “Data Security in Excel 2007” - Data security is paramount for computer users. The nature of many spreadsheets is to collect and analyze confidential information. This video covers important points about encrypting, setting passwords and using digital signatures. It also covers the extra steps you can take to protect your information and your computer.
15: “What-If Analysis” - Using Excel 2007's data tables, scenarios and goal seeking tools, you can model your data based on different inputs. This Video introduces you to all the available tools you’ll use when running what-if analysis.
The MCAS: Excel 2007 Video Series includes :
- Introduction to Excel (free video)
- Excel 2007 Basics
- Spreadsheet Formatting
- Use Excel as a Database
- Charts
- Collaborate Data
- Consolidate Data
- Pivot Tables
- Basic Formulas
- Conditional Formulas
- Data Integrity
- Summarize Data
- Prepare for Printing and Distribution
- Data Security
- What-If Analysis
http://rapidshare.com/files/149530384/CBT_nuggets_MCAS_series_Microsoft_Office_Excel_2007.part01.rar
http://rapidshare.com/files/149531853/CBT_nuggets_MCAS_series_Microsoft_Office_Excel_2007.part02.rar
http://rapidshare.com/files/149533369/CBT_nuggets_MCAS_series_Microsoft_Office_Excel_2007.part03.rar
http://rapidshare.com/files/149534834/CBT_nuggets_MCAS_series_Microsoft_Office_Excel_2007.part04.rar
http://rapidshare.com/files/149536354/CBT_nuggets_MCAS_series_Microsoft_Office_Excel_2007.part05.rar
http://rapidshare.com/files/149537756/CBT_nuggets_MCAS_series_Microsoft_Office_Excel_2007.part06.rar http://rapidshare.com/files/149539180/CBT_nuggets_MCAS_series_Microsoft_Office_Excel_2007.part07.rar
http://rapidshare.com/files/149531853/CBT_nuggets_MCAS_series_Microsoft_Office_Excel_2007.part02.rar
http://rapidshare.com/files/149533369/CBT_nuggets_MCAS_series_Microsoft_Office_Excel_2007.part03.rar
http://rapidshare.com/files/149534834/CBT_nuggets_MCAS_series_Microsoft_Office_Excel_2007.part04.rar
http://rapidshare.com/files/149536354/CBT_nuggets_MCAS_series_Microsoft_Office_Excel_2007.part05.rar
http://rapidshare.com/files/149537756/CBT_nuggets_MCAS_series_Microsoft_Office_Excel_2007.part06.rar http://rapidshare.com/files/149539180/CBT_nuggets_MCAS_series_Microsoft_Office_Excel_2007.part07.rar
Password : sad_gull
Comments
0 comments to "Learn Excel Video Series"
Post a Comment