Excel EZ
11.7K views | +0 today
Follow
Excel EZ
Promote Excel as an easy-to-use useful tool.
Curated by Roger Fisher
Your new post is loading...
Your new post is loading...
Scooped by Roger Fisher
Scoop.it!

Pro tip: Use Excel's conditional formatting to highlight invalid dates - TechRepublic

Pro tip: Use Excel's conditional formatting to highlight invalid dates - TechRepublic | Excel EZ | Scoop.it
Susan Harkins shows you how to visually identify invalid dates using Excel's conditional formatting feature.
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

PPC Excel Shortcuts You’ll Never Want to Forget | PPC Hero

That’s why we have Hanapin experts Briann Saxman and Mike Matta here to tell you, in just one webinar, all the PPC Excel tricks you need to know. Now the
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

VLOOKUP and HLOOKUP in Microsoft Excel

VLOOKUP and HLOOKUP in Microsoft Excel ********************************************* THANK YOU FOR VISITING MY CHANNEL Excel Online Academy provide
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

How to Use IF formula in Microsoft Excel | #2

This is the Microsoft Excel Tutorial where I'm teaching How to use the Basic IF Function. If Function helps you compare 2 columns and return True or Fals
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

Using a class seat randomizer with Excel V2.5

https://goo.gl/ICQlYo Hey there mates, i just got my latest hack finally done and ready to try and made public! Hope you may like this new version ove
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

Excel: Gorgeous Graphs

Plotting Scatter Graphs - Titles: Graph and Axes - Axes: Scale, Labels, Tick Marks, Numbers - Markers: Size, fill, type - Gridlines: Number, format Re-usin
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

Improve decision-making with Business Analytics in Microsoft Excel 2016

Learn how to more efficiently gather, transform, and analyze data using Microsoft Excel 2016 business analytics capabilities that identify important trend
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

How many formulas should you learn? [Weekend Poll]

How many formulas should you learn? [Weekend Poll] | Excel EZ | Scoop.it
Over at twitter, @for_the_moves asks, @For_the_moves Same as growing your vocabulary. Remember, words (or functions) = ideas. the more you know, the better you
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

The Excel VBA Programming Tutorial for Beginners

The Excel VBA Programming Tutorial for Beginners | Excel EZ | Scoop.it
VBA is a Microsoft Office power tool. You can use it to automate tasks with macros, set triggers, and lots more. We'll introduce you to Excel visual basic programming with a simple project.
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

11 Essential Tips for Effective Data Collection

11 Essential Tips for Effective Data Collection | Excel EZ | Scoop.it
Collecting your data right can save you a world of hurt later, so here are 11 essential and painless tips that'll get you off to a great start
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

Excel 2010 - Lesson 5 - Finishing The Document - Excel 2010 Tutorial For Beginners - Tutorial Hub

Excel 2010 - Lesson 5 - Finishing The Document - Excel 2010 Tutorial For Beginners - Tutorial Hub In this video, we will learn how to finish a documen
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

Excel 2016 - Absolute and Relative References

This is an Excel 2016 Tutorial created by the CIS Sandbox at Bentley University.
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

Creating an Excel Dashboard (Examples & FREE Templates)

Learn how to create amazing Excel dashboards. It covers the best dashboard practices, useful tools, and do's & don'ts (with Examples & Templates)
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

An Introduction To Excel MINUTE Function + [Examples]

An Introduction To Excel MINUTE Function + [Examples] | Excel EZ | Scoop.it
Use Excel MINUTE Function to get the minute number from a time value. You can also insert a time directly into the function to minute number from it.
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

Updating Contact Details through Excel

Updating Contact Details through Excel | Excel EZ | Scoop.it
Recently I came across a problem where I realized that all of the e-mail addresses within my system were incorrect.
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

Excel Macro Recorder

Excel Macro Recorder | Excel EZ | Scoop.it
The Macro Recorder, a very useful tool included in Excel VBA, records every task you perform with Excel. All you have to do is record a specific task once. Next, you can execute the task over and over with the click of a button.
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

Finding if a cell has 7 in it… [Pattern matching in Excel]

Finding if a cell has 7 in it… [Pattern matching in Excel] | Excel EZ | Scoop.it
Imagine you work at MI5 as a HR officer. You want to find all agents who have license to kill (licence 7). Your data looks like above. How would you go about it
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

VBA in Excel

VBA in Excel | Excel EZ | Scoop.it
VBA (Visual Basic for Applications) is the programming language of Excel and other Office programs. With Excel VBA you can automate tasks in Excel by writing so called macros.
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

Currency format Pivot fields with one click [Friday VBA]

Currency format Pivot fields with one click [Friday VBA] | Excel EZ | Scoop.it
Anyone who has made a pivot table and their grandma knows that formatting them is a pain. Let's recap the steps to apply one of the most common formats -
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

PASS Webinar 2016

PASS Webinar 2016 | Excel EZ | Scoop.it
RT @ExcelTV: Register for @ExcelBIPASS webinar series with @ExcelTV on Tues Aug 16! #Excel #sqlpass https://t.co/KBAXCM96Of https://t.co/fg…
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

Excel Chi Squared Distribution Right Tailed Formula CHISQ DIST RT

Excel Chi Squared Distribution Right Tailed Formula CHISQ DIST RT
more...
No comment yet.