30 Minutes (MS Office)
Excel in 30 Minutes – working with Text & Math functions
- Splitting cells with the LEFT, RIGHT, and MID functions
- Splitting cells with the Text to Columns feature
- Combining two or more cells using the CONCAT function
28m
0
0
Excel in 30 Minutes- Working with Logical Functionss
- Using the IF function to perform a logical test
- Using AND and OR functions to perform multiple logical tests
- Using SUMIF, COUNTIF, and AVERAGEIF to summarize data using a single criterion
32m
0
0
Excel in 30 Minutes- Working with Date Functions
- Using TODAY, NETWORKDAYS, and other Date formulas and functions to calculate the difference between two dates
- Using EDATE, WORKDAY, and other Date formulas and functions to calculate a past or future date
- Using functions such as MONTH, YEAR, and WEEKDAY to get information about a date
22m
0
0
Excel in 30 Minutes- Using Named Ranges
- Referencing a Named Range in a formula
- Creating and modifying Named Ranges using the Ribbon and the Name Manager
16h
0
0
Word in 30 Minutes – Navigating and Creating documents
- Navigating in Microsoft Word
- Creating and saving documents
- Saving revised documents
30m
0
0
Word in 30 Minutes- Adding text, printing and customizing
- Selecting text
- Copying and moving text
- Editing paragraphs
24m
0
0
Word in 30 Minutes – Formatting Text
- Applying character formatting
- Controlling paragraph layout
- Indenting paragraphs
35m
0
0
Word in 30 Minutes – Working Efficiently
- Using Find and Replace
- Applying repetitive formatting
- Using Styles
20m
0
0
Word in 30 Minutes – Creating list and Tables
- Sorting lists
- Formatting lists
- Resequencing lists
26m
0
0
Word in 30 Minutes – Graphics and Page Appearance
- Inserting symbols
- Adding images
- Formatting pages
33m
0
0
Word in 30 Minutes – Preparing to Publish
- Checking grammar and readability
- Using research tools
- Checking accessibility
23m
0
0