-67%
Stone River eLearning – Excel Productivity
Work faster and smarter in Excel
Microsoft Excel is the most in demand tool for mining and making sense of data. Anyone that can harness this power will be a sought after employee. If you are running a business, being proficient in Excel can help you see your business in a whole new light.
Leading a team? Boost their efficiency in minutes with this mega packed Excel Productivity course.
Excel Productivity shows you have to work faster and smarter in Excel. You’ll pick up great tips that will make working in Excel a pleasure.
Some of the areas covered include:
- Conditional formatting
- Various types of sorting
- Days and years between dates
- Removing duplicates
- Viewing multiple sheets in a single view
- and more
The best part is that the above list will keep growing with great Excel insider, productivity tips for working smarter and faster.
Course Curriculum
First Section
- Saving/Opening Files & Ribbon Menu (10:23)
- Getting ed With Formulas (7:42)
Formulas
- Formulas Introduction (10:47)
- Concatenate (2:52)
- A Common Multi Column Summation Done Very Quickly (2:28)
- Calculating Time Spans (2:05)
- vlookup Exposed (6:22)
- Phone Numbers (12:45)
Making Your Data Make Sense
- Sorting (6:06)
- Removing Duplicates (3:44)
- Conditional Formatting (7:51)
- How Does Excel Know Which Data Format To Choose? (3:35)
- Updating an Existing Chart’s Data Source (4:42)
Productivity 10x Features
- Quick Analysis (3:15)
- Multi-Sheet View (3:59)
- Freezing Panes (4:17)
Ninja Shortcuts
- Power of the Alt Key (3:57)
- Selecting Only Relevant Data (3:46)
- Shortcut Keys (2:35)
- Shortcut Key Listing
- Locking Cells & Showing All Formulas (4:13)
Excel Overdrive
- Create an Organizational Chart Fast (then add it to PowerPoint) (3:26)
- Building A Functional Database (project file attached) (6:42)
Customizing Your Workspace
- Hiding/Unhiding Single And Multiple Columns (3:19)
- Coloring Tabs For Better Grouping (2:57)
Extending Excel
- Solving Complex Problems Easily (project file attached) (11:23)
- Sourcing Data Directly From The FED Into Excel (7:07)
- Power Query (8:22)
Be the first to review “Stone River eLearning – Excel Productivity”
Related products
-94%
Business & Marketing
17.00$
-92%
Business & Marketing
249.00$
-68%
Business & Marketing
8.00$
-68%
Business & Marketing
8.00$
-68%
Business & Marketing
8.00$
Business & Marketing
12.00$
-84%
Business & Marketing
24.00$
-94%
Business & Marketing
96.00$
Reviews
There are no reviews yet.