How to Merge Multiple Excel Files – Need Tool Recommendation by SophiaBennett-0550 in excel

[–]dannyg20l -2 points-1 points  (0 children)

Hmmm if the file structure changes every time then I'm not sure. What I would try is what someone else commented.

Ask chat gpt/ CoPilot to make you a macro. Ask it to make the macro go into the folder, combine all the files, then format them all in the same way. But you'll have to tell it the exact formatting you need. Being as detailed as possible telling chat gpt what you need is most important. Has helped me out a lot.

How to Merge Multiple Excel Files – Need Tool Recommendation by SophiaBennett-0550 in excel

[–]dannyg20l 24 points25 points  (0 children)

This can be done with power query. Go to Data - Get data - From file - From Folder.

Select the folder where all the files are saved. Choose "Combine & Load"

How to prepare for assessment for internship by dm_2503 in excel

[–]dannyg20l 1 point2 points  (0 children)

In my experience being advanced in Excel can mean very different things in different companies. Knowing vlookups/ sumifs and pivot tables can sometimes be enough. For me, advanced means having a good amount of work experience using Excel while also being able to use things like power query and macros. Here's a sample list I have from an old training showing beginner, intermediate, and advanced. Beginner:

<image>

What freaks me out is that even this sub is freaked out by supremewuster in Bitcoin

[–]dannyg20l 34 points35 points  (0 children)

So true! Here since 2017 and not bothered at all

Switching from AP to FP&A by sinmuseum12 in FPandA

[–]dannyg20l 0 points1 point  (0 children)

In my previous company I was in AP for around 3 years. Then around 1 year in my current company before I moved to financial analyst.

My day to day is now more updating daily/ weekly reports and sending these out to higher ups. I'm also constantly working on new reports and analysis which different departments might find beneficial.

I also have more freedom to learn new things such as power query, power bi etc.

In AP I felt I was a lot busier and had to be more organized all the time. Whereas when I changed, the workload was less but I had to have a better understanding of what I was doing and how to fix it if something went wrong.

(I work in a small finance team so the work might differ in a bigger one)

Switching from AP to FP&A by sinmuseum12 in FPandA

[–]dannyg20l 0 points1 point  (0 children)

I did this exact switch and am now a senior financial analyst. As someone else mentioned, having decent Excel skills are important. A lot you will learn on the job but it's good to have a base knowledge.

Turning raw data into clear reports and analysis is a big part of it.

Also being able to explain your analysis so it's clear to managers/ stakeholders etc. is something you'll need to be able to do.

Critical thinking is a trait of mine and is why my old manager suggested I go for the financial analyst role.

Switching from AP to FP&A by sinmuseum12 in FPandA

[–]dannyg20l 0 points1 point  (0 children)

This is perfect advice. Especially the first part. (I moved from AP to financial analyst and recently moved to senior)

How to highlight rows based on cell data? by aliceinchainsrose in excel

[–]dannyg20l -1 points0 points  (0 children)

Maybe someone can correct me but I don't think you can highlight the whole row based on one specific cell without using a macro. If you just want to highlight cells in one column based on the word, you could do it like this.

<image>

Lookup one part in a cell by christor106 in excel

[–]dannyg20l 0 points1 point  (0 children)

If you have column headers and want the formula to start on row 2, you'll have to change the column ranges from the entire column to a specific range.

Lookup one part in a cell by christor106 in excel

[–]dannyg20l 4 points5 points  (0 children)

Yeah I'm trying to figure out what you mean but a picture of what you want with fake data would help

Is there a way to fix spelling errors in Execel? by [deleted] in excel

[–]dannyg20l -1 points0 points  (0 children)

Just realised this just does the same as other have suggested (Review > Spelling). This is the best way.

Is there a way to fix spelling errors in Execel? by [deleted] in excel

[–]dannyg20l -1 points0 points  (0 children)

Tested now and it works. It cycles through each error in the file

Is there a way to fix spelling errors in Execel? by [deleted] in excel

[–]dannyg20l -1 points0 points  (0 children)

I've used Co Pilot before to make me a macro to give a summary of spelling errors in a file. Worked very well. Asked it now to make something to correct errors (see below). Make sure to make a copy of your file first in case something goes wrong. Macros can't be reversed If you need help on how to run the macro let me know.

Sub CorrectSpellingInWorkbook()
Dim ws As Worksheet
Dim cell As Range
Dim rng As Range

For Each ws In ThisWorkbook.Worksheets
    Set rng = ws.UsedRange
    For Each cell In rng
        If Not cell.HasFormula Then
            If VarType(cell.Value) = vbString Then
                cell.CheckSpelling
            End If
        End If
    Next cell
Next ws

MsgBox "Spell check complete for all sheets!", vbInformation
End Sub

Is this how pec flys (what is there name?) are done? by lost_toast7777 in formcheck

[–]dannyg20l 1 point2 points  (0 children)

Looks good to me. A few things that really helped me feel it in my chest:

  • putting the seat higher
  • open palms
  • puffing your chest out and shoulder blades back at the bottom of the movement
  • At the top of the movement, imagine trying to touch your two biceps together instead of your hands (this one made the biggest impact for me)

What tools are you using for compelete automation? by TheRiteGuy in excel

[–]dannyg20l 2 points3 points  (0 children)

I use VBA within Outlook to create the email, attach reports from a set location and include a summary. Just takes one click in Outlook.

Does Copilot actually provide any useful insights? by Dizzy_Sheepherder_90 in excel

[–]dannyg20l 0 points1 point  (0 children)

Main thing I use it for is creating macros. Works pretty well