Learning Goals
Goal 1 - To be competent in using excel and other keyboard shortcuts
Plan of action: to incorporate keyboard shortcuts on a regular basis and learn new ones on a regular basis
Progress
I use the following shortcuts and excel formulas on a regular basis to use my tome at work more efficiently.
These include:
1. Keyboard Shortcuts:
a. Ctrl + Tab - to switch between windows and Ctrl + Shift + Tab - to switch between tabs
b. Ctrl + W and Ctrl + T - to open and close tabs
c. Alt + S - to send an email on outlook
2. Excel Formulas:
a. Index+Match : to find and input data matching specific criteria in a spreadsheet as this function is more efficient compared to Vlookup or HLookup
b. Concatenate and & sign - to join various characters together reducing the amount of annual typing
c. Sum, SumIf and conditional formatting - to create a chart for Gm's highlighting best and worst performing cost centres, with color changing from green to red depending on a surplus or a deficit
d. substituting mouse with keyboard shortcuts like - ALT, H-Home tab then choosing the corresponding letter for an action. For example: to change font color- ALT + H + H is used to open color tab, then favoured color is chosen.
I use the following shortcuts and excel formulas on a regular basis to use my tome at work more efficiently.
These include:
1. Keyboard Shortcuts:
a. Ctrl + Tab - to switch between windows and Ctrl + Shift + Tab - to switch between tabs
b. Ctrl + W and Ctrl + T - to open and close tabs
c. Alt + S - to send an email on outlook
2. Excel Formulas:
a. Index+Match : to find and input data matching specific criteria in a spreadsheet as this function is more efficient compared to Vlookup or HLookup
b. Concatenate and & sign - to join various characters together reducing the amount of annual typing
c. Sum, SumIf and conditional formatting - to create a chart for Gm's highlighting best and worst performing cost centres, with color changing from green to red depending on a surplus or a deficit
d. substituting mouse with keyboard shortcuts like - ALT, H-Home tab then choosing the corresponding letter for an action. For example: to change font color- ALT + H + H is used to open color tab, then favoured color is chosen.
Goal 2 - Work towards obtaining a Graduate Position
Plan of Action - To ensure I go over and beyond what I'm responsible for and aim to own full responsibility in completing and updating pieces of work to add value to business operations
Progress:
I assisted in the Customisation of the header (left of screen) to include Coles logo, team member name and red theme. Note: due to confidentiality, the live feed which is displayed under the header and supplier details have been omitted. This modification was outside the scope of my role and the modification impressed my manager and fellow team members, as the customisation helped apply the One Team element Coles Strategy. |
Goal 3 - Aim to present to a group of employees higher up in the organisational hierarchy
Plan of action - I aimed to identify deficiencies in the current overdue invoice processing procedure and suggest changes to improve the efficiency of it.
Progress
presented a business case to my manager (attached below) to identify cost saving modifications to the current procedures.
An Expert form my manager's email Detailed:
"Good Job with the proposal for project funding Raul, I'm hoping we would get the required funds approved without much hesitation".
Progress
presented a business case to my manager (attached below) to identify cost saving modifications to the current procedures.
An Expert form my manager's email Detailed:
"Good Job with the proposal for project funding Raul, I'm hoping we would get the required funds approved without much hesitation".