26 hours ago: New Feature: you can now upload your Profile Picture to the site. Check it out!  Dismiss
 
Excel 2010-2019
Excel 2007
Excel 2003
Tips & Tricks
Excel Forum
Course Index CIG Excel Book
 
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
 
 
 

< Previous: Excel Beginner 5

Next: Excel Expert 2 >

Excel Expert Level 1
Microsoft Excel Expert Tutorial - 68 Minutes

 
 
This is the first class in our Excel 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 Expert Level 1
Description: Excel Expert Level 1
Versions: Microsoft Office Excel
Pre-Requisites: Excel Beginner Level 5
Running Time: 68 Minutes
Cost: $9.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. 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 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 tutorial, microsoft office excel tutorial, microsoft excel 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
 
 

 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 3/18/2024 11:52:31 PM. PLT: 1s