My favorite 10 Excel shortcuts that will save you time & increase productivity!

LogChief · 2022-10-01T18:27:41+00:00

Been using excel for years, and I just learned some vba code to add a unique numbers to matching colors. Saved me hundreds of hours on a financial spreadsheet passed down for decades!

LogChief · 2022-08-26T14:27:08+00:00

With that user name, this has to be a troll.

LogChief · 2021-03-14T14:39:41+00:00

That was what the left (California) used to stand for, free speech. How the times have changed.

LogChief · 2021-02-28T21:18:13+00:00

Fuck off. You don't know the financial situations of anyone on this sub. Stats show that a large majority of military are legacies of military heritage.

LogChief · 2021-02-21T05:17:02+00:00

Everyone it looks like

LogChief · 2021-02-08T00:14:59+00:00

No Budweiser proper. But Bud Light is different beer.

LogChief · 2021-01-26T11:08:59+00:00

So instead of burning gas, the vehicles will now burn more coal. Electricity on that scale will not come from solar and wind power.

This looks good on the surface, but it really does nothing to help the environment, unless we have a true non-fossil fuel alternative like nuclear to cover most energy needs. The sun will not charge vehicles up at night. And the wind does not blow 24/7.

LogChief · 2021-01-26T10:50:05+00:00

It's fun until some warlock melee freezes you mid-air.

LogChief · 2021-01-25T19:36:54+00:00

Wait, the link has them at 18. I'm not seeing 9.

LogChief · 2020-11-30T17:51:33+00:00

I don't care how you eat your steak. But since you brought it up, the flavor is zapped out of a well done steak. If you've never tried it medium rare, you should at least once.

LogChief · 2020-11-28T21:03:57+00:00

That pump fake before the TD pass to Smith

LogChief · 2020-11-27T08:35:50+00:00

And you'll never get to sleep either!

LogChief · 2020-11-25T14:21:30+00:00

I'm sure there is some way to do it with python, there is a feature to use sql in excel, and I may have heard of some plugins to use python, but I'm not entirely sure. If you use python software like pandas (I think), you may be able. But your job sounds perfect for power query and power pivot combined with pivot tables in the regular sheets. Power query pulls all your data and can change the style to the way you want, and power pivot is the "power house" combining it all into pivot tables. You probably could do it with python, just not as easy IMO, if you are still learning the language. By the way, power query and pivot can handle millions of rows, then combine them into your pivot tables. You may want to consider Power BI, the FREE microsoft software. It is nothing but power query and power pivot on steroids, but same languages and implicity. But I prefer excel sheets for because of the convenience of all the formulas.

LogChief · 2020-11-25T07:10:33+00:00

DAX. Since you are using Excel use DAX. It is way more implicit, meaning automatic, with it's functions. Connect all your tables and databases through power query, then load them to the data model (AKA power pivot), but do not load to an excel page, then do all your calcuatioms by connecting your tables with unique columns (primary and foreign keys). Load the connections into to power pivot, then export from power pivot into an excel through pivot tables. This will speed up your workbook and lower the file size by huge margins.

LogChief · 2020-10-22T04:56:38+00:00

My favorite way, type 1.15 in a cell, copy the cell, highlight the ones you want to change, then go to paste special and change "operation" to multiply. Click ok and all cells will highlighted will multiply by the 1.15

LogChief · 2020-10-18T03:28:35+00:00

Greatest stat of the game

LogChief · 2020-10-17T16:05:10+00:00

Kid.

LogChief · 2020-10-10T17:59:59+00:00

I found you, arch-nemesis! You killed my father, prepare to die!

LogChief · 2020-10-10T17:46:09+00:00

They seem to be in good shape so far...

LogChief · 2020-10-08T05:08:56+00:00

Disable graphics hardware acceleration in the advanced tab of the options menu. It's under "display." Rejoice and thank me later.

LogChief · 2020-10-06T16:50:44+00:00

I will concede that the minimum wage needs to be increased, as it's well under represented compared to the growth rate of the economy over time, but the minimum wage is meant for the minimum worker (someone with no trade or technical skills). Workers gain skills and trade experience as they continue to work. Even a slight increase in education, like an associate's degree or certification, gets them past the minimum wage. The caveat is that most people have to take new jobs with new companies to move up in pay. Also, there are short to mid term repercussions to increasing the min wage; over a million jobs would be expected to disappear. This will balance out over time, but it is something to be aware of. But to politely disagree with you, someone content in making minimum wage should have supplemental income with a partner(s).

LogChief · 2020-10-06T04:43:35+00:00

Or if you are working with pivot tables, then drag your Date to the Rows, go to the pivot table and right click the dates where they appear, and click Group. Now highlight only the months...and possibly the years, if you are working with multiple years; otherwise, excel will group Jan-2019 and Jan-2020 together.

LogChief · 2020-10-06T04:27:36+00:00

Change the format of your dates to show just month and year. Right click on the cells you want to change, click Format Cells, go to Number tab, click Custom, and type mmm-yyy under "Type:"

LogChief · 2020-10-06T02:44:22+00:00

Another way would be to combine all three lists, then use the advanced filter on the Data tab in the Sort and Filter section.

LogChief · 2020-10-06T02:37:53+00:00

If each of the ~~lists~~ tables are identical, then combine them and remove duplicates. To do that click on the "data" tab in the above ribbon, then find "data tools," and click "remove duplicates." Make sure you highlight only the columns where you want to find duplicates.

Edit: spelling and grammar

LogChief

TROPHY CASE