Awesome Excel

02/05/2019

Excel - goal seek - great method if you need to determine how much you need for a down payment, amount to finance, or interest rate to meet your goals. Useful in business and personal finance!

Goal seek is a powerful method to determine what you can afford - it works with nearly any formula - for example if you're paying off a college loan, you can...

01/07/2019

Naming ranges in Excel (done in 2010, works with newer versions)

naming ranges in Excel is a method that is the same as absolute ranges. For example, if you have data in cells B2:D15 and name it "Data", you could just ente...

12/03/2018

Costing a project - done in Excel 1 0 - some great tips on those estimating for their own business.

This tutorial shows people how to cost a project out for any type of craft project (jewelry, art, paintings, needlework) so that they will realize what they'...

11/19/2018

Create a trendline in a chart - Excel 2010

This example shows you how to add a trend line to an Excel 2010 chart.

11/05/2018

Excel -COUNTIF & COUNTIFS have many powerful abilities....check this out!

Countif allows you to count either a text or numeric string to determine the number of occurrences. COUNTIFS allows youto count either text or numbers to det...

10/14/2018

Copy only filtered data in Excel and pasting it...very useful tip when making a presentation, data can be copied into other software such as PowerPoint or Word

When filtering data and you want to only use the data shown, copy and paste will display all the hidden data. This method applies either to filtered data or ...

10/09/2018

Later this autumn there will be one night classes on Pivot Tables/Charts - a must for anyone in the workforce or about to re-enter....check out this video

This tutorial shows the basics of creating a chart, formatting it, and adding filters

08/03/2018

Check back in August to find classes that will be offered in Excel. Please note that we will be offering some specific classes on pivot tables as well as introductory session. If you are taking a class, you can bring your old fully charge device to class. Make sure you have the software installed and you have your IDs And passwords. We will try to provide some tips for XL users. Make sure if you check back on this page to find more useful tips during the year. Good luck!

06/26/2018

Office integration may sound like an unusual term yet you can do so much between the programs - this video discusses Access and Excel - either copying from Access and pasting into Excel or obtaining data from Excel to add to an Access database!

Part of a series of classes being done on Office Integration with MS Office - on how to integrate the programs with each other. This one covers working betwe...

06/11/2018

Will be doing a class on MS Office Integration on 5/21
@ Yonkers Public Library (ypl.org to register) - will be covering paste linking between different programs such as Excel/PowerPoint....this video demonstrates one of many features we'll be doing that evening!

https://www.youtube.com/watch?v=nL6A0cKhyig&feature=youtu.be

Part of a series of classes being done on Office Integration with MS Office - on how to integrate the programs with each other. This one covers paste linking...

04/12/2018

for you mac users...this video may be of assistance!

Done in version 2016 on the Mac, this shows the following: average, min, max, and median.

01/01/2017

Classes for 2017 start in March....will be in Greenwich and Scarsdale...stay posted