Warning: mysqli::mysqli() [mysqli.mysqli]: Headers and client library minor version mismatch. Headers:50642 Library:50173 in /usr/www/users/excelish/teachmsoffice/includes/connect/connect.php on line 9
Formulas and Functions Basic Introduction - Microsoft Office Video Tutorials & Training - Excel, Word, PowerPoint - Teachmsoffice.com
Teach Microsoft Office
Online Video Tutorials for Microsoft Office
Request Tutorial
Excel Help and Consulting
Video Player Demo
User Testimonials
Easy to Follow and Great Content
Awesome tutorials. This is great work; thanks a lot for all of these tutorials, and at a great price. The tutorials are easy to follow and understand and are very valuable for me. Teachmsoffice.com has helped me a lot in terms of increasing my Excel skills and learning how to master Excel. Keep up the good work!
- Sarah M.

Thank you so much!
Thank you so much! My professor was giving me a hard time with this...so I told him I will just figure it out on my own and this site really helped me figure everything out!!
- Ms. R

Thank you and godbless
My text book really sucks and I'm very thankful that you have all of these tutorials. I finished my last two questions because of your site! Thank you and godbless.
- Rob V.

Amazing Videos
Just wanted to say that your videos are amazing. I'm watching them and they really help me understand. The way you explain and go through everything is amazing. Thank you soo much!
- Design X

Saved a Ton of Time!
You have just saved me so much time, I cannot thank you enough!
- L. J.

Thank You!
Thank you for sharing these important tips. Your voice is clear and the steps are clear. It is easy to follow. Thank you!
- Kent

Saved Me Time
Thanks for the tutorials, I never had to do this before today and I needed it done very quickly. These videos saved me time I didn't have!
- Mitchel S.

Thank You!
Thank you! Helped me so much!
- M. Clean

Excellent Tutor
I was just listening to the tutorial online and I must say that the tutor is doing an excellent job.
- D. B.

Sign Up to View Tutorials
Purchase Subscription

Formulas and Functions Basic Introduction

This is an introduction to using formulas and functions in Excel. This tutorial assumes little to no prior knowledge of formulas or functions and serves as a walkthrough of how to use formulas and functions. This tutorial covers these topics related to formulas and functions: what’s required to enter them into cells; math operators for formulas; using arguments with functions, different types of functions; locating functions; searching for functions; using Excel to help you enter complicated or new functions; and more. This is a great tutorial for those just starting out in Excel.
Tutorial Length (mm:ss): 17:04
Sign Up to View Tutorials
Purchase Subscription
Downloadable Files: Yes
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training beginner introduction formulas functions formula bar basic insert function help arguments locate
Bookmark and Share
View All Tutorials - 375 Tutorials - 36 hours 28 minutes of Content
Similar Tutorials
Tutorial Length
(mm:ss)
Office Program
Introduction to the Main Features and Benefits of Excel 13:46 Microsoft Office Excel
Enter Data Numbers and Lists into Excel 13:05 Microsoft Office Excel
Insert Remove and Resize Rows Columns and Cells - Organizing Data in Excel 11:15 Microsoft Office Excel
Formatting in Excel - Overview and Introduction 12:40 Microsoft Office Excel
Format Data as a Table - Introduction 7:57 Microsoft Office Excel
Autosum - Easily Add Average and Count Numbers 5:36 Microsoft Office Excel
Formulas and Functions Basic Introduction 17:04 Microsoft Office Excel
Charts and Graphs Introduction 11:52 Microsoft Office Excel
Add Worksheets and Edit Tab Names and Colors 4:35 Microsoft Office Excel
Add PreBuilt Customized Worksheets 3:41 Microsoft Office Excel
Open and Use Old Workbooks in Excel 2007 4:02 Microsoft Office Excel
Convert Old Workbooks to Excels New Format 3:39 Microsoft Office Excel
Open Workbooks that Contain Macros 4:36 Microsoft Office Excel
Save Excel Workbooks in Different File Formats 7:27 Microsoft Office Excel
Printing in Excel Introduction and Feature Overview 11:20 Microsoft Office Excel
Introduction to Excel (2007) 15:57 Microsoft Office Excel
Formulas and Functions Basic Introduction 17:04 Microsoft Office Excel
Create Your First Formula in Excel 7:38 Microsoft Office Excel
Formula Operators and the Order of Operations 7:32 Microsoft Office Excel
Link Cells - Get Values from Other Cells 4:10 Microsoft Office Excel
The Formula Bar 5:14 Microsoft Office Excel
Difference Between Formulas and Functions 4:38 Microsoft Office Excel
Use Your First Function in Excel 9:53 Microsoft Office Excel
Formulas Tab - Quick Access to Functions 4:46 Microsoft Office Excel
Easily Insert Complicated Functions in Excel 6:26 Microsoft Office Excel
Search Excel for a Function 4:11 Microsoft Office Excel
Use Formulas with Functions 6:27 Microsoft Office Excel
Absolute and Relative Cell References - Copying Formulas and Functions 8:34 Microsoft Office Excel
Proper Function Usage - Separate Variables 4:27 Microsoft Office Excel
Introduction to the Main Features and Benefits of Excel 13:46 Microsoft Office Excel
Enter Data Numbers and Lists into Excel 13:05 Microsoft Office Excel
Formatting in Excel - Overview and Introduction 12:40 Microsoft Office Excel
Insert Remove and Resize Rows Columns and Cells - Organizing Data in Excel 11:15 Microsoft Office Excel
Autosum - Easily Add Average and Count Numbers 5:36 Microsoft Office Excel
Format Data as a Table - Introduction 7:57 Microsoft Office Excel
Formulas and Functions Basic Introduction 17:04 Microsoft Office Excel
Charts and Graphs Introduction 11:52 Microsoft Office Excel
Printing in Excel Introduction and Feature Overview 11:20 Microsoft Office Excel
Add Worksheets and Edit Tab Names and Colors 4:35 Microsoft Office Excel
Add PreBuilt Customized Worksheets 3:41 Microsoft Office Excel
Save Excel Workbooks in Different File Formats 7:27 Microsoft Office Excel
Open Workbooks that Contain Macros 4:36 Microsoft Office Excel
Open and Use Old Workbooks in Excel 2007 4:02 Microsoft Office Excel
Convert Old Workbooks to Excels New Format 3:39 Microsoft Office Excel
Create Your First Formula in Excel 7:38 Microsoft Office Excel
Introduction to Excel (2007) 15:57 Microsoft Office Excel
Create Your First Chart in Excel 12:05 Microsoft Office Excel


This tutorial provides an introduction to adding, editing, and using charts and graphs in Excel 2007. This includes the three main ways to add charts to your workbooks and worksheets, including two keyboard shortcuts, and an overview of how to use the three chart editing tabs that appear after you add a chart or graph in Excel 2007. Some of the topics covered include how to change the chart type, remove elements from the chart, change the chart title, and adding some basic effects and formatting to charts.
Tutorial Length (mm:ss): 11:52
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training charts graphs introduction overview basic beginner tabs move resize create edit
Learn how to add, remove, move, rename, and edit worksheets and tabs in Excel 2007. This tutorial shows you how to better organize the worksheets within a workbook in Excel. This includes how to move worksheet tabs and how to create groupings of tabs using different colors for different tabs.
Tutorial Length (mm:ss): 4:35
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training worksheets tabs delete add remove color organize edit excel 2007
Learn how to very quickly add pre-made worksheets and workbooks into Excel. This feature allows you to get workbook and worksheet templates for items such as expense reports, time sheets, calendars, budgets, and much more. Using this feature can save you a lot of time and provide a good jumping-off point for you when you are creating your own forms or worksheets in Excel. Note that these workbooks and worksheets, though opened through Excel, are downloaded from the internet and so do require an active internet connection.
Tutorial Length (mm:ss): 3:41
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training quickly add custom pre built made workbooks worksheets calendar reports
Learn the limitations of opening and using old Excel files in Excel 2007. This tutorial also includes a brief overview of the compatibility mode in Excel 2007 and some of the new features that are not compatible with older versions of Excel. As well, there is a brief mention of how to convert an old Excel file to a new Excel file format.
Tutorial Length (mm:ss): 4:02
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training open old workbooks compatibility mode limits
Learn how to convert your old workbooks to the new Excel 2007 workbook file format. This tutorial shows you two different ways to make this conversion. One way simply converts the current file into the new file format while the other way shown in the tutorial leaves the original file intact, similar to a backup copy, while creating a new file for you in the new Excel 2007 file format. Converting to the new file format will allow you to access, use, and save all of the new features and functions available in Excel 2007 in your workbook.
Tutorial Length (mm:ss): 3:39
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training convert save as previous versions excel new old workbooks file format
Learn what workbooks with macros look like for Excel 2007 and how to open these workbooks as well as enable or disable the macros within the workbook. Also, this tutorial shows you how to change the default security settings so that macros are always enabled, always disabled, or something in-between. This is a great tutorial for people just learning about and how to use macros in Excel.
Tutorial Length (mm:ss): 4:36
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training open workbook with macro security settings enable disable
This tutorial shows you how to save Excel workbooks in many different file formats and how to check if the file will be compatible with previous versions of Excel. The file formats covered in this tutorial include PDF, Excel 97-2003, and Macro Enabled Workbooks. These are the most commonly used file formats outside of the new Excel 2007 workbook format.
Tutorial Length (mm:ss): 7:27
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training save excel workbook file format different previous version pdf macro enabled compatibility checker
This is a comprehensive introduction and overview of the printing features in Excel. This tutorial shows you how to print selections of text, specific worksheets, multiple worksheets, and an entire workbook. Also, you will learn about some other printing features including: how to use the new Page Layout view; how to use print preview to check documents before you print them; how to add headers and footers to pages; how to print title on every page; how to scale data to fit on one page; and a few other printing features. This tutorial does not cover every printing option but it does offer a comprehensive overview of what is available in terms of printing options and features in Excel and how to use many of those options.
Tutorial Length (mm:ss): 11:20
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training printing print overview introduction comprehensive worksheets workbook page setup page layout selections header footer
This tutorial provides an introduction to adding, editing, and using charts and graphs in Excel 2007. This includes the three main ways to add charts to your workbooks and worksheets, including two keyboard shortcuts, and an overview of how to use the three chart editing tabs that appear after you add a chart or graph in Excel 2007. Some of the topics covered include how to change the chart type, remove elements from the chart, change the chart title, and adding some basic effects and formatting to charts.
Tutorial Length (mm:ss): 11:52
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training charts graphs introduction overview basic beginner tabs move resize create edit
This is a comprehensive introduction and overview of the printing features in Excel. This tutorial shows you how to print selections of text, specific worksheets, multiple worksheets, and an entire workbook. Also, you will learn about some other printing features including: how to use the new Page Layout view; how to use print preview to check documents before you print them; how to add headers and footers to pages; how to print title on every page; how to scale data to fit on one page; and a few other printing features. This tutorial does not cover every printing option but it does offer a comprehensive overview of what is available in terms of printing options and features in Excel and how to use many of those options.
Tutorial Length (mm:ss): 11:20
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training printing print overview introduction comprehensive worksheets workbook page setup page layout selections header footer
Learn how to add, remove, move, rename, and edit worksheets and tabs in Excel 2007. This tutorial shows you how to better organize the worksheets within a workbook in Excel. This includes how to move worksheet tabs and how to create groupings of tabs using different colors for different tabs.
Tutorial Length (mm:ss): 4:35
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training worksheets tabs delete add remove color organize edit excel 2007
Learn how to very quickly add pre-made worksheets and workbooks into Excel. This feature allows you to get workbook and worksheet templates for items such as expense reports, time sheets, calendars, budgets, and much more. Using this feature can save you a lot of time and provide a good jumping-off point for you when you are creating your own forms or worksheets in Excel. Note that these workbooks and worksheets, though opened through Excel, are downloaded from the internet and so do require an active internet connection.
Tutorial Length (mm:ss): 3:41
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training quickly add custom pre built made workbooks worksheets calendar reports
This tutorial shows you how to save Excel workbooks in many different file formats and how to check if the file will be compatible with previous versions of Excel. The file formats covered in this tutorial include PDF, Excel 97-2003, and Macro Enabled Workbooks. These are the most commonly used file formats outside of the new Excel 2007 workbook format.
Tutorial Length (mm:ss): 7:27
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training save excel workbook file format different previous version pdf macro enabled compatibility checker
Learn what workbooks with macros look like for Excel 2007 and how to open these workbooks as well as enable or disable the macros within the workbook. Also, this tutorial shows you how to change the default security settings so that macros are always enabled, always disabled, or something in-between. This is a great tutorial for people just learning about and how to use macros in Excel.
Tutorial Length (mm:ss): 4:36
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training open workbook with macro security settings enable disable
Learn the limitations of opening and using old Excel files in Excel 2007. This tutorial also includes a brief overview of the compatibility mode in Excel 2007 and some of the new features that are not compatible with older versions of Excel. As well, there is a brief mention of how to convert an old Excel file to a new Excel file format.
Tutorial Length (mm:ss): 4:02
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training open old workbooks compatibility mode limits
Learn how to convert your old workbooks to the new Excel 2007 workbook file format. This tutorial shows you two different ways to make this conversion. One way simply converts the current file into the new file format while the other way shown in the tutorial leaves the original file intact, similar to a backup copy, while creating a new file for you in the new Excel 2007 file format. Converting to the new file format will allow you to access, use, and save all of the new features and functions available in Excel 2007 in your workbook.
Tutorial Length (mm:ss): 3:39
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training convert save as previous versions excel new old workbooks file format
 
Official PayPal Seal SSL
Join TeachMsOffice.com on Facebook
Follow TeachMsOffice.com on Twitter


Microsoft Office Tutorials | Office Tutorials - Excel Word PowerPoint | HD Tutorial Video Player Overview | About TeachMsOffice.com

TeachMsOffice.com provides HD Online Video Tutorials and Training for Microsoft Office programs such as Excel, Word, and PowerPoint. We use a specialized video player interface to teach a vast list of Microsoft Office Tutorials and we add new tutorials on a weekly or monthly basis.