Profileimage by Caroline Morfitt Excel Administrator, Administrator, Administrator from Sheffield

Caroline Morfitt

available

Last update: 06.09.2022

Excel Administrator, Administrator, Administrator

Company: Caroline Morfitt
Graduation: Ultimate Excel VBA
Hourly-/Daily rates: show
Languages: English (Limited professional)

Attachments

CarolineCVcopy.pdf

Skills

Microsoft packages, Adobe Captivate, Microsoft Word, Excel, PowerPoint, Search Engine, Spreadsheets, data entry, Facebook, blogging, social media, laptops

I can offer following spreadsheet services for your business:
  • Auto-fill feature
  • Formulas
  • IF/ And function
  • Concatenating
  • Vlookup
  • Absolute, Mixed and Relative Reference
  • PMT, IMPT functions
  • Pivot Tables, Pivot Charts
  • Subtotalling Data
  • Sorting large amount of Data
  • Deleting Duplicate Data 
  • What If Analysis
  • Advanced Scatter, Combo Charts, Pie, Column, Line Charts
  • Collecting Data with a Google Drive Form
  • Exploring monthly and yearly compounding
  • Recording Macros
  • Conditional Formatting
  • The VBA ( Visual Basic for Applications) Language
  • The VBA Programming
  • Coding
  • Variable Scope
  • Error Handling
  • Looping: Do loop, For Next, For Each
  • Branching: If then, Select Case
  • Active X Controls
  • Modifying The User Interface
  • Macro Launching Shortcuts
  • Toggle Macro on/off using a button
  • VBA User Forms
  • Referencing a Range
  • Variables
  • Application Events, Events Handling
  • The VBA Functions
  • Inputting and Outputting

Project history

02/2020 - 02/2020
Administrator
Rullion

department, scanning them, liaising with Royal Mail, dealing with incoming, outgoing post, attaching lasting
power of attorney and other legal documents using Proclaim to caseworkers.

05/2019 - 09/2019
Excel Administrator
Lion Spreadsheets

administrative duties, inputting receipts, income and expenditure on Excel, general data entry, calculating
bills, answering email queries, ordering stationary, personal assistant duties.

06/2018 - 10/2018
Administrator
Parkgate Sports and Community Trust Limited

contacting charities for update for loan progress, taking part in conference meetings, creating profiles for
giving networks, discussing charity improvement plans with Directors, filling out forms in regards to grants

05/2018 - 05/2018
Administrator
Yorkshire Wills & Probate

directories, designing website, Facebook shop, blogging, creating posts, social media accounts

06/2001 - 04/2018
Administrator
Virtual Assistants

reports, being personal assistant to business, typing documents, calculating petty cash, inputting addresses,




orders, payments, loss, profit, liaising with Directors and performing any clerical tasks, organising venues

09/2015 - 11/2016
Digital Designer
Barnsley College

students, taking constructive criticism and improving Health and Safety, Construction slide show,
interacting with colleagues and working together as a team to design packages, providing IT support

02/2014 - 08/2015
Customer Advisor
Capita

Southern Water bills, transferring clients to debt collection agencies, taking payments, setting up direct
debits, setting up water, electricity and gas tariffs, going through affordability plans, updating details

03/2011 - 11/2013
Customer Advisor
Impellam, Blue Arrow

up repairs, updating customers about their technical PC repairs, resolving complaints, processing orders for
Currys' kitchen appliances, contacting couriers, allocating missing in transit washing machines, refunding

05/2008 - 02/2011
Customer Advisor
HBOS Plc, Lloyds Banking Group

of Scotland Home Insurance policies, setting up direct debits, explaining Buildings and Contents Cover,
Personal Belongings, providing quotes, referring owners for subsidence hazards to providers

06/2004 - 04/2008
Administrator
eConsultancy

businesses, networking, helping companies to maximise their profit and gain new customers

05/2003 - 05/2004
Administrator
eOffice

Administrator: providing comprehensive secretarial, administrative services
to small and medium businesses, consulting, business planning, general advice, income, profit, loss

Local Availability

Only available in these countries: United Kingdom
Worldwide
Profileimage by Caroline Morfitt Excel Administrator, Administrator, Administrator from Sheffield Excel Administrator, Administrator, Administrator
Register