Excel 2010-2019 Excel 2007 Excel 2003 Tips & Tricks Excel Forum Course Index CIG Excel Book

 Home   News   Courses   Seminars   Templates   Help   TechHelp   Forums   Order   Contact   Logon More... What's New? Tips & Tricks Access Index Access Tips Excel Index Excel Tips Waiting List

 < Previous: Excel Beginner 5 Next: Excel Expert 2 >

Excel 2010 Expert Level 1
Microsoft Excel Expert Tutorial - 68 Minutes

This is the first class in our Excel 2010 Expert Series. It picks up where the Beginner series left off. You will learn more about working with functions and formulas, including:

 - Ways to Enter Functions & Formulas   - Relative vs. Absolute References   - Named Cells & Ranges  - Referencing Values on Other Sheets  - Creating a Summary Info Sheet  - Text Functions  - Exact, Concatenate, Left, Right, Mid  - Find, Search, Substitute, Replace, and more! Order Now

If you would like a preview of what's covered in this class,
click here to watch the first lesson of this course (free of charge), or scroll down for more information.

Excel 2010 Expert Level 1
 Description: Excel 2010 Expert Level 1 Versions: Microsoft Office Excel 2010 Pre-Requisites: Running Time: 68 Minutes Cost: \$19.99

This course is for the expert user who has good experience with Microsoft Excel or has completed the five courses in our Beginner Series. This course will teach you more about working with functions and formulas. We'll start out by learning about the different function libraries, multiple ways to create functions, the AutoSum and Insert Function buttons, and how to perform string concatenation.

Next, we'll learn about relative vs. absolute references, why they're important, and when you should use them. You'll see how absolute references behave when data is copied or you use the AutoFill function. We'll calculate sales tax using an absolute reference.

You will then learn how to create Named Cells and Named Ranges. These are handy so you don't have to keep remembering which cell a particular value is in. You'll learn how to use the Name Manager, and see how you can quickly jump around between your defined named cells - a great technique for working with large, complicated sheets.

You will learn how to refer to values on other sheets. This way you can share data between the various sheets in your workbook. You will learn about proper Sheet!Cell notation. You will learn how to use Copy > Paste Link to quickly create links between your spreadsheet data. We'll use all of these techniques to build a sales summary sheet.

The previous lessons were to prepare you for working with formulas in functions in Excel. Over the next couple of course levels, we'll be examining most of the popular functions in Excel. In today's class, we'll begin by looking at the functions to manipulate and work with text.

We'll start out by learning: EXACT, CONCATENATE, LEN, LEFT, RIGHT, MID, FIND, and SEARCH. We'll use these functions to separate the first name and last name from a column of cells where the user has entered them together.

Finally, we'll cover the functions SUBSTITUTE, REPLACE, and TRIM. You'll see how to use these functions to make replacements of text inside of cells.

Again, this is the perfect class for anyone who wants to enhance their skills with Microsoft Excel 2010. If you have been working with Excel for a while and want to increase your knowledge of Excel functions and formulas, then this is the perfect class to start with. You should have good working knowledge of the basics of Excel, as taught in my Beginner series. You should also know how to use some of the simple functions, like SUM and AVERAGE.

Of course, if you have any questions about whether or not this class is for you, please contact me.

Complete Outline - Excel 2010 Expert Level 1

 00. Intro (7:20) 01. Working With Functions (10:06) Typing in a function Function library Grouped categories of functions AutoSum button Changing the AutoSum function Insert Function dialog CONCATENATE function Argument Select Buttons Concatenate with the & sign 02. Relative v Absolute References (8:53) What is an Absolute Reference? What is a Relative Reference? Reference behavior with AutoFill Sales Tax Rate example F4 keyboard trick 03. Named Cells and Ranges (7:03) What is a Named Cell Create a Name with the Name Box Jump to a Named Cell Define Name button Name Manager Edit, Delete Names Create a Named Range Named Range example with SUM 04. Values on Other Sheets (10:05) Refer to a Cell on Another Sheet =SheetName!CellName Moving a Named Cell Copy, Paste Link Creating a Summary Sheet 05. Text Functions 1 (14:10) Checking if Two Strings are Equal =A1=B1 EXACT CONCATENATE =A1&B1 LEN LEFT RIGHT MID FIND Separate First and Last Names SEARCH 06. Text Functions 2 (6:23) SUBSTITUTE REPLACE TRIM 07. Review (4:27)

Keywords: microsoft excel tutorial, microsoft excel 2010 tutorial, microsoft office excel 2010 tutorial, microsoft excel 2010 training, function, function library, autosum, relative, absolute, reference, sales tax, named cell, named range, define name, name manager, value on another sheet, paste link, summary sheet, exact, concatenate, text functions, len, left, right, mid, find, search, substitute, replace, trim

 You may want to read these articles from the 599CD News:
 8/18/2020 Excel Expert 11 Lessons 8/17/2020 Excel Courses 8/17/2020 Excel Expert Courses 8/15/2020 Excel 2010 Beginner 1 8/14/2020 Excel XLOOKUP Function 8/14/2020 Excel Worksheet Change VBA 8/14/2020 Excel TechHelp 7/27/2020 How to Get Microsoft Excel for Free 5/25/2020 Excel Expert 11 5/20/2020 Excel My Name is Richard

 Learn  Access - index Excel - index Word - index Windows - index PowerPoint - index Photoshop - index Visual Basic - index ASP - index Seminars More... Customers  Account Login Online Theater Downloads Lost Password Free Upgrades Insider Circle Student Databases Change Email Info  Latest News New Releases User Forums Topic Glossary Tips & Tricks Articles Search The Site Waiting List Production Schedule Code Vault Collapse Menus Help  Live Chat Customer Support WalkThru Tutorials Troubleshooting FAQs TechHelp Consulting Services About  Background Testimonials Jobs Affiliate Program Richard Rost Free Lessons Mailing List Order  Video Tutorials Handbooks MYOLP Memberships Learning Connection Idiot's Guide to Excel Volume Discounts Payment Info Shipping Terms of Sale Contact  Live Chat General Info Support Policy Contact Form Email Richard Mailing Address Phone Number Fax Number Course Survey