$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Junior
{{ $t($store.state.user.experience_search_name) }}
0
jobs
Strong spreadsheet profile specilising in Excel Applications, The VBA
Caroline Morfitt
,
Sheffield, United Kingdom
Experience
Other titles
Skills
I'm offering
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
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
Markets
United Kingdom
Links for more
Once you have created a company account and a job, you can access the profiles links.
Industries
Language
English
Fluently
Ready for
Larger project
Ongoing relation / part-time
Full time contractor
Available
My experience
2020 - 2020
job
Administrator
Rullion, Sheffield.
opening letters for Cooperative Legal Services in will
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.
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.
Administrator, Power
2018 - 2019
job
Excel Administrator
Lion Spreadsheets, Sheffield.
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
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
Excel, Personal assistant, Administrator
2018 - 2018
job
Administrator
Parkgate Sports and Community Trust Limited.
applying for grants, fundraising, liaising with Trustees,
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
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
Fundraising, Administrator
2018 - 2018
job
Administrator
Yorkshire Wills & Probate.
copy typing legal documents, advertising business on
directories, designing website, Facebook shop, blogging, creating posts, social media accounts
directories, designing website, Facebook shop, blogging, creating posts, social media accounts
Social Media, Advertising, Blogging, Facebook, Website, Administrator, Social
2018 - 2018
job
Administrator
Virtual Assistants, Sheffield.
dealing with emails, general correspondence, writing
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
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
Writing, Personal assistant, Administrator, Performing
2014 - 2017
job
Customer Advisor
June 2017 Capita.
resolving complex complaints, explaining Npower,
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
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
UP
2015 - 2016
job
Digital Designer
Barnsley College, Barnsley.
designing eLearning quizzes for teachers, games for
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
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
Design, It support, It, Support, Safety, Health
2011 - 2013
job
Customer Advisor
Blue Arror, Impellam.
answering inbound calls for KnowHow laptops, chasing
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
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
PC, Processing, UP
2008 - 2011
job
Customer Advisor
HBOS Plc, Lloyds Banking Group.
setting up Halifax, Sainsburys, Lloyds Banking, Royal Bank 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
Personal Belongings, providing quotes, referring owners for subsidence hazards to providers
Banking, Insurance, UP
2004 - 2008
job
Administrator
eConsultancy, Sheffield.
writing business plans, implementing them, advertising
businesses, networking, helping companies to maximise their profit and gain new customers
businesses, networking, helping companies to maximise their profit and gain new customers
Advertising, Writing, Networking, Administrator
2003 - 2004
job
Administrator
eOffice, Sheffield.
providing comprehensive secretarial, administrative services to small and medium businesses, consulting, business planning, general advice, income, profit, loss
Consulting, Administrator
My education
2019
Udemy
Ultimate Excel VBA, Ultimate Excel VBA
Ultimate Excel VBA, Ultimate Excel VBA
This is to certify that Caroline Morfitt successfully completed
8.5 hours of Ultimate Excel VBA online course on Nov. 24, 2019
Mark Talbert, Instructor
&
Udemy
# BeAble
Certificate no:UC-LD3GOQFX
Certificate url: ude.my/UC-LD3GOQFX
2019
Udemy
Microsoft Excel - Excel from Beginner to Advanced Certificate, Microsoft Excel - Excel from Beginner to Advanced Certificate
Microsoft Excel - Excel from Beginner to Advanced Certificate, Microsoft Excel - Excel from Beginner to Advanced Certificate
Microsoft Excel - Excel from Beginner to Advanced Certificate
Certificate of Completion
This is to certify that Caroline Morfitt successfully completed 7.5 hours of Microsoft Excel - Excel from Beginner to Advanced online course on Nov. 24 2019
Warrick Klimaytys, Instructor
&
Udemy
# Be Able
Certificate number: UC-5MOZ9C71
Certificate url: ude.my/UC-5MOZ9C71
2018
Finance and Management Business School -
AAT ACCESS AWARD IN BUSINESS SKILLS - LEVEL 1, AAT ACCESS AWARD IN BUSINESS SKILLS - LEVEL 1
AAT ACCESS AWARD IN BUSINESS SKILLS - LEVEL 1, AAT ACCESS AWARD IN BUSINESS SKILLS - LEVEL 1
THIS IS TO CERTIFY THAT
CAROLINE MORFITT
AAT ID 20260571
HAS BEEN AWARDED
AAT ACCESS AWARD IN
BUSINESS SKILLS - LEVEL 1
603/1309/2
OF THE ASSOCIATION OF ACCOUNTING TECHNICIANS
AWARDED
16 AUGUST 2018
Mark Farrar
AAT Chief Executive
Ofqual
cea regulation
Certificate Number
1255192
2018
Udemy
Complete SEO Training, Complete SEO Training
Complete SEO Training, Complete SEO Training
Certificate of Completion
This is to certify that Caroline Morfitt successfully completed 8 hours of Complete SEO Training With Top SEO Expert Peter Kent! online coures on June 2,2018
Peter Kent
Peter Kent Instructor
Udemy
#BeAble
Certificate no: UC-H1T1S4EQ
Certificate url: ude.my/UC-H1T1S4EQ
2018
Google Digital Garage
The Online Marketing Fundamentals qualification, The Online Marketing Fundamentals qualification
The Online Marketing Fundamentals qualification, The Online Marketing Fundamentals qualification
Google Digital Garage IAB Europe Issued 12/05/2018
The Digital Garage course consists of over 23 modules covering a wide range of subjects from marketing fundamentals, search, email, social media, display, video, e-commerce, geo-marketing and analytics.
Google Digital Garage 39 - 43 King Street Manchester M2 7AT team@thedigitalgarage.co.uk
2017
eCareers
Sage 50 Accounts 2014 CPD Certified and Recognised by the IAB, Sage 50 Accounts 2014 CPD Certified and Recognised by the IAB
Sage 50 Accounts 2014 CPD Certified and Recognised by the IAB, Sage 50 Accounts 2014 CPD Certified and Recognised by the IAB
This is to Certify that Caroline Morfitt Has successfully completed the course in Sage 50 Accounts 2014 CPD Certified and Recognised by the IAB
The CPD Certificate is presented by e-Careers Ltd, it is also recognised by the IAB to be a useful course to learn about the efficient financial management of a business.
CPD Activity Date 08-05-2017
CPD Hours 15 Hours
IAB CPD Certified The CPD Certification Service E-Careers Learn to LiveNew paragraph.
2015
-
2016
Barnsley College
Functional Skils Level 2 English, Mathematics, Diploma Advanced Level 3 in Digital Learning Design, Digital Learning Design Functional Skils Level 2 English, Mathematics,
Functional Skils Level 2 English, Mathematics, Diploma Advanced Level 3 in Digital Learning Design, Digital Learning Design Functional Skils Level 2 English, Mathematics,
Please find here attached following Ascentis Level 3 Diploma in Digital Learning Design (RDF)
Ascentis
This is to certify that Caroline Morfitt has successfully completed
Ascentis Level 3 Diploma in Digital Learning Design (RDF) at Barnsley College
Date of issue 04 October 2016
Moderation Date 20 September 2016
Learner Number 698030
Certificate Number 5681951 (1)
Qualification Number 601/2586/X
Phil Wilkinson
Ascentics Chief Executive
Regulated by Ofqual
For more information see http://register.ofqual.gov.uk
creative
cultural
skills
Apprenticeships
This certificate is awarded to
Caroline Morfitt
who has successfully completed the
Advanced Level Apprenticeship in
A Digital Learning Design
in the Apprenticeship sector for occupations in arts, cultural heritage, craft, and design (also includes music, literature, performing arts and visual arts).
Completion date
21 October 2016
Brian W
Chairman
Federation for Industry Sector Skills & Standards
Advanced
Level
Federation for Industry Sector
Skills & Standards
Certificate Number A57CD954-D47F6879-B396BDB8-23E83461-CD201285-54X25444 Apprentice Number ACE185A6E
Functional Skills qualification in English at Level 2
City&Guilds
Functional Skills qualification in English at Level 2
500/9318/6
is awarded to Caroline Morfitt
who attended
Barnsley College
and was successful in the following 4 modules
Functional English Speaking, listening and communication at level 2 F/601/1464 PASS
Functional English Reading at Level 2 F/601/1464 PASS
Functional English Writing at Level 2 F/601/1464 PASS
Certification module for Functional Skills qualification English at level 2 PASS
Awarded 12 April 2016 120416/3748-01/036110/PBE7930/F/18/02/8040294643185501678168/410
Sir John Armitt, CBE FREng FCGI Chairman Chris Jones
Chairman Director-General
The City and Guilds of London Institute The City and Guilds of London Institute
Regulated by Ofqual
For more information see http://register.ofqual.gov.uk
The City and Guilds of London Institute founded 1878 and Incorporated by Royal Charter 1900.
The City Guilds Group compromises City&Guilds and ILM.
Functional Skills qualification in Mathematics at Level 2
City&Guilds
Functional Skills qualification in Mathematics at Level 2
501/0987/X
is awarded to
Caroline Morfitt
who attended
Barnsley College
This holder has a number of formal Unit Credits by which this Award was achieved.
Awarded 01 September 2016
010916/3748-02/036110/PBE7930/F/18/02/8040294643185501802986/50
Sir John Armitt CBE FREng FCGI Chairman Chris Jones Director-General
The City and Guilds of London Institute
Regulated by Ofqual
For more information see http://register.ofqual.gov.uk
cea Regulation
The City and Guilds of London Institute founded 1878 and Incorporated by Royal Charter 1900.
Functional Skills qualification in Information and Communication Technology (ICT) at level 2
City&Guilds
Functional Skills qualification in Information and Communication Technology (ICT) at level 2
501/0639/9
is awarded to Caroline Morfitt
who attended
Barnsley College
The holder has a number of formal credit Unit Credits by which this Award was achieved
Awarded 12 July 2016
120716/3748-03/036110/PBE7930/F/18/02/8040294643185501759093/3650
Sir John Armitt CBE FREng FCGI Chairman Chris Jones Director-General
The City and Guilds of London Institute The City and Guilds of London Institute
Regulated by Ofqual
The City and Guilds of London Institute founded 1878 and Incorporated by Royal Charter 1900
cea Regulation
Caroline's reviews
Caroline has not received any reviews on Worksome.
Contact Caroline Morfitt
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Caroline directly in Worksome.
38000+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled talent in Denmark