Excel Intermediate
- Excel Intermediate Formulas and Functions
- Multiple Worksheet Techniques in Excel
- Using Excel As a Database
- Using Excel to Create Forms & Templates
Excel Intermediate Formulas and Functions
Go beyond your basic Formulas and Functions to add more power and flexibly to your spreadsheets. We will explore how to set-up and use several of the more complicated formulas and functions.
-
Learn to create a 3D Formula and Summary
-
Learn to name Cells and Ranges for use in Formulas
-
Learn the power of using the IF statement
-
Learn how to nest formulas and functions for more complex calculations
-
And More
Multiple Worksheet Techniques in Excel
Excel has the capacity to store multiple worksheets in one workbook, but most people don’t know how to effectively use multiple worksheets. Learn the tricks to store and summarize data on multiple sheets saving you time and effort.
-
Learn how to link different worksheets and different workbooks
-
Learn how to set up your spreadsheet effectively for multiple sheet use
-
Learn how to rename your sheets
-
Learn to copy, move and uses template with in your spreadsheet
-
Learn how to make changes on multiple worksheets at the same time.
-
Learn how to consolidate your data and create a summary page.
-
And more…
Using Excel As a Database
There is an art to creating an effective Database in Excel. You must know how to setup an Excel Database correctly in order to use all its amazing time saving features. When setup properly you can also use this database with Word Mail Merge or interface it with other database programs such as Microsoft Access.
-
Learn the proper way to create and setup an effective Excel Database
-
Learn how to clean up your data and separate text into columns
-
Learn how to use Data Forms to easily enter and view your data
-
Learn how to properly sort your data
-
Learn how to use the Auto Filter to report specific information
-
And More…
Using Excel to Create Forms & Templates
Do you have a timesheet, an expense report, an invoice, an order form that you use over and over again? Would you like to know how to create professional looking forms from scratch and protect specific fields from being changed or modified?
-
Learn to create professional looking forms from scratch
- Learn how to “idiot proof” your forms and protect them from unwanted changes.
- Understand the trick to creating a form for both easy data entry and database entry.
- Learn to structure and format your forms for ease of use.
- Learn to create drop down lists and limit values in a cell
- And more…