Whether you’re tracking expenses, budgeting goals or creating massive keyword lists with one million rows, the new Microsoft Excel 2007 will streamline your workflow like never before.
And thanks to Train Signal’s newest Excel 2007 course, you’ll master all of those time saving features, and business building tools in no time. No stone is left unturned as we break down common to advanced concepts into easy, hands on lessons!
We are so convinced that this course is the most comprehensive Excel 2007 training on the market, that we guarantee your satisfaction for 90 days! And if certification is your goal, rest assured that this course will help you pass the 77-602 MCAS Exam!
Video 1
Introduction
Meet your instructor, Bill Kulterman and become familiar with the features of this course and the scenario that will guide you through your learning experience.
Video 2
Welcome to Excel
A thorough explanation of the new interface of Excel 2007, focusing especially on The Ribbon, and navigation.
* The Ribbon
* Navigation, getting around in Excel
Video 3
Entering and Editing Data
Learn tricks to enter data lists quicker and easier.
* How to enter data
* Working With Ranges of Data
* Auto Fill, or Fill Series
Video 4
Calculations
Learn about basic arithmetic operations, and the syntax for writing Excel formulas. Discover many ways to perform the same function and learn about the new file formats of Excel.
* Understanding the Order of Operations
* Using Basic Formulas,
* Understanding Functions
* What is Absolute Reference?
* Save and Save As
Video 5
Multiple Worksheets
Understand the difference between a workbook and a worksheet. Learn to add, move, and copy worksheets in an existing workbook or a new one. Learn to calculate data from several worksheets.
* What is a Worksheet?
* Add a new Worksheet
* Using 3D Reference to calculate across several worksheets
* Working With Worksheets
Video 6
Basic Formatting
Learn about fonts, text size, color, cell options, fill, merge and center, borders, and alignment.
* Format Numbers
* Working with Text
* Cell options
Video 7
Organize your Excel data
Freeze Panes to make it easier to work with lots of data. Sort data into groups for better organization. Learn to filter out unwanted data.
* Freeze Panes
* Sorting your data
* Filtering out unwanted data
* Format Data as a Table
Video 8
Advanced Formatting
Learn about the new Styles options and Smart Art in Excel 2007, as well as mastering the drawing tools to create shapes and text boxes. All of this is meant to help give a nice finished appearance to your Excel workbooks.
* Using Excel Table Styles
* Adding Shapes to your Excel workbooks
* Graphics in Excel
* Using the new Smart Art tools
Video 9
Advanced Formulas PART 1
Get exposed to some of the most commonly used functions and formulas in Excel. Gain a basic understanding of the types of things you can do with Excel by exposing the user to the different functions available.
* Naming Ranges of data
* Lookup and Reference functions
* Logical Test functions
* Financial functions
* Using Database Functions
* Text functions
Video 10
Auditing features in Excel
Help people find errors in their worksheets, make sure the right type of data is being used, and keep an eye on changes as they happen.
* Identifying Errors
* Using Validation
* Watch Your Data
Video 11
Create Charts and diagrams in Excel
Learn to present data visually in easily understood charts and graphs.
* What Is a Chart?
* Create Charts with Excel
* Format Charts with Excel
Video 12
Working with Multiple Workbooks
Expose people to the concept of linking multiple workbooks together with formulas and summarizing information from a group of workbooks.
* Linking Workbooks
* Consolidation workbook data
Video 13
Use and Create a Template in Excel 2007
Streamline the process of creating the same worksheet repeatedly.
* What is a template?
* Creating our own templates
Video 14
Working with Pivot Tables
The goal here is to simply learn the best way to analyze large amounts of data in Excel.
* What are Pivot Tables?
* Creating a Pivot Table
* What else can I do with Pivot Tables?
* Formatting a Pivot Table
* Create a Pivot Chart
Video 15
Collaboration in Excel
Learn ways to track several people on the same worksheet and merge them together into a finished document; again, another time saver.
* Protect and share a workbook
* Tracking Changes in Excel
* Merging Documents
* Insert Comments and Hyperlinks in Excel
Video 16
Use and create Macros in Excel
Record a series of commands performed frequently to speed up the process, or make it easier for less skilled users to perform complex actions.
* Using Macros
* Creating Macros in Excel 2007
* Create a Macro Button
* Take a look at the Macro Editor, VBA
* Saving a workbook with a Macro
Video 17
Printing your Excel Worksheets
Control the way your documents print.
* Viewing your documents
* Page layout options
* Insert Headers and footers
* Prepare your document to print
Download
http://hotfile.com/dl/42935695/1c981ff/EXCEL_2007.part01.rar.html
http://hotfile.com/dl/42935820/4771a60/EXCEL_2007.part02.rar.html
http://hotfile.com/dl/42936062/642ff41/EXCEL_2007.part03.rar.html
http://hotfile.com/dl/42936123/6060ae0/EXCEL_2007.part04.rar.html
http://hotfile.com/dl/42936404/9b578ca/EXCEL_2007.part05.rar.html
http://hotfile.com/dl/42936669/a42d6fa/EXCEL_2007.part06.rar.html
http://hotfile.com/dl/42936920/b9b7c5e/EXCEL_2007.part07.rar.html
http://hotfile.com/dl/42937087/6091ca1/EXCEL_2007.part08.rar.html
http://hotfile.com/dl/42937118/2574d7c/EXCEL_2007.part09.rar.html
http://hotfile.com/dl/42937222/a2005ef/EXCEL_2007.part10.rar.html
http://hotfile.com/dl/42937978/6726df4/EXCEL_2007.part11.rar.html
http://hotfile.com/dl/42938065/9bba02e/EXCEL_2007.part12.rar.html
http://hotfile.com/dl/42938179/5d9ce56/EXCEL_2007.part13.rar.html
http://hotfile.com/dl/42938222/84cc795/EXCEL_2007.part14.rar.html
http://hotfile.com/dl/42938588/868df26/EXCEL_2007.part15.rar.html
http://hotfile.com/dl/42938591/9b32434/EXCEL_2007.part16.rar.html
http://hotfile.com/dl/42938687/b5c9080/EXCEL_2007.part17.rar.html
http://hotfile.com/dl/42938914/7794a6e/EXCEL_2007.part18.rar.html
http://hotfile.com/dl/42939025/52120de/EXCEL_2007.part19.rar.html
http://hotfile.com/dl/42939395/4fe2889/EXCEL_2007.part20.rar.html
http://hotfile.com/dl/42939625/23aef8d/EXCEL_2007.part21.rar.html
http://hotfile.com/dl/42939672/a1f23ed/EXCEL_2007.part22.rar.html
http://hotfile.com/dl/42939733/83e4372/EXCEL_2007.part23.rar.html
http://hotfile.com/dl/42940119/a6784dd/EXCEL_2007.part24.rar.html
http://hotfile.com/dl/42940149/eee2757/EXCEL_2007.part25.rar.html
http://hotfile.com/dl/42940161/493eaa6/EXCEL_2007.part26.rar.html
http://hotfile.com/dl/42940493/07f1425/EXCEL_2007.part27.rar.html
