Learn Excel Advanced 2007 Overview - Advanced Excel Training and Help

"Try My Product^® today for FREE*!"

If you are not happy with the lessons, just call to return one CD within 10 days and keep the other two CDs FREE* to avoid a purchase charge.

*Pay up to $9.95 USD for shipping & processing.

MEMBER LOGIN »

Search Tips

Back

With this Learn Excel^® Advanced 2007 tutorial you will learn:

Your CDs will include both versions!

Lesson One	Lesson Two	Lesson Three
Section 1 - Introduction Ribbon user interface Windows® 2000 Windows XP Windows Vista® Practice Lesson Files Section 2 - Understanding Functions Functions defined Formulas defined Mathematical functions defined Mathematical formulas defined Open existing workbook Practice Lesson Files Logical functions defined Shortcut: Ctrl+End Freeze pane defined Create Freeze pane Shortcut: Ctrl+Home Keyboard shortcut letters Keyboard shortcut defined Anatomy of a function Arguments defined Insert Function dialog box Search for a function Maximum function Number of arguments needed Insert Function dialog box Function categories Search for a function Select a function Select a category of function Average function Mean defined Help on selected functions Function Argument dialog box Active arguments Reference range defined Formula result in argument box Sum function Icon alert Save file with new name Office Button Section 3 - Using Advanced Functions Use multiple worksheets Navigate through worksheets Insert Function icon SUMIF function COUNTIF function Functions using multiple worksheets Criteria defined Cell Selection button defined Cell range addresses defined AutoFill formula Absolute cell address Relative cell address Set cells for absolute Rank function Ascending order defined Descending order defined Change to currency format Conditional formatting Data bar defined AutoSum button Insert shapes to worksheet Enter total into a shape Change shape color Change font color Section 4 - Lookup and Reference Functions Lookup table defined Reference defined VLOOKUP function Function categories Table array defined Return data defined Logical value defined Nesting functions and formulas IF function defined Null defined Section 5 - Subtotal Reports Subtotal report defined Sort data by category Shortcut key Ctrl+Shift+Down arrow to select column Group buttons in subtotals Outline buttons in subtotals Collapse subtotal reports Find and Select feature Visible Cells Only features Go To Special dialog box Find and Replace feature Format visible cells Subcategories for multiple categories Sort multiple fields Add Level to Sort dialog box Replace Current Subtotal feature Section 6 - Advanced Formatting Guidelines to usable worksheet Format as Table icon Select elements in table Table Style options Header row to a table Banded rows defined Select entire table Add totals to table Currency Style format Account style format Percentage style format Adjust formatting to tables Add borders to tables Add patterns to tables Add font to tables Styles defined Currency Style icon Create new style Name new style Apply style to cells Normal style defined Percent Style icon Comma Style icon Merge and Center icon Modify an existing style Share styles Merge styles Brand defined Add graphics to table Resize graphics Section 7 - Creating a PivotTable® PivotTables reports PivotTable defined Drag-and-drop method defined PivotTable field defined Create a PivotTable Create a PivotTable from Excel list or database Create a PivotTable from external data Multiple consolidation range Data range Cell Selection button Select location for PivotTable Create new worksheet for PivotTable PivotTable tools PivotTable filter PivotTable label PivotTable field list defined Section 8 - Working with PivotTable Reports Clear PivotTable Decide to put data on rows or columns Adjust field settings Value field settings Summarize field settings Number Format button Accounting number category Open Field Options dialog box PivotTable options Name PivotTable field Name PivotTable Format PivotTable Fill in empty cells with text PivotTable styles Banded rows and columns Compact form view Outline form view Tabular form view Section 9 - Options in PivotTable Reports Hide data groupings Add groupings to data Value filter defined Label filter defined Clear filters Enable subtotals Group Selection button Rename groupings Advanced field settings Show values as tab Set values as percentage Rename worksheet tab Create groups Name groups Collapse data to show only totals Remove data from PivotTable Report filter Drill down into data Show subtotal in PivotTable Section 10 - PivotChart® Reports PivotCharts defined Create PivotTable as basis for chart Count function Name PivotTable Rename worksheet Insert Chart dialog box Create PivotChart PivotChart Filter pane Make change to PivotChart Change chart type Update data on chart Adjust chart setting	Section 1 - Introduction Practice Lesson Files Section 2 - Advanced Graphing and Charting Highlight noncontiguous rows or columns Create a chart Select data range Data series defined Switch Row/Column button Select Data button Edit data series Series name defined Move Chart option Data Labels button Change chart title Remove axis from charts Primary and secondary axes Show axis in thousands/millions Plot area defined Chart area defined Legend defined Select a specific column Select a single column Combine chart types Change series chart type Section 3 - Graph and Chart Elements Chart styles defined Edit data labels Delete data labels Format data labels Data Label Options dialog box Legend keys Separator defined Text alignment defined Change text alignment Rotate data labels Format axis Line style Line color Tick marks Change color to data Axis options Automatic adjustment of axis options Change gridlines Set major and minor units Change line weight Category Axis option Set label distance from axis Change series options Change line style and color Add markers to lines to chart Change marker styles in lines Gradient fill defined Add shadow to chart Format plot area Fill effects Add textures and patterns to background Section 4 - Creating Chart Templates Chart template defined Save as Template icon Name a chart template .crtx extension for template Create a chart from template Create Chart dialog box Move chart to new sheet Move Chart icon Section 5 - Drawing Comments in a chart Shapes Options Open Drawing Tools tab Shapes tools Insert text box to chart AutoShapes Text boxes Format text box Format text effects Format shapes Change alignment in text box Text wrap in text box Fill color to box Change color in text box Change color and style of lines in text box Connector lines defined Connector points Add connectors Resize text box Resize connectors Section 6 - Trendlines Trendlines defined Regression analysis defined Trendline types Linear Logarithmic Polynomial Power Exponential Moving Average Add trendline to chart Determine data points Format trendlines Display equation on chart Display R-squared value on chart Move equation box Line equation defined R-squared value defined Best fit line Add multiple trendlines Moving average trendline defined Section 7 - Named Ranges Named ranges defined Define named range Determine scope of named range Name manager defined Define command to named cells Noncontiguous named range Name the named range Max function Format for currency Use named range in formulas Update named ranges Section 8 - Distributing Worksheets Delete empty worksheets Hide worksheets Unhide worksheets Protection defined Reasons to protect a worksheet Protect a worksheet Built-in protection features Lock specific cells Lock specific worksheet Protection settings Select worksheet level of protection Change protection options Lock cells defined Hide cells defined Enable worksheet protection Unlock named range Lock scroll bars Protect cells Password protection Select passwords Select password options Edit locked cells Allow User to Edit Ranges prompt Unlock range Protect workbook Protect Structure and Windows prompt defined Password protect entire file Password to open file Password to modify file User-specific access to files Information Rights Management (IRM) software	Section 1 - Introduction Macros defined Practice Lesson Files Section 2 - Radio and Option Buttons in Forms Forms defined Collect feedback and information Developer tab Excel options Show Developer tab in Ribbon Control tools area Form objects Scroll bars Spinners Add input areas on forms Input areas defined Format cells Border cells Add border to cells Radio buttons defined Form controls defined ActiveX® controls Check Box icon Check Box form control Format Controls box Move or edit check box Option Button icon Group Option icon Cell link box Link options Expand column width Default option feature Section 3 - Combo and List Boxes in Forms Combo box defined Developer tab Draw a box Create a combo box Read list into combo box Select input range Index function List box defined Define names Visual Basic® macro Create a list box Named ranges import Spinner defined Spinner icon Create spinner chart Set values in spinner controls Insert chart in spinner Remove legend from chart Resize chart Axis options Select multiple worksheets Hide worksheets Lock worksheets Protect worksheet Section 4 - Importing External Data CSV defined Comma-separated values File format defined Notepad Practice Lesson Files Text documents Get External Data tools area Transfer data from Internet Transfer data from text form Open Notepad Import external data sources Data sources available Text Import Wizard Delimited file defined Fixed width format Pre-format fields Fixed width file defined Select columns to skip import Do not import column Skip column Change data type Treat consecutive delimiters as one option Import Access database into Excel Import Internet data Insert new worksheet Export new Web query Query defined Import tables from web site Update Web query Refresh icon XML defined Import XML file Web browser XML elements defined Section 5 - Macros Macros defined Reasons for creating macros Macro security settings Default macro settings Levels of security for macros Developer tab Open Developer tab Macro Security icon Trusted locations Set up trusted locations Trusted subfolders Visual Basic Record a macro Name a macro Assign shortcut key Where to store macro Share macros with others Describe a macro Stop recording macro Relative mode Absolute mode Record in relative or absolute mode Run the macro Assign macro to key combination Shortcut Ctrl+Shift+arrow to select entire row Create dynamic macros Section 6 - Editing Our Macros Visual Basic programming code Visual Basic defined Edit macro in file Unhide workbook Open list of macros Visual Basic Editor screen Sub-procedure defined Function procedure defined Comment text in a macro Objects hierarchy in macros Methods defined Properties defined Edit existing macros Process macros Macro properties Close macro editor Boolean operators Shortcut: Alt+F8 to open Macro window Add code to macro Save macro from Macro window


Your CDs will include both versions!

Back

Video Professor, its logos, slogans and product feature names are trademarks and/or registered trademarks of Video Professor, Inc. in the U.S. and other countries. All other trademarks are the property of their respective owners, and the aforementioned entities neither endorse nor sponsor Video Professor or its products.