09/06/2022 updated
100 % available
Excel Administrator, Administrator, Administrator
Sheffield, United Kingdom
United Kingdom
Ultimate Excel VBAMicrosoft WordMicrosoft ExcelActiveXAdobe CaptivateSpreadsheetsPharmaceutical CompoundingData CollectionData EntryException HandlingHuman-Computer InteractionPivot ChartsPivot TableMicrosoft PowerPointSocial MediaGoogle Drive
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:
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
Experience
Professional experience10+ years
Languages
EnglishGood
Project history
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.
power of attorney and other legal documents using Proclaim to caseworkers.
administrative duties, inputting receipts, income and expenditure on Excel, general data entry, calculating
bills, answering email queries, ordering stationary, personal assistant duties.
bills, answering email queries, ordering stationary, personal assistant duties.
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
giving networks, discussing charity improvement plans with Directors, filling out forms in regards to grants