Basic Skills Every Division Order Analyst Needs By Marsha Breazeale Introduction
• Microsoft Learn (learn.microsoft.com) – Provides official Excel tutorials from Microsoft. • Excel Easy (www.excel-easy.com) – Offers beginner-to- advanced tutorials with step-by-step instructions. • Khan Academy (www.khanacademy.org) – Provides structured lessons on Excel basics. • YouTube Channels: • “ExcelIsFun” – Comprehensive tutorials on Excel functions. • “Leila Gharani” – Advanced Excel tips and tricks. • “Excel Campus” – Focuses on automation and pro- ductivity tools. • Coursera & edX (with free courses available) – Institutions such as Harvard and the University of Colorado offer free Excel courses. 2. Intermediate Working Knowledge of Microsoft Word and Outlook Microsoft Word Microsoft Word is essential for preparing reports, drafting legal documents, and formatting division orders. Key skills include: • Formatting Documents – Using styles, headings, and templates for professional documents. • Track Changes and Comments – Reviewing edits and maintaining version control in contracts. • Table of Contents and Indexing – Structuring large documents efficiently. • Mail Merge – Automating document creation for mass communication. Microsoft Outlook Microsoft Outlook is crucial for communication and document management. Analysts should be proficient in: • Email Organization – Using rules and folders to manage communications efficiently. • Calendar Management – Scheduling meetings and tracking deadlines. • Task Management – Utilizing task lists and reminders for workflow efficiency. • Advanced Search and Filters – Quickly locating emails and attachments.
A Division Order Analyst plays a crucial role in the oil and gas industry, ensuring that revenue is correctly distributed to the rightful mineral and royalty owners. Given the data-heavy nature of this role, a strong foundation in data management, numerical accuracy, and efficiency is essential. This white paper outlines the fundamental skills every Division Order Analyst should master, including an intermediate working knowledge of Microsoft Excel, Microsoft Word, Microsoft Outlook, proficient keyboard typing by touch, 10-key numeric entry, fast, accurate alpha-numeric data entry, and the ability to read, comprehend, and extract data from land contracts and deeds. Additionally, it provides resources and practice methods to enhance these skills. 1. Intermediate Working Knowledge of Microsoft Excel Microsoft Excel is a cornerstone tool for Division Order Analysts, used for tracking ownership data, calculating decimal interests, and validating revenue distributions. Analysts should be proficient in functions such as: • Data Sorting and Filtering – Sorting ownership records and filtering by specific criteria. • Basic and Advanced Formulas – Understanding SUM, VLOOKUP, HLOOKUP, IF, COUNTIF, INDEX/MATCH, and basic pivot tables. • Conditional Formatting – Highlighting inconsistencies or anomalies in ownership percentages. • Data Validation – Ensuring correct data entry by applying rules to cells. • Text Functions – TRIM, CONCATENATE, LEFT, RIGHT, MID, and TEXT to clean and format data. • Macros and Automation Basics – Using simple VBA scripts to automate repetitive tasks. Free Resources for Learning Excel There are many free online resources to learn Excel, including:
32
N at i onal A ssociation of D i v i s i on O rder A nalys t s
Made with FlippingBook Annual report maker