Download it today and
enjoy your newly improved OFFICE skills
tomorrow!
Training for Excel basic and Advanced
Take a look at what you will receive:
No risk, 100% guaranteed quality tutorials
Available CD and immediate download
Lifetime educational training investment
Essential and Advanced Microsoft Office training
UNLIMITED online access at any time from anywhere
2 Free bonus e-Learning training cour
Valuable practical experience
Includes complete training tutorial courses for : Excel Basic and Excel Advanced
60 day money back guarantee Full technical support Secure online payment
Don't settle for "Watch Only" video tutorials. Try our interactive courses to experience practical "hands-on" training!
Discover an easy to use
interactive software training course that will teach you how to
discover the true strength of the Microsoft
Excel.
This user friendly interactive course lets you study at your own pace as you cover the functions and tools of the Excel, giving you software training that will develop both your expertise and your confidence. Finally here is a way to become fluent in Microsoft Excel, a spreadsheet application that is a financial industry standard worldwide.
Chapter 1 Covers Excel structure and ways to open and save the worksheet
1. Starting EXCEL 2. What is a spreadsheet? 3. Workbook Saving 4. Save as dialog box 5. Workbook opening 6. Open dialog box 7. New workbook opening 8. Workbook closing 9. Handling several workbooks 10. Password
Chapter 2 Chapter covers data types, cells selecting, editing and marking
1. Data Types 2. Rows, Columns and cells Selecting 3. Entering data 4. Data Editing 5. Clearing Cells content 6. Cells deleting 7. Rows, Columns and cells inserting 8. Undo and Redo buttons 9. Copy Data 10. Paste Special
Chapter 3 Covers ways to determine the look and design of the worksheet
1. Setting columns width 2. Setting row height 3. What is a font? 4. Underling Text 5. Bold Text 6. Italic Text 7. Text alignment 8. Worksheets navigation 9. Naming a worksheet 10. Add / delete a worksheet
Chapter 4 Covers cells formations and working with worksheets
1. Moving or copying a worksheet 2. Format cells 3. Add border and color 4. Hide and Unhide 5. Freeze Panels 6. Cell rename 7. Worksheet direction
Chapter 5 Covers the basic of formulas and functions
1. What is a formula? 2. Recognize a formula in a cell 3. Entering a formula 4. Relative address 5. Copy formula to cell region 6. Fix address 7. What is a function 8. SUM function 9. Useful functions 10. Function Wizard
Chapter 6 Covers diagrams, graphs and pivot table topics
1. What is diagram? 2. Creating a diagram 1 3. Creating a diagram 2 4. Editing a diagram 5. Diagram format 6. Diagram Printing 7. Delete / Copy Diagram 8. Pivot Table
Chapter 7 Covers preview and print subjects
1. Printing steps 2. Page setup 3. Margin setup 4. Header and Footer setup 5. Sheet setup 6. Print Preview 7. Print 8. What to print
Chapter 8 Covers Macros and Lists
1. List building 2. Display AutoFilter buttons 3. Using AutoFilter buttons 4. What is a Macro 5. Macro recording 6. Running the Macro 7. Macro Editing
Chapter 9 Covers exporting and importing data
1. Importing sources 2. CVS file 3. Open CVS file 4. Importing data from internet 5. Cut and Paste
Chapter 10 Looking and analyzing several common applications
1. Operators 2. Actions execution Order 3. Grade spreadsheet 4. IF Condition Function 5. COUNT IF condition counting Function 6. Attendance spreadsheet 7. Time calculation
EXCEL ADVANCED COURSE
CHAPTER 1 The following chapter covers the basic formulas and functions.
1. What is a formula? 2. Recognizing a formula in a cell 3. Entering a formula 4. Relative address 5. Copy formula to cell region 6. Fix address 7. What is a function? 8. SUM function 9. Useful functions 10. Function Wizard
CHAPTER 2 This chapter will discuss IF and LOOKUP groups
1. IF functions 2. AND 3. OR 4. COUNTIF 5. SUMIF 6. LOOKUP 7. VLOOKUP 8. HLOOKUP
CHAPTER 3 This chapter will discuss date and time groups
1. Days360 2. Now 3. Date value and Format cell 4. WorkDay 5. Networkdays 6. Today 7. WeekDay 8. Day 9. Month 10. Year
CHAPTER 4 This chapter will discuss Database formulas and the Pivot table
CHAPTER 5 This chapter will discuss MACRO and forms
1. Introduction - Macro 2. Recording a Macro 3. Running a Macro 4. Introduction - Forms 5. Creating Forms 6. Radio Buttons 7. Button 8. Combo Box 9. List Box 10. Check Box
CHAPTER 6 This chapter will discuss the concluding project
1. The demo file 2. MACRO approval - Excel 2003 3. MACRO approval - Excel 2007 4. Project overview 5. Introduction 6. Approach this complicated project 7. Customer request 8. The charts in this project 9. Navigation and modification buttons 10. Evaluate deadline
CHAPTER 7 In this chapter, we will discuss all of the items in the project and explain the creation process for each one
1. Introduction 2. Creating all sheets 3. Formatting the first sheet 4. Formatting the second sheet 5. Formatting the third sheet 6. Formatting the fourth sheet 7. Formatting the fifth sheet 8. Formatting the sixth sheet 9. Concluding
ACCESS COURSE
CHAPTER 1
Preparation and Analysis
1. Database
2. System Review
3. System Analysis
4. First Order Normalization
5. Second Order Normalization
6. Third Order Normalization
7. Relationship
8. Testing
CHAPTER 2
Tables and Data entry
1. Starting Access
2. Creating a Database
3. Creating Table in Edit View
4. Defining Key for a Table
5. Defining Field Types
6. Opening Database
7. Entering Data
8. Table Display
CHAPTER 3
Search Sort and Filter
1. Columns Size and Position
2. Cell and Record Selecting
3. Record Deleting
4. Record Finding
5. Records Sorting
6. Filtering by Form
7. Filtering by Selection
8. Filtering Cancellation
9. Table Copying
10. Table Deleting
1. What is a Query?
2. Queries Types
3. Basic Query
4. Multiple Tables in Query
5. Query Wizard
6. Filtering data in a Query
7. Calculations in a Query
8. Query Characteristics
9. Duplicate Records
CHAPTER 6
Forms
1. What is a form?
2. Form Wizard
3. Form Design View
4. Adding Fields to Form
5. Saving and Opening form
6. What are controls?
7. Label Control
8. Text Control
9. Control Characteristics
10. Push Button
CHAPTER 7
Reports
1. What is a report
2. Report Wizard
3. Report Design View
4. Adding Fields to the Report
5. Saving a Report
6. Printing a Report
7. Reports Controls
CHAPTER 8
Macros
1. What is a Macro?
2. Macro Design Window
3. Add Actions to Macro
4. Saving Macros
5. Running Macros
6. Push Button & Macros
7. Running a Macro
1. Starting Power Point
2. Creating a new Slide Show
3. The screen structure
4. The slide show exercise
5. Applying background
6. Filling effect
7. Adding a slide
8. Project Saving
9. Adding picture
10. Running the slide show
Chapter 2
1. What is font?
2. Adding text box
3. Font type and size
4. Underling Text
5. Bold Text
6. Italic Text
7. Text alignment
8. Font color
9. Format Painter button
Chapter 3
1. Pictures video and graphics
2. Word Art
3. Adding picture from Clip Art
4. Adding picture from a file
5. Size and Rotation change
6. Adding video movie
7. Recording voice
8. Sound object options
Chapter 4
1. What is an object
2. AutoShape Object
3. Object types in auto shapes
4. Adding effect to object
5. Grouping Objects
6. Ungrouping objects
7. Forwarding an object
8. Backward an object
Chapter 5
1. What is animation?
2. Costume animation
3. Adding effect
4. Tuning the effect
5. Order and timing
6. Effect Options
7. Entrance and exit effects
8. Motion path effect
9. Slide transition window
10. Add slide transition effect
Chapter 6
1. What is navigation?
2. Hyperlink to a slide
3. Hyper link to a web site
4. Hyper link to a document
5. Hyper link to E-mail
6. Action buttons
7. Action settings
8. Action settings for mouse click
9. Action settings for mouse over
Chapter 7
1. Creating a comment
2. Printing the slide show
3. Creating a CD
4. Internet Publish
OUTLOOK COURSE
Chapter 1
1. What is Outlook?
2. Screen Structure
3. The Toolbar
4. The Menu Bar
5. The Inbox
6. The Outbox
7. The Calendar
8. Contacts
9. Tasks
Chapter 2
1. What is E-mail?
2. Receiving Mail
3. Sending Mail
4. Attaching a File to Email
5. Replying to an Email
6. Reply to All
7. Sorting Mail
8. Creating Folders
9. Using Folders
1. Outlook Calendar
2. Calendar Layout
3. Setting Display Style
4. Creating Appointments Using Toolbar
5. Creating Appointments from Calendar
6. Recurring Appointments
7. Inviting Contacts
8. Setting Appointment Reminders
Chapter 5
1. Specific Dates
2. Color-Coding Appointments
3. Deleting an Appointment
4. Printing a Specific Calendar Design
Chapter 6
1. What are Contacts
2. The Contacts Tab
3. Creating a Contact From Toolbar
4. Creating a Contact From Window
5. Entering Contact Information
6. Adding Photos to a Contact Card
7. Choosing a Display
8. Searching for a Contact
9. Deleting a Contact
10. Sorting using the tool bar
Chapter 7
1. What are Tasks?
2. Creating a New Task
3. Task Display Options
4. Recurring Tasks
5. Task Reminders
6. Deleting a Task
Chapter 8
1. What is a Note?
2. Creating a Note from Toolbar
3. Creating a Note
4. Setting Note Color
5. Displaying Notes as Icons
6. Sending Notes to a Contact
7. Deleting a Note
Chapter 9
1. Shortcuts
2. Switching Between Shortcuts
3. Creating a Shortcut
4. Deleting a Shortcut
5. The Journal
6. Creating a Planning Object
7. Arranging Objects
8. Deleting Objects
9. What is the Today Window?
10. Opening the Today Window
PUBLISHER COURSE
CHAPTER 1
General uses of the Publisher
1. What is Publisher
2. Activating Publisher
3. Main screen structure
4. Enlarging the displayed icons
5. Creating a new project
6. Adding a text box the the project
CHAPTER 2
Saving Projects and parallel windows
1. Saving a project
2. The save as... window
3. Open an existing project
4. Working on several windows
5. Watching two together
CHAPTER 3
Exploring and Editing fonts
1. What is a font
2. Changing the font type
3. Adding underline
4. Adding the bold effect
5. Adding italic effect
CHAPTER 4
Editing Text
1. Align and center paragraph
2. Coloring a font
3. Design copy
4. Adding bullets to the text
5. Space between lines
6. Using Auto fit
CHAPTER 5
Creating and Editing Tables
1. Creating a Table
2. Adding columns and rows
3. Deleting rows and columns
4. Typing Data
5. Setting printable grid lines
6. Merge cells
7. Split cells
CHAPTER 6
Options available for adding objects
1. What is an object?
2. Formatting an object
3. Decrease and increase size
4. Object type in AutoShape
5. Formatting an object
6. Grouping objects
7. Ungrouping
8. Bringing an object to the front
9. Sending an object to the back
CHAPTER 7
Exploring the design collection wizard
1. The Publisher Wizard
2. The advertisement category
3. The award certificates
4. The banner category
5. The brochures category
6. Business card category
7. The paper folding category
CHAPTER 8
Adding pages, changing colors and auto correction
1. Adding pages
2. Navigating between pages
3. Using replace action
4. Using Auto Correction
5. Changing the color scheme
6. Using art galleries
7. Saving our designs
8. Changing the fill color
1. Line color change
2. Changing line style
3. Selecting more than one
4. Undo and Redo buttons
5. Adding time and date
6. Adding page numbers
7. Using Publishers Help
WORD COURSE
Chapter 1
1. Word loading
2. Word processors
3. Text movement
4. Marking text with the mouse
5. Marking text with the keyboard
6. Correcting with the keyboard
7. Split and unite a paragraph
Chapter 2
1. UNDO and REDO buttons
2. The office board
3. Saving a document
4. The Save as box
5. Opening a saved document
6. Create a new document
7. Closing a document
Chapter 3
1. Working on several windows
2. Adding a password
3. Sending a document
4. Document Search
5. Document compare
6. Patterns
7. Creating a pattern
Chapter 4
1. The different font types
2. Changing a Font
3. Changing the font size
4. Adding underline
5. Bolding a character
6. Bending letters
7. Aligning and centering
8. The space between the lines
9. Design copy
10. Design choose
11. Style adding
Chapter 5
1. Page numbering
2. Text copy
3. Transferring text
4. Cancel - cancelling an action
5. REDO a canceled action
6. Adding Time and date
7. Spelling check
8. Query Characteristics
9. Automatic spelling
10. Adding a hyper link
Chapter 6
1. Page settings
2. Preview before printing
3. Printing a document
4. Printing envelopes
5. Printing stickers
Chapter 7
1. The Grid lines
2. Creating a table
3. Adding rows and columns
4. Deleting rows and columns
5. Inserting data into the Table
6. Drawing the table lines
7. Table automatic design
Chapter 8
1. Tablatures bar
2. Hidden text
3. Tab
4. Bullets
5. Numbering paragraphs
6. Creating columns
7. Creating an Index
8. Updating the Index
Chapter 9
1. Adding pictures
2. Text search
3. Replace text
4. The Draw menu
5. Merging Documents
6. Text search
7. Adding chart
8. Getting help
9. Showing the title
Chapter 10
1. Adding a Comment
2. Activating change track
3. Authorizing changes
4. Stopping the change track
This 10 chapter Excel tutorial covers the
basic software functions as
providing instructions about how to work with
more advanced tools and techniques featured in the Microsoft Excel. This hands-on interactive training course allows you to progress at your own pace through a step-by-step e-learning program that will truly help you discover professional Excel techniques.
The interactive software training course will give you
experience and knowledge for feeding data, creating tables and building graphs as you quickly learn how to work with formulas to produce well designed and professional looking spreadsheets on the Microsoft Office Excel. This course goes over the different aspects of the Excel as it guides users onward through increasingly complex tasks towards building truly professional financial spreadsheets. After this complete course, you will be capable of creating expert spreadsheets and complex presentations with confidence.
This Advanced Microsoft Excel training tutorial will demonstrate the more powerful and professional applications of the EXCEL in order to develop the experience of Microsoft Excel learners even further. The course discusses formulas, functions, LOOKUPS, database calculations, MACRO, and integrating the calendar to create EXCEL spreadsheets that are both professional and highly functional.
With this Advanced EXCEL
course, you will find out how to set up various calculations as formulas in order to perform different mathematical tasks, and learn to perform different functions using the function wizard that includes hundreds of ready made functions to choose from
Users will learn how to turn practical examples such as store inventories, grades of students or information from a flower shop into spreadsheets that represent and calculate the different relevant calculations based on the provided data.
+ 2 Bonus Interactive
e-Learning Tutorial Training
Courses
The Search Engine e-Learning Course Tutorial goes over the search engine basics and guides users through the different types of web terms and advanced searches that will help develop a more complete understanding of the technical side of search engines like Google and Yahoo.
In this simulated tutorial you will learn how to search for information on the internet using advanced search techniques while discovering some helpful tips and secrets towards getting the best search results.
Internet Search is an interactive tutorial covering the technical side of internet searches, teaching users how to make the most of their search engine queries, and providing plenty of useful background information. Everyone can search the internet, but consistently finding what you are looking for is a different story.
Discover the actual
technical language of web pages with this informative course that covers the basics behind HTML document structure, tags, attributes, elements and headings.
This training guide explores the different aspects of HTML or Hyper Text Mark-up Language, and explains the proper techniques necessary in order to achieve the best results as well as pointing out common mistakes to avoid.
After seeing the examples
for the code given for each explanation, clicking on the Browser View button lets you see the code in action as the specific example is viewed through a new page on your browser. Build and improve your knowledge of HTML and expand your understanding of web technologies as you cover the key features used in coding and follow the list of online examples that are presented with this interactive tutorial.
Frequently Asked Questions - FAQ's
Q:
How do I get it? A: You will be given immediate access to this product via an email with information and links as soon as the payment has been completed
Q: How long does the
subscription last? A: Our training courses have an
UNLIMITED online website
subscription that offers users
access to the tutorial 24/7, with NO
time limit.
Q: What if
I want to receive a CD? A: If you would like to receive a
CD, there is no problem. Just let us
know and we would be happy to send
you an additional invoice for $6.99
including all shipping and handling
charges, and will ship the CD to you
for arrival within 15 working days
to the address that you provide as
soon as we receive your payment.
Q: Can I
use this tutorial on more than one
computer? A: Yes you can. With your
user name and password
you will be able to log in to use
your course on any computer at any
time, 24-7.
Is
Excel something
you want to learn but are unsure how to
begin?
This tutorial gives
a full overview of Microsoft Excel and its
tools and opens doors for new users to be
able to begin building software skills
immediately. With this software training
course you will finally have the opportunity
to analyze types of relevant Excel applications
closely, helping
you to understand the different kinds of
practical possibilities available for
everyday use.
This popular course has
received an endless supply of positive
feedback from users who appreciate the fast
download and the easy to follow informative
tutorials. The user-friendly features and
interface makes this course an excellent way
to finally learn about all of the benefits
that Excel has to offer you.
Take a look at what some of our customers have to say about
our interactive Office courses:
excellent Everything as described.
Thank you A++++++++ fast service - good product
GREAT RESPONSE extremely helpful
Just Perfect-:¦:-•:*'""*:•.-:¦:-•**•-:¦:-•:*'''''*:•-:¦:-THANK YOU
Great value. Thanks Fast delivery a real bargain
Link for download sent straight away and it's really good. Thanks
All our courses are 100%
guaranteed. You have nothing
to lose!
If you feel that you did not
benefit from the course, no hard
feelings. Notify us within 60 days,
and we'll simply give you a full
refund. No questions asked!
No risk, 100% guaranteed quality tutorials
excellent Everything as described.
