Excel Productivity from Stone River eLearning

Excel Productivity from Stone River eLearning

Sale Page

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

Get immediately download Excel Productivity from Stone River eLearning

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)

Get immediately download Excel Productivity from Stone River eLearning