Excel VII Advanced Formulas
Scheduled Dates
| This class is scheduled on an as-needed basis. Please choose an available day and time or call us at (909) 981-6331 for more information. |
Topics Include:
Text And Formatting Functions
- Textjoin
- Text Function
- Join Date And Text
- Join text using =CONCATENATE
- Left/Right/Mid Functions
- Create Email Address With Name And Domain
- Trim/Clean Functions
Lookups And Scenario Functions
- Find/Exact Functions
- Len Function
- Match Function
- Index Function
- Goal Seek
- Using the Function Wizard
- Two-Way Lookup With Index And Match
- Running Count Of Occurrence In List
Formula To Find Duplicate Values In A Data Range - Using A Formula For Data Validation
Sum If Cell Contains Text In Another Cell - How To Make Dependent Dropdown Lists In Excel (Data Validation)
- Prevent Duplicate Entries (Data Validation)
- How To Set Up Dependent Dropdown Lists