Excel 2007 Essential Training [CD-ROM]

Lorna Daly (Author)

Book Description

Publication Date: February 8, 2007

Like the other applications in Microsoft Office 2007, Excel 2007 boasts upgraded features and a brand-new look. In Excel 2007 Essential Training, instructor Lorna A. Daly introduces the new version in detail. The training begins with the essentials of using the program, including how and why to use a spreadsheet, how to set up and modify worksheets, and how to import and export data. Lorna then moves on to teach more advanced features, such as working with functions and macros. Exercise files accompany the tutorials.

Topics Include:

• Understanding spreadsheets
• Navigating the Excel 2007 interface
• Creating and saving documents
• Formatting tables
• Using templates, styles, and
• AutoFormat Proofing and commenting on worksheets
• Adding themes to worksheets
• Manipulating screen layouts
• Importing and exporting data
• Working with formulas and functions
• Designing and creating charts
• Improving spreadsheet workflow

Duration: 5.25 hours
On 1 CD-ROM

Editorial Reviews

From the Publisher

Each lynda.com CD/DVD course offers hours of training movies that you watch on your computer. The movies are recorded in pixel-perfect quality, and include the authors' narration and movements as they teach the subject matter. lynda.com tutorials are great for visual learners and people who like to learn by doing. Topics include software applications, workflow optimization, tips and techniques, and much more. Play, fast-forward, and rewind for easy learning.

About the Author

Lorna Daly has been in the training field for 16 years, educating students on everything from computer basics to the technicalities of working with Excel. She loves witnessing the "ah-ha" moment in her students, when they finally grasp a concept. She looks forward to sharing her passion for computers with a new group of learners. Lorna has a bachelor of commerce degree and a B.A. in education. Her lessons incorporate a blend of real-life experience and sound learning principles.

Product Details

• CD-ROM
• Publisher: lynda.com, Inc (February 8, 2007)
• Language: English
• ISBN-10: 1596713127
• ISBN-13: 978-1596713123
• Product Dimensions: 7.6 x 5.3 x 0.8 inches
• Shipping Weight: 3.2 ounces (View shipping rates and policies)
• Average Customer Review: 3.5 out of 5 stars  See all reviews (2 customer reviews)
• Amazon Best Sellers Rank: #2,066,235 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

2 of 2 people found the following review helpful:

5.0 out of 5 stars excel tutorial, July 17, 2008

By 

enchanted walker (alamogordo, nm) - See all my reviews

Amazon Verified Purchase

This review is from: Excel 2007 Essential Training (CD-ROM)

if you want to excel at Excel then this is a must. easy to follow directions and you will be developing spreadsheets like a professional. really helps you to navigate the new menu and ribbon bars.

2.0 out of 5 stars Should Be Called, Essential Formatting for Intermediate Users, February 25, 2010

By 

S. Chan - See all my reviews
(REAL NAME)   

This review is from: Excel 2007 Essential Training (CD-ROM)

This [...] course is not for anyone like me who is an absolute beginner with spreadsheets and excel.

As a small business owner starting from scratch, I wanted to know how to use Excel for accounting purposes. I expected the course to start with a brief overview of what a spreadsheet is, a look at the interface, followed by starting my first spreadsheet from scratch with examples of the types of data that could be entered using the most common scenarios such as a simple a table of income and expenses. Instead, the course merely says spreadsheets are like tables in Word except you can do math on the numbers, followed by a jump right into the formatting of the data.

I know to many people who've used Excel, it may seem obvious to you how to enter data into the cells, but not to a complete newbie. The course jumps from the interface intro, to opening a sample spreadsheet and showing how the cells can be resized and fonts reformatted. That's fine, but how do I enter that data into the cells? An enormous amount of time is spent on formatting.

There should have been an entire chapter outlining how data is entered and grouped into the cells, before discussing how to format the data. To most people who use Excel, formatting is the last step, not the first.

I hate to admit it, because I find the instructors sometimes incoherent, but Total Training is a better series. Total Training has a more natural and expected flow starting from the beginning and building on new concepts as they become effective/required. Lately, the videos from [...] have been too quick in their jumps from concepts to concepts, with far too much backtracking and lack of forward explanation. eg, "drag this here, and I'll explain where you're dragging into a few chapters later"