Excel Tips and Tricks with Examples
Focused View
4:30:10
147 View
01 Welcome.mp4
00:30
02 Using the exercise files.mp4
00:27
03 Zooming in and out quickly.mp4
02:12
04 Entering data or formulas in non adjacent cells simultaneously.mp4
03:11
05 Copying data or formulas down a column instantly.mp4
04:01
06 Adjusting all or selected column widths or row heights instantly.mp4
03:49
07 Displaying all worksheet formulas instantly.mp4
01:54
08 Instantly enter todays date or time.mp4
02:39
09 Undoing, redoing, and repeating recent actions with keystrokes.mp4
05:49
10 Converting formulas to values with a simple right drag.mp4
04:59
11 Activating formatting tools two quick methods.mp4
02:22
12 Activating paste special features with a keystroke shortcut.mp4
04:06
13 Creating split screens and frozen titles in a flash.mp4
08:59
14 Restoring missing labels and hiding repeating labels.mp4
07:09
15 Navigating between workbooks efficiently.mp4
04:54
16 Moving between worksheets efficiently.mp4
03:25
17 Maneuvering within worksheets.mp4
05:08
18 Selecting a row, column, or worksheet.mp4
06:01
19 Selecting non contiguous ranges and visible cells only.mp4
05:32
20 Selecting current region of cells and moving around region corners.mp4
02:45
21 Accelerating data entry.mp4
07:37
22 Entering dates and date series efficiently.mp4
10:40
23 Entering times and time series efficiently.mp4
06:03
24 Using custom lists for rapid data entry and list based sorting.mp4
07:46
25 Enhancing editing tools.mp4
03:28
26 Using keystroke shortcuts for frquently needed numeric formats.mp4
04:17
27 Accentuating data with alignment tools.mp4
02:37
28 Adding a color background to every fifth row in a range.mp4
04:44
29 Using conditional formatting based on comparison criteria.mp4
02:40
30 Creating custom formats dot leaders and more.mp4
07:52
31 Using special formats for times over 24 hours.mp4
04:40
32 Changing strikethrough and borders with keystroke shortcuts.mp4
03:18
33 Accelerating copy and move tasks.mp4
02:49
34 Copying and moving worksheets quickly.mp4
03:18
35 Dragging and inserting with the Shift key.mp4
02:13
36 Using the right mouse button to copy and paste.mp4
04:40
37 Creating formulas rapidly using row and column references.mp4
03:52
38 Selecting all cells that depend on the active cell.mp4
03:44
39 Selecting all cells that can affect the active cell.mp4
02:35
40 Using AutoSum shortcuts.mp4
03:36
41 Using rounding shortcuts.mp4
04:38
42 Generating random numbers.mp4
06:20
43 Counting the number of unique entries.mp4
04:18
44 Performing calculations without formulas.mp4
02:55
45 Inserting, deleting, hiding, and unhiding columns and rows rapidly.mp4
05:04
46 Adjusting imported text alignment.mp4
03:42
47 Selecting and manipulating blank cells.mp4
05:40
48 Collapsing and expanding detail quickly with outlining shortcuts.mp4
06:03
49 Creating double spaced or triple spaced printouts quickly.mp4
02:33
50 Sorting data on more then one criteria quickly.mp4
02:54
51 Removing spaces quickly to clean up data Like content 9 View 9 likers 365 365 bookmarks.mp4
06:38
52 Identifying and eliminating duplicates.mp4
03:17
53 Ensuring unique entries with data validation rules.mp4
04:40
54 Forcing typed dates to be weekdays only with data validation rules.mp4
05:51
55 Displaying unique items from large lists.mp4
04:01
56 Manipulating chart placement with dragging techniques.mp4
03:32
57 Creating chart titles from cell content.mp4
03:07
58 Creating and manipulating shapes.mp4
06:02
59 Creating linked dynamic and static images.mp4
07:52
60 Become more proficient with these short tips.mp4
08:42
More details
User Reviews
Rating
average 0
Focused display
SkillShare
View courses SkillShareSkillshare is an online learning community based in the United States for people who want to learn from educational videos. The courses, which are not accredited, are only available through paid subscription.
- language english
- Training sessions 60
- duration 4:30:10
- English subtitles has
- Release Date 2023/10/04
