Excel 2007 Course Medium Advanced Level (II)

Product description:

Who should attend this course?

For those who are on INTERMEDIATE level in using Microsoft Excel 2000/2002/2003/2007

At the end of this course participants will be able to:

-use the new Office 2007 interface (Fluent)
-print Excel spreadsheets with any number of rows and columns.
-set printing properties common: Header, Footer, Margins, zoom, etc.
-import Excel data into a database or the Internet
-implement a protection mechanism for writing data using Data Validation tool.
-sort data in an Excel spreadsheet by any column.
-filter data from an Excel spreadsheet by any condition logic.
-follow some data in an Excel spreadsheet format by changing their attributes (Conditinal Formatting).
-easily and quickly calculate totals and subtotals.
-consolidated data
-process (computer, convert, transform) data using formulas and functions
-calculate values based on the proposed targets (Goal Seak).
-analyze data using the instrument of scenarios
-secure cards and Excel cells
-analyze data using Pivot

Prior knowledge

To successfully participate at this course students must be familiar with Excel interface 2000/2002/2003.

Trainer Information

The course was developed by Dr.Excel (Bogdan Tarla) MVP (Microsoft Most Valuable Professionals) with specialization Microsoft Office.

 All our online courses are 100% guaranteed, you have nothing to lose!
10-Day Money Back Guarantee!

If you feel that you did not benefit from the course, no hard feelings. We'll simply give you a full refund, no questions asked! If you would like to cancel your account for any reason, then please contact Office-Learning tream at: support@office-learning.com

Course Outline

Chapter 1 - Sort and Filter

• Simple and Complex Sorting
• Sorting depending on formatting attributes
• Filter - columns of type date calendar
• Filter - depending on formatting attributes
• Filter - extracting distinct values

Chapter 2 - Data Validations

• Validation by a logical condition
• Validation by a list of possible values
• Validate data by a formula

Chapter 3 - Data Import

• Import from MS Access database
• Import from CSV files
• Import data using dynamic links

Chapter 4 - Functions

• Functions of type Date and Time - Today, Now
• Functions of type Date and Time - Year, Month, Day, Weekday
• Boolean Functions (Logic) - AND, OR
• Functions of type Text - Left, Right, Len
• Functions of type Text - Trim, Lower, Upper
• Functions of type Text - Find, Mid
• Functions Standard Units - Sum, Count, Average, Min, Max
• Conditional Functions - IF ()
• Data retrieval functions - LookUp (HLOOKUP, VLOOKUP)
• Data retrieval functions - Match, Index
• Conditional aggregate functions - SUMIF, COUNTIF
• Financial Functions - PMT

Chapter 5 - Formulas

• Finding and correcting errors in a formula
• Distinguishing the differences between two columns
• Backward calculation
• Create 3-D References
• Data Consolidation
• Tracking formulas - debug error
• Tracking formulas - view dependencies
• Custom Lists
• Clear tools and Paste Special

Chapter 6 - Charts

• Create charts
• Add trend line

Chapter 7 - Automatic Formatting

• Simple Formatting
• Finding duplicate values
• Find and Replace after formatting attributes
• Automation control panels

Chapter 8 - Smart Tables

• Working with Smart Tables (Part 1)
• Working with Smart Tables (Part 2)
• Working with the Name Range - Creating
• Working with the Name Range - Automatic generation
• Pivot Tables
• Alternative to the Pivot Tables - SUMIF and CONSOLIDATE

Chapter 9 - Macrocomands

• Assign macro to a button code
• Recording a macro

Chapter 10 - General

• Protection of Excel documents
• Templates
• Break column - Fixed Size
• Break column - separator