Cetron Data Solutions @CetronData

#Analytics and #Excel consultant. I help businesses understand their data and transform it into actionable insights cetrondatasolutions.com New York Joined November 2019

Tweets

242
Followers

74
Following

132
Likes

183

Cetron Data Solutions @CetronData

5 years ago

It’s a new year, and a great time to start learning excel! Let’s get to it! #excel #data #learning spreadsheeto.com/how-to-use-exc…

0 0 0 0 0

Leila Gharani @LeilaGharani

5 years ago

How to properly use Microsoft Forms and connect the results automatically to Excel. You can add drop-downs, date pickers, number checks, star ratings, Likert scale, etc... youtu.be/nXeYv-W-Wt4

4 10 51 0 9

Download Image

Cetron Data Solutions @CetronData

5 years ago

I have found many people don’t know about or take advantage of averageif. It is extremely helpful when you want to setup parameters for your average formula. The below is a great example and worth some time experimenting with! #data #excel #tips #tryit

Tom Urtis @TomUrtis

5 years ago

0 4 18 0 1

Download Image

1 0 0 0 0

Microsoft Excel @msexcel

5 years ago

Did you know October 17 is #SpreadsheetDay? How are you planning to celebrate? 🎉🎊 #ThursdayThoughts

55 123 525 0 11

Cetron Data Solutions @CetronData

5 years ago

I love this functionality in excel. So many times I want a workbook to update when i open it and this code executes it flawlessly so. Give it a shot, I guarantee it’ll help solve some headaches. #excel #data #vba #tryit

Excel Zoom @excelzoom

5 years ago

0 0 3 0 1

0 0 1 0 0

Cetron Data Solutions @CetronData

5 years ago

While this specifies skills for accountants, I found this to be helpful for anyone who wants to learn excel. Practicing and learning is the only way to get better, give the below a try!

Excel Zoom @excelzoom

5 years ago

While this specifies skills for accountants, I found this to be helpful for anyone who wants to learn excel. Practicing and learning is the only way to get better, give the below a try!

1 5 6 0 1

0 0 0 0 0

Cetron Data Solutions @CetronData

5 years ago

Simple yet effective, the IF statement in excel can change the way you view excel. Take a look at the below and try and if statement! #data #excel #Tips exceljet.net/excel-function…

0 0 0 0 0

Cetron Data Solutions @CetronData

5 years ago

Histograms are great graphs and my go to for frequency distribution. They are great at visualizing comparison data and can work over large ranges. I definitely recommend checking out the below! #data #graphs #excel #helpful

Leila Gharani @LeilaGharani

5 years ago

1 9 47 0 7

Download Image

0 0 0 0 0

Cetron Data Solutions @CetronData

5 years ago

Sometimes you just want to test something and just need a data set to test it on. Very helpful tool! #data #excel #Helpful

Bill Jelen @MrExcel

5 years ago

Sometimes you just want to test something and just need a data set to test it on. Very helpful tool! #data #excel #Helpful

1 4 11 0 2

0 0 0 0 0

Cetron Data Solutions @CetronData

5 years ago

Power pivot, it’s worth the time to learn. Take a look at the guide bellow to see what it can do. It has become my new best friend. #excel #helpful #Analytics codeproject.com/Tips/621908/Be…

0 0 0 0 0

Cetron Data Solutions @CetronData

5 years ago

I had a very long word document and I wanted to make it easier to use. I used internal links within word so anyone could jump exactly to the section they wanted to. Checkout the below video! #tips #msword #helpful m.youtube.com/watch?v=C6ZA0f…

0 0 0 0 0

Cetron Data Solutions @CetronData

5 years ago

Being able to link pivot tables with slicers is amazing functionality that everyone should become familiar with. Being able to manipulate data from own source point allows for a better flow in a presentation and easier end user usage. Give it a shot! #dat #excel #tryit

ExcelChamps.com @ExcelChamps

5 years ago

0 1 8 0 3

0 2 2 0 2

Cetron Data Solutions @CetronData

5 years ago

I have been using power BI more and more over the past few months. I have found it is a great tool that you can use to put together strong data visualizations. Below are some tips that really helped me. #powerBI #dataViz #helpful #data nabler.com/articles/cleve…

0 0 0 0 0

Cetron Data Solutions @CetronData

5 years ago

I use this functionality quite a bit in my work. Heat maps are a great way to visualize and present data.Try the below, it’s well worth the time! #data #Excel #helpful #dataVisualization

Ilgar Zarbaliyev 🇦🇿 @IlgarZ

5 years ago

I use this functionality quite a bit in my work. Heat maps are a great way to visualize and present data.Try the below, it’s well worth the time! #data #Excel #helpful #dataVisualization

0 3 5 0 1

0 0 1 0 0

Cetron Data Solutions @CetronData

5 years ago

This is a nice to have. I have been doing this on files I send to others so they can see the last time the file was modified from my end. It is very helpful as it is a way to time stamp when the last changes were made. Give it a shot! #excel #data #helpful #thursdayvibes

Tom Urtis @TomUrtis

5 years ago

0 2 23 0 2

Download Image

1 0 1 0 1

Cetron Data Solutions @CetronData

5 years ago

I can’t retweet this enough. Since this has launched it has changed the way I use excel. It is a more flexible version of vlookup and simply out, it just works extremely well! Give it a shot. #data #excel #mondaythoughts #helpful

Microsoft Excel @msexcel

5 years ago

27 193 619 0 98

Download Video

0 0 0 0 0

Cetron Data Solutions @CetronData

5 years ago

Power query is great functionality that is available in excel. It allows you to clean transform and reshape your data in mana different ways. Take a look at the below as a good start! #excel #data #powerquery

Computergaga | Alan Murray @Computergaga1

5 years ago

0 3 13 0 2

0 1 1 0 0

Cetron Data Solutions @CetronData

5 years ago

It’s always fun learning something new! Take a look at the secrets below and try them out!

Microsoft Excel @msexcel

5 years ago

It’s always fun learning something new! Take a look at the secrets below and try them out!

8 116 404 0 117

Download Image

0 0 0 0 0

Cetron Data Solutions @CetronData

5 years ago

This is functionality that I believe many don’t realize exists. It is amazing what excel can do and being able to sort by the color of the cell gives you yet another way to arrange the data you see fit! I definitely suggest giving the below a try. #data #excel #helpful #tryit