Document Controller/Data Entry/EAMS Technician/CMMS Technician

Data entry and formatting (text, numbers, dates) Cell referencing (Relative, Absolute $A$1, Mixed A$1 or $A1) Sorting and filtering data Basic arithmetic formulas (SUM, AVERAGE, COUNT, etc.) Conditional formatting for visual emphasis Data Validation – Create drop-down lists and restrict input types Pivot Tables – Summarize large datasets dynamically Charts & Graphs – Create bar, line, pie charts for data visualization IF Statements – =IF(A2>100, "High", "Low") LOOKUP Functions – VLOOKUP – Search data vertically HLOOKUP – Search data horizontally XLOOKUP – More flexible alternative TEXT Functions – LEFT(), RIGHT(), MID(), LEN(), TRIM() for cleaning text data DATE Functions – TODAY(), NOW(), YEAR(), MONTH(), DAY()

Creating & Formatting Slides – Adding, deleting, and arranging slides efficiently Text & Image Formatting – Adjusting fonts, colors, alignments, and inserting images Using Templates & Themes – Ensuring consistent design across slides Slide Layouts & Placeholders – Organizing content for clarity Adding & Formatting Shapes – Creating diagrams and visual elements Transitions & Animations – Smooth slide transitions and object animations SmartArt Graphics – Creating organizational charts, process flows, and lists Tables & Charts – Presenting data visually with tables, bar charts, and pie charts Hyperlinks & Action Buttons – Creating interactive presentations Speaker Notes & Handouts – Adding notes for reference and printing audience handouts Audio & Video Integration – Embedding multimedia elements

Typing Speed & Accuracy – Fast and precise data entry (typically 40-60+ words per minute). Microsoft Office & Google Suite – Proficiency in Excel, Word, and Google Sheets for data handling. Data Management Software – Experience with databases, CRM systems, and ERP software. Basic IT Skills – Understanding file formats, document conversion, and troubleshooting software issues. Ability to spot and correct errors in data. Maintaining consistency and accuracy across large datasets. Efficiently sorting and categorizing data. Managing files systematically for easy retrieval. Meeting deadlines while maintaining accuracy. Prioritizing tasks to handle large volumes of data efficiently. Clear written and verbal communication for reporting errors or inconsistencies. Ability to follow instructions precisely.

Workspace Navigation – Understanding layers, tools, panels, and menus File Management – Opening, saving, and exporting files in different formats (JPEG, PNG, PSD, PDF) Selection Tools – Using Marquee, Lasso, and Quick Selection tools for precise edits Basic Image Adjustments – Brightness, contrast, hue/saturation, and exposure correction Cropping & Resizing – Adjusting images without losing quality Layer Management – Organizing layers, using groups, and adjusting opacity Masking Techniques – Using Layer Masks and Clipping Masks for non-destructive edits Retouching & Healing – Removing blemishes, wrinkles, and objects using Spot Healing Brush and Clone Stamp Blending Modes – Applying effects like Overlay, Multiply, and Screen for creative compositions Typography & Text Effects – Adding and styling text with layer effects like shadows and strokes Pen Tool & Vector Shapes – Creating precise selections, paths, and custom shapes Advanced Photo Manipulation – Combining images and using layer adjustments for seamless edits Smart Objects & Filters – Using non-destructive filters like Gaussian Blur and Liquify Color Grading – Enhancing images with Gradient Maps, Curves, and Selective Color Custom Brushes & Patterns – Creating and importing unique brushes for digital painting

Financial Planning & Forecasting – Assessing investment opportunities and predicting asset performance Asset Performance Monitoring – Tracking and evaluating asset utilization and efficiency Risk Assessment & Mitigation – Identifying financial, operational, and market risks Trend Analysis – Evaluating historical data to predict future asset value KPI Monitoring – Measuring key performance indicators like asset turnover and depreciation Asset Management Software – Experience with SAP, IBM Maximo, Oracle EAM, or CMMS systems Excel & Data Analytics – Using PivotTables, VLOOKUP, and macros for financial analysis Enterprise Resource Planning (ERP) Systems – Managing asset lifecycle through ERP tools Lifecycle Management – Handling asset acquisition, utilization, maintenance, and disposal Preventive Maintenance Planning – Ensuring assets remain functional and efficient Cost-Benefit Analysis – Evaluating when to replace vs. repair assets

Clear & Concise Writing – Avoiding jargon, keeping sentences simple and direct Grammar & Proofreading – Ensuring accuracy with spell-checking and proofreading tools Consistency in Style – Following standard writing guidelines (APA, MLA, Chicago, or company-specific styles) Proper Structuring – Using headings, bullet points, and numbered lists for readability Using Templates & Formatting – Creating standardized documents with consistent fonts, spacing, and styles Writing Manuals & Guides – Creating instruction manuals, SOPs, and user guides Version Control – Tracking document revisions and updates Using Document Management Systems (DMS) – Managing documents in SharePoint, Google Drive, or OneDrive Annotation & Commenting – Providing feedback and making collaborative edits Incorporating Visuals – Using charts, diagrams, and screenshots to enhance clarity Report Writing – Creating business reports, proposals, and executive summaries Contracts & Agreements – Writing structured legal and business contracts Meeting Minutes & Notes – Summarizing discussions, action points, and decisions Project Documentation – Maintaining records for project scope, timelines, and progress Compliance & Policy Documentation – Ensuring adherence to company policies and legal requirements Microsoft Office & Google Suite – Proficiency in Word, Excel, PowerPoint, and Google Docs PDF Management – Editing, converting, and securing documents using Adobe Acrobat or online tools Cloud Collaboration – Using tools like Google Docs, Microsoft SharePoint, and Notion for team documentation Automated Documentation – Using AI tools and macros for generating reports Keeping Documents Up to Date – Regularly reviewing and updating content Ensuring Security & Confidentiality – Using passwords, access controls, and encryption Organizing Documents Efficiently – Using structured folders, tags, and metadata for easy retrieval Audience-Centered Writing – Tailoring documentation based on who will use it (technical, business, general users)

Operating Systems – Navigating Windows, macOS, or Linux File Management – Creating, saving, organizing, and retrieving files/folders Keyboard & Mouse Skills – Efficient typing, shortcuts, right/left-click functions Basic Software Usage – Microsoft Office (Word, Excel, PowerPoint) or Google Suite Internet Browsing – Using search engines, bookmarks, and browser settings Email Communication – Composing, sending, and managing emails (Gmail, Outlook) Cloud Computing – Using Google Drive, OneDrive, Dropbox for storage & collaboration Spreadsheets & Word Processing – Creating reports, formatting documents, using formulas Basic Troubleshooting – Resolving connectivity issues, frozen applications, and basic errors Security Awareness – Understanding malware, phishing, and best cybersecurity practices Social Media & Digital Communication – Using platforms like LinkedIn, Zoom, and Teams effectively Data Management – Using databases (Access, SQL) & advanced Excel functions (PivotTables, VLOOKUP) Graphic Design & Multimedia – Basic editing in Photoshop, Canva, or video editing software Coding & Scripting – Learning basic programming (Python, HTML, VBA for automation) Networking Basics – Understanding IP addresses, Wi-Fi setup, and troubleshooting Automation & Productivity Tools – Using macros, AI tools, and workflow automation

Understanding the Interface – Navigating the Timeline, Composition Panel, Effects Panel, and Layers Creating & Managing Compositions – Setting up resolution, frame rate, and duration Working with Layers – Arranging, trimming, and blending layers Basic Keyframing & Animation – Using Position, Scale, Rotation, and Opacity animations Using Effects & Presets – Applying and customizing built-in effects

Understanding VBA Environment – Opening the VBA Editor (ALT + F11), using Modules, UserForms Recording Macros – Automating simple tasks without writing code Basic Syntax & Variables – Declaring variables (Dim x As Integer), data types, constants UserForms & Controls – Creating custom forms for user input Interacting with Other Office Applications – Automating tasks across Excel, Word, and Outlook Advanced Data Manipulation Filtering & sorting data programmatically Copying & pasting between sheets efficiently Using Arrays & Collections – Storing multiple values for better performance Custom Functions (UDFs) – Creating reusable formulas with Function MyFunction() Operators & Expressions – Mathematical (+ - * /), logical (And, Or, Not) operations Message Boxes & Input Boxes – MsgBox "Hello World" and InputBox("Enter Value") Control Structures If...Then...Else – Conditional statements Select Case – Handling multiple conditions efficiently For...Next & Do While – Looping through data Working with Excel Objects Range Object – Range("A1").Value = 100 Cells Object – Cells(1,1).Value = "Test" Worksheets & Workbooks – Automating multi-sheet tasks Error Handling On Error Resume Next – Ignoring errors On Error GoTo ErrorHandler – Handling errors properly

Understanding Accounting Principles – GAAP (Generally Accepted Accounting Principles) & IFRS (International Financial Reporting Standards) Double-Entry Accounting – Debit & credit system for recording transactions Financial Statements Preparation – Balance sheet, income statement, cash flow statement Bank Reconciliation – Matching bank statements with accounting records