X Online Skill Test

Arrange for a Callback

Name   Mobile
Email
Call us at:- +91-9958934646
Go

Create a free profile as



Sample Certificate

international-students
Excel_2007_Essentials.jpg

Excel 2007: Essentials

Indian : Rs.3068
International : $47
INTRODUCTION
This video training series begins with the simplest tasks and progresses to more difficult projects. Along the way, you will pick up tips and tricks of savvy Excel users. If you have ever wanted to learn how to use Excel to create better spreadsheets and improve spreadsheet analysis, now is the time!
OBJECTIVE
Learning to use Microsoft Excel has never been this simple. Our video tutorials quickly and thoroughly walk you step-by-step through all aspects Excel offers.
CONTENT
Lesson I WORKING WITH THE USER INTERFACE 24:54
  • Introducing the Ribbon User Interface
  • Introducing Workbooks & Worksheets
  • Introducing the Formula Bar
  • Saving with Different File Extensions
  • Customizing the User Interface

Lesson II ENTERING & MANAGING DATA 47:06
  • Getting Data into Excel
  • Importing Text Files
  • Using the Freeze Panes Functionality
  • Using the Zoom Functionality
  • Using Hot Keys
  • Managing Rows & Columns
  • Finding Data
  • Matching Case & Entire Cell Contents
  • Replacing Data
  • Finding & Replacing Empty Values
  • Sorting Data
  • Sorting Multiple Columns
  • Filtering Data

Lesson III USING FORMATTING TECHNIQUES 22:45
  • Formatting Numbers & Dates
  • Formatting Cells
  • Setting the Font Type, Color & Size
  • Using Borders & Cell Styles
  • Adding Shapes & Pictures
  • Creating WordArt

Lesson IV FORMULA BASICS 33:52
  • Constants, Formulas & Cell References
  • Understanding the Order of Operations
  • Using Formulas with Dates & Text
  • Linking Cells & Using Comparison Operators
  • Creating an Absolute Reference
  • Defining Named Ranges
  • Exploring the Function Library
  • Using the AutoSum Function

Lesson V USEFUL FUNCTIONS 39:56
  • Using the INT Function
  • Using the Rounding Function
  • Using the ABS Function
  • Using the SUBTotal Function
  • Using Logical Functions
  • Using the AND & the OR Function
  • Using LEFT, RIGHT & MID Functions
  • Using the UPPER, LOWER, PROPER & TRIM Functions
  • Using COUNT Functions
  • Using the VLOOKUP Function

Lesson VI CREATING REPORTS 33:00
  • Creating a Subtotal Report
  • Using Conditional Formatting
  • Creating & Managing Conditions
  • Creating a Chart
  • Refining Charts
  • Using Basic Chart Types

Lesson VII SHARING & DISTRIBUTING YOUR WORK 25:22
  • Inserting Headers & Footers
  • Adding Comments
  • Adjusting Page Layout
  • Distributing Your Worksheets
  • Protecting Your Worksheets
  • Understanding Compatibility

Lesson VIII TIPS & TRICKS 52:55
  • Using the Fill Handle
  • Filling in a Series of Numbers
  • Typing in Multiple Cells at Once
  • Leveraging a Custom List & Transposing a Range
  • Deleting & Inserting Blank Cells
  • Filling Holes in Your Data
  • Getting a List of Unique Records & Parsing Text
  • Rearranging Columns & Linking to Multiple Cells
  • Using Right Mouse Button Drag Options
  • Make Format Painter Persist & Paste Special Formats
  • Formatting Portions of Text & Multiple Sheets
  • Creating Cell Border Effects & Sorting on Color
  • Turning Formulas into Hard Data
  • Copy Formula References & Highlight Formulas
  • Creating Dynamic Charts & Combination Charts
  • Add a Secondary Axis, Average Line & Smooth Line
  • Comparing Data Dynamically with Charts
  • Final Comments & Credits
LENGTH
Total Run Time: 4 hrs 38 min
PRESENTER INFO
Michael Alexander is a Microsoft Certified Application Developer (MCAD) with over 14 years experience consulting and developing office solutions.  Michael started his career in consulting and development at the White House Communications Agency in Washington DC where he spearheaded the development of a standalone HRIS system for the White Houseís Military Office. He parleyed his experience with VBA and VB into a successful consulting practice in the private sector, developing middleware and reporting solutions for a wide variety of industries.  

He currently lives in Frisco, TX where he serves as a Senior Program Manager for a top technology firm.  Michael is the author of several books on Microsoft Access and Excel, and is the principle behind DataPig Technologies where he shares basic Access and Excel tips to the Office community.
Frequently Asked Questions


traingtoatalcrse.png

Total Training

Total Training is a pioneer in innovative online and DVD-based training for leading creative design, digital video, and office productivity software programs.

Ranging from casual hobbyists to the most seasoned professionals, our users quickly learn new software applications and broaden their knowledge of programs currently used. Narrated in an entertaining format by industry experts and leading authors, our video-based software training titles are critical tools for anyone wanting to learn tips, techniques, and best practices from the most respected names in the business.

We currently offer affordable subscriptions to our All-Access Library, which contains hundreds of courses, thousands of clips, and project files so users can follow along.

Hot Courses

Our Partners

×