This course provides competency in creating absolute formulas, formulas & range names, combining and splitting formulas, text formulas, date and time formulas, referencing cells on other sheets, or other files, auditing, goal seeking and array formulas.
- Course Outline
This course provides competency in creating absolute formulas, formulas and range names, manipulating formulas, combining and splitting formulas, text formulas, date and time formulas, referencing cells on other sheets, or other files, auditing, goal seeking and array formulas.
Course Outline SECTION 1: Working with Functions and Formulas Lesson 1.1
Using Formulas in Excel
Understanding Relative and Absolute Cell References
The Basic Mathematical Operators
Using Formulas with Multiple Cell References
The Formula Auditing Bar
Fixing Formula Errors
Displaying and Printing Formulas
Exploring Excel Functions
What are Functions?
Finding the right function
Some Useful and Simple functions
Using Functions in Excel
Using Functions and AutoFill to Perform Difficult Calculations
Using the IF Function
Working with Nested Functions
Working with Names and Ranges
What Are Range Names?
Defining and using range names
Selecting Nonadjacent Ranges
What is Auto Calculate?
Working with Array Formulas
What are Array Formulas
Using Basic Array Formulas
Using Functions with Array Formulas
Using the IF function in Array Formulas
SECTION 2: Managing Lists Lesson 2.1
Working with Lists
What is a list?
What is the Total row?
Working with Records and Fields
What are Records and fields?
Adding fields by inserting Columns
Adding Records by Inserting Rows
Adding Records with a Data Form
Finding and Deleting Records
Working with Lists and Filters
Sorting a List
What is an AutoFilter?
Using an Advanced Filter
Copying Filtered Records
Using Excel as a Database
Filtering with Wild Card Characters
Validating Your Data
What are Database functions?
What are Lookup functions?
SECTION 3: Working With Macros and Controls Lesson 3.1
Creating Macros in Excel
What is a Macro?
Creating a Macro
Playing a Macro
Assigning a Shortcut Key to Macro
Macros, Buttons, and toolbars
Excel Form Controls
What is a Form Control?
The Form Toolbar
Adding a control to a Worksheet
Assigning a macro to a control
Using form controls
SECTION 4: Workbook Management Lesson 4.1
Using Excel in Word
Inserting Excel Data in Word
Modifying Excel Data after Insertion
Linking Excel Data in Word
Linking an Excel Chart in word
Using Excel with Other Programs and Files
Using Outlook to Send Excel Data
Opening an Excel File in a Different Format
Importing Data from a Text file
Importing Data from a Database
- Prerequisites & Certificates
Certificate of completion
- Cancellation Policy
Commitment of resources and industry standards require that we be notified of any cancellation. As such, you may reschedule any training course up to five (5) working days before the actual training date. Simply call us, and we send you a new registration confirmation without extra charge. If training is rescheduled less than five (5) working days before the training date, a rescheduling fee of 50% of the course fee will be invoiced.
The latest time we accept rescheduling is until noon on the working day before
the training date. "No-shows" without prior notification are charged as if you had attended the course. There are no refunds. We reserve the right to cancel any course and reschedule if attendance is not sufficient to run the course. In this case you will be notified, usually five (5) working days or more prior to the
training day and the training is rescheduled.
- Map & Reviews
Careers in Transition
[ View Provider's Profile ]
This course has not yet been rated by one of our members.
If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.
This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.
This page has been viewed 282 times.