Financial accounts ob: howcan i practice these functions/formulas?

I will start my first job working in financial accounts in 2 weeks and i want to brush up on the necessary excel skills i am likely to use

these will be the Key Responsibilities
• Process product ledger accounting data, including posting to the accounting system and other relevant accounting applications, as part of statutory financial and regulatory reporting period end close.
• Complete relevant financial reconciliations on a timely basis, including working with Analysts to investigate and clear outstanding items.
• Contribute to the accurate and timely preparation of the monthly financial accounts and demonstrate a high level of attention to detail.
Identify and communicate issues and errors to the Analysts within the team.
• Maintain procedure notes.


the recruitment agent said to practise LOOKUPs, PIVOT TABLES and simple MACROS and i have been following youtube tutorials but this is only practising on small amounts of data
is there anywhere i can download mass data workbooks to practise the lookups, simple macros and pivots functions?


So for these tasks what specifically would you expect to be doing in Excel?

You could start with the FRB

http://www.federalreserve.gov/econresdata/default.htm

Google any government agency and you will find lots of data. Governments love to publish data sheets.

You could start with the FRB

http://www.federalreserve.gov/econresdata/default.htm

Google any government agency and you will find lots of data. Governments love to publish data sheets.