Excel 2010 slicer dashboardprojekty

Challenging opportunity for a skilled Excel Specialist. The details of the tasks are undefined due to insufficient information from the client. Candidate must be proficient in: - Data organization - Formula creation - Data analysis The size of the dataset is unknown and could range from small to large. You are expected to be able to handle any data size comfortably. While the type of analysis isn't specified, you should be skilled in: - Statistical analysis - Trend analysis - Financial analysis In summary, I need an Excel maestro who can confidently navigate any project, no matter how ambiguous. Your expertise, flexibility and adaptability will be essential for this project's success.

Need someone who can create a complete video course for teaching excel from beginner level to expert level. Videos can be short as 2 minutes each to 8 minutes maximum. Need high quality videos showing right from how to open an excel sheet on a computer to on how to write real tome formulas.

As someone who prides themselves on their ability to communicate complex ideas, I'm on the lookout for a Tableau specialist. This specialist would be proficient in curating informative, visually engaging dashboards from self-collected datasets. Key tasks will include: - Data visualization - Dashboard creation These dashboards must be efficient in communicating insights to stakeholders. Ideal candidates will have a strong understanding of data analytics, an eye for detail, and excellent communication skills to present these insights in a coherent and straightforward manner. Strong experience in Tableau is an absolute must. If you thrive in translating data into compelling visuals that drive decision making, this project might be for you.

I am looking for a proficient Excel expert who is highly experienced in financial data analysis. You will primarily be tasked with conducting comprehensive revenue and expense analysis. The ensuing breakdown of financial information will allow us to understand and evaluate our company's financial health. Ideal Skills and Experience: - Deep understanding of Excel, particularly in data analysis - Expertise in Financial analysis, specifically revenue and expense analysis is a must - Excellent in applying Excel for financial forecasting - Capacity to design efficient spreadsheets that emphasizes readability and ease of use - Fluency in formulating functions to automate data computations.

I am in urgent need of a specialist with deep knowledge of the Tron blockchain platform. The task at hand consists of deploying a pre-existing smart contract. To excel in this, you'll require: - Proficiency and extensive experience with Tron blockchain. - Knowledge and previous experience with smart contract deployments. - Ability to deliver the task as soon as possible. Your prime responsibility is to successfully deploy this existing contract on the Tron chain. No development or modification is required - I need an expert who can handle the deployment swiftly and flawlessly. If you have the knack for troubleshooting blockchain challenges and are comfortable working under tight schedules, this is for you.

I'm looking for a highly UI/UX app designer to c...Create an account and log in - Search for local makeup artists - View artist portfolios - Book appointments - View appointments and previous appointments - Make payments - Receive notifications Makeup artists need to be able to: - Manage their availability and schedule - Receive and manage booking requests - Manage client profiles - Maintain a list of services, prices and pictures. - Simple dashboard for their total bookings and revenue. As well as A prototype is needed for the developers to develop the App and any technical requirements needed to assist the developer. Your insights on how to optimize user experience for both sets of users will be highly valued. Previous experience in e-commerce or booking applications w...

I cannot log in to my WordPress Dashboard for my website, because of an issue with one (or more plugins). I can give you access to Wordpress and website hosting. Please type "blue" into your offer so I know you read this.

I'm seeking an experienced Excel VBA expert to help me automate some basic, repetitive data entry and formatting tasks. Key Requirements: - Automate basic data entry and formatting tasks in Excel - Develop VBA script to ensure automation runs smoothly Ideal Skills and Experience: - Proven experience in developing VBA scripts for Excel - Strong understanding of Excel functions and data formatting - Ability to create automation systems that run seamlessly without user interaction Please note, no user interaction is required for this project. The VBA program should be designed to run automatically once set up. This task is relatively simple but needs to be executed precisely and efficiently. Looking forward to working with a professional who can deliver ...

...Features: - Product Catalog Management: The platform should provide a user-friendly and efficient way to manage a large number of products, including variations and descriptions. - Shopping Cart Management: A seamless and reliable shopping cart experience is essential, ensuring smooth transactions and customer satisfaction. - Vendor & Customer Dashboard: Separate dashboard for vendors to manage their products, orders, and customers. Along with a customer dashboard for a delightful shopping experience. - Logistics and Services: Efficient integration of logistics and services to ensure timely delivery and customer satisfaction. Key Points: - Scale: The platform is expected to handle an extensive range of products and a high number of customers. A scalable and rob...

I'm seeking an expert in Excel and VBA who can work on an an existing financial model. The primary tasks will involve optimizing formulas, macros, and implementing data validation. I am looking for an hourly regular working engagement where the person will sit with me from time to time online and solve for things one at a time. I cant share workbooks as I have some IP related restrictions so person will have to work on my system, remotely. For Faridabad, Haryana based freelancers, we can do it in physical mode too. Key areas of focus will be: - Refining Formulas and Calculations. - Improving Data Organization and Management - Managing , improving the existing VBAs

I'm in need of a skilled professional who can diligently carry out a large volume of data entry involving text, numbers, and images. The data is to be accurately entered into an Excel spreadsheet. Ideal Skills: - Proficiency in Excel - Accuracy in data entry - Ability to handle large volumes of data - Familiarity with processing text, numeric, and image data The right freelancer should have substantial experience handling this type of project and able to demonstrate precision and attention to detail.

I'm seeking an experienced Brawl Stars coach who can help me elevate my gameplay to the next level. Having played on both Android and iOS platforms, I've developed a decent understanding of the game but I want to push my skills further to become a formidable competitor. **What I'm Looking For:** - **Expertise in Brawl Stars:** Someone who has a track record of high achievement in the game and can provide proof of their skills. - **Coaching Ability:** Not just a great player, but someone who can teach. You should be able to analyze my gameplay and offer actionable advice. - **Focus Areas:** Since I'm looking to generally improve my gameplay, having a broad understanding of key strategies, character usage, and gameplay mechanics is essential. **Expected Outcomes:** - ...

I'm in need of a skilled Excel expert who can help me build a formula that integrates data across multiple sheets. The formula needs to leverage advanced functions like VLOOKUP, INDEX/MATCH, and ARRAY. Key Requirements: - Advanced Excel proficiency - Expertise in VLOOKUP, INDEX/MATCH, and ARRAY functions - Experience with multiple sheets data integration - Strong problem-solving skills and attention to detail Please note that this isn't a project suited for beginners in Excel. You should have a proven track record in working with complex formulas and integrating data across different sheets. Your ability to deliver accurate and efficient solutions will be greatly valued.

I am struggling with incorrect results when attempting to subtract two values in a column of clock times in Excel. My data is in a 12-hour clock format, and I signify AM and PM directly within the time cells. I require an expert in Excel to address this issue promptly. To take on this project successfully, you should have: - Proficient Excel skills - Solid understanding of the 12-hour time format and functions in Excel - Ability to troubleshoot and rectify the problem quickly

I have some duplicate data that need to be copied to different sheets. - The project entails copying the duplicate information into different sheets. - The reasoning behind organizing the data into separate sheets is so that I can perform statistical analysis on each set distinctly. This will enable me to have cle...some duplicate data that need to be copied to different sheets. - The project entails copying the duplicate information into different sheets. - The reasoning behind organizing the data into separate sheets is so that I can perform statistical analysis on each set distinctly. This will enable me to have cleaner and clearer results, helping in decision making. Ideal Skills: - Proficient in Excel or any other data manipulation software - Experience with data entry a...

Financial Statements based on Excel template and Data - you product financial Statement with filled out excel based on data given We need an expert Freelancer to enter basic financials data to attached financial Projection in Excel and produce a profit loss statement based on this Excel attached and the data of company projected Revenues and expenses Simple if you have done it before You will send us back the filled out excel with sheet tabs including the Financial Planning Tab and Profit Loss. Budget is $200 - $300 +/- Very Simple just summarize and detail the data correctly any questions or data you need for this ( not given in attachments in zip ) we will give you You need to put all Hungarian Forint Currency Do the conversion from Euro as shown i...

I am looking for an experienced freelancer who will assist with copying data from my Microsoft Word and Excel documents. The copied data will then be pasted into Google Sheets. Key tasks include: - Copying data accurately from existing Word and Excel documents - Pasting the data into a new Google Sheets document - Organizing the data in a clear, readable format Ideal skills and experience: - Proficiency with Excel and Google Sheets - Demonstrated experience in data entry - High level of accuracy and attention to detail.

Seeking a freelancer with expertise in Excel and PowerPoint for a project involving more than 5 Excel files. The task at hand is to assist with presentation design. Skills and Experience required: - Proficiency in Excel and PowerPoint - Strong design skills - Experience with handling multiple Excel files - Attention to detail and ability to create visually appealing presentations

I am seeking a proficient Frontend Developer with a strong experience in developing corporate and professional websites. Design is ready in Figma. Here are the key requirements for the project: - Creation of a modern website with a corporate and professional design - Development of a responsive User Interface - Ability to develop a customizable home page and a landing page from admin dashboard - Incorporation of contact forms and blog/newsletter section Skills and Experience: - Strong proficiency in UI development and front-end framework customization - Previous work on similar corporate themed websites - Experience in developing a fully responsive design - Knowledge on blog/newsletter sections and contact forms integration is a must. Your portfolio showcasing your recent ...

I need a professional with a significant background in data management, who can assist me in streaming entire worksheets live from my desktop Excel file to my Google Sheets. The core requirement is to: - Stream the entirety of my existing Excel worksheet data into Google Sheets instantaneously and update it in real-time. The ideal freelancer should: - Be experienced in data integration across various platforms. - Possess comprehensive expertise in both Excel and Google Sheets. - Have a past track record of successfully completed data streaming related projects. - Be able to implement a solution for real-time data update.

I'm seeking a versatile individual to assist in constructing the digital framework for a groundbreaking think tank. The ideal candidate will excel in the following areas: - Website Development: You will be responsible for constructing a user-friendly platform that encompasses discussion forums, document sharing, and other essential features. - Forum Features: You'll need to design and implement efficient user profiles, thread categorization, and effective comment moderation. - Document Sharing: The platform should support the sharing and collaboration of research papers and reports. Experience or skills in the following areas are highly valuable: - Intelligence analysis and investigative journalism - Data analytics and project management - Mental health and spiritual m...

...number, contact numbers, email IDs, premium collected, next expiry and other insurance related parameters. - A fully functional dashboard: Capabilities include report generation, tracking of premium payments, calculation of policy expiry dates, display of policy summary, automated notifications, search/filter options, display of policy status, enabling data exports, provision of visual graphical representations, user login and access control for security purposes. The system should also be equipped with capabilities for client information management, policy tracking, automated alerts and reminders, commission calculation and provide an overview via the dashboard. The ideal candidate should possess the required skills in systems design and data management. They should als...

I need a Django developer to create a blogging website for me. - The main purpose of this website is blogging. - I'd like to integrate Instagram into the website. - I prefer to manage the website content through a custom admin dashboard. Ideal Skills and Experience: - Proficient in Django web development. - Familiarity with integrating social media platforms, especially Instagram. - Ability to create a user-friendly custom admin dashboard for content management.

I am looking for a detail-oriented professional who can assist in copying and pasting data for my business, BD Company. Required tasks: - Copy data provided in Excel sheets. Ideal Skills: - Proficient in Microsoft Excel - High attention to detail - Strong data entry skills Apply only BD interested person.

We are seeking freelancer expert to write a new enhancement in our exosting an On-Prem AI Video analytics (VA) software. Existing products works on live feed, find EHS violations after running models on frames and insert into DB. It has an existing dashboard as well. New features will primarily focus on analyzing traffic violations. The new enhancement should be able to handle ANPR and Speed Violation detection based on a live video feed from inside plant roads. Key Features: The software should provide - check valid vehicle # with registered list for unauthorized entry. - Speed violation to handle 5 to 40 Kmph threshold - Violation Snapshot/Video will be stored on on-prem server. - Each violation with trigger Auto Email and/or SMS notific...

...Customization options : Users can choose various customisation options mentioned on design details page 3. Chat : Redirect to WhatsApp from design details page for seamless sales and support experience. Website Features: 1. User Authentication(designers and customers): Implement user registration and login functionality to enable personalized experiences and order tracking. 2. Designer Dashboard: Create a dashboard for designers to upload their designs, manage inventory, and track orders. 3. Search and Filter: Enable users to search for designs based on categories such as type of jewelry, designer, or style, and apply filters for metal type and stone preference. 4. Design Detail Pages: Develop detailed pages for each design, showcasing images, descriptions, and custo...

I am looking for a developer who can design a data uploader for my website. The primary purpose of this tool is to allow me to upload different types of files such as Excel spreadsheets, CSV files and Text files into my website's backend. Key Requirements: - Support for multiple file types: The uploader should be able to accept a variety of file formats, including Excel spreadsheets, CSV files, and Text files. - Basic Data Validation: Before the data is uploaded, I need this tool to perform basic data validation. This would involve checking for field completeness to ensure that all necessary fields are populated before the upload is allowed. Ideal Skills and Experience: - Proficiency in web development: The ideal candidate should have a strong background in web develo...

I'm looking for an google sheets / excel guru who can construct an advanced drop-down lookup system for my entire sheet. This system should include multiple variables that will inform the price from the database. Currently looking up values manually in a series of tables, tables may need reformatting to allow for efficient searching Key skills and experience: - Proficient in MS Excel Advanced Functions - Experience with both numerical and text data - Knowledge of creating drop-down lookups for entire sheets The final product should streamline our decision-making process by providing agile, accurate prices based on the selected variables. Your comprehensive understanding and application of numerical and text data within an Excel environment will be key to the s...

I require a VBA Developer well-versed in automating repetitive tasks in Microsoft Excel. Your primary task is to automate my existing work functions to increase efficiency. Key Responsibilities: * Understand the current Excel operations and identify scope for improvement. * Develop VBA codes to automate basic standard operations. * Test the robustness and accuracy of the automation. * Combining 2 files into 1 pdf. 1st file is pdf and 2nd is excel(with selected sheets, and selected columns within sheets) Desired Skills & Experience: * Proficient in VBA, specifically for Microsoft Excel. * Experience in automating repetitive tasks. * Sharp problem-solving and debugging skills.

Seeking a proficient Excel VBA developer to aid in the centralization and automation of tasks in Excel 2010. Project requirements include: - Expertise in Excel latest version - Strong understanding of EXCEL VBA for automation purposes. Please note, specific tasks and functions to be automated in VBA have yet to be defined. Flexibility and broad knowledge in different Excel functions will be considered an asset.

I am looking for a professional with strong data entry skills to assist in transferring text data from digital documents into an excel sheet. The successful candidate should possess: - Reliable accuracy in typing - Fast typing speed (numeric keypad advantageous) - Proficiency in Excel (VLOOKUP, SUMIFS, Pivot Tables, etc.) - Able to interpret written information swiftly - Excellent attention to detail for proofreading entered data. This task will require someone with experience in handling large volumes of data entry, with absolute prioritization on maintaining the integrity and accuracy of the inputted data. Any previous involvement in similar projects handling text data is highly desirable. Understanding of and/or a background in just managing digital document data will...

Necesito un excel simplificado y parametrizado (formulado) para comparar si vale la pena comprar o alquilar una propiedad, según gastos y costo de oportunidad.

I need someone with specialized skills in password recovery to restore a forgotten password for an Microsoft Excel worksheet. This task requires a professional password hacker. I require one spreadsheet opened and password recovered and removed. Skills and Experience required: • Proficiency in programming languages, particularly those relevant to password recovery. • Expertise in methods of password recovery for Microsoft Excel worksheet xlsx files. • Strong ethics - the information on this spreadsheet must stay confidential. • Can deliver results within 7 days. • Will pay on successful confirmed completion only.

...coupled with experience developing web applications and job portals. The job portal needs to encompass: * Job search functionality: This is a pivotal feature that needs to be user-friendly and efficient. Users should be able to search jobs programmatically. * User registration and login: There should be a secure and easily manageable user authentication system. * Employer dashboard: Employers should have a dashboard enabling them to post jobs, view applicants, and manage listings. Additional features desired: * Resume builder: To aid applicants in creating professional resumes. * Job application tracking: Feature for users to monitor their application progress. * Job alerts: Mechanism to dispatch notifications to users about new job postings related to their inter...

I require a proficient freelancer to design a distinctive Excel file that will be used for web form completion. Once the Excel file is uploaded, the system should automatically read and fill the corresponding fields. These may be a composition of dropdowns, text or checkboxes with comprehensive validation, such as numbers-only constraints, email format requirements, date format validation, dropdown list checks, value ranges among others. Ideal Skills: -Qualified in Excel -Understanding of data validation Experience: -Web development -Scripting in Excel -Web form design -Experience designing similar projects Please note that while the specific dropdown fields were not detailed, anticipate flexibility and adaptability in the code to conform to possible changes...

...an intuitive application. This app is intended to utilize LangChain and OpenAI's language model in categorizing PDF files into different groups; namely invoices, HR-contracts, or MOUs and then under go different ways for each document catagory: A. in case of invoice: - extract the data inside invoice (invoice number, date, buyer name, total amount sold, and total due amount) and save them in an Excel file. B. In case of HR-contract: - simply move the file from the existing location to the HR-contract folder. C. In case of MOU: - simply move the MOU from the existing location to the MOU folder. Details: - Your responsibility is to build a desktop application that processes and accurately categorizes data from complete PDF files. - You are required to utilize LangChain for...

I require a proficient Excel expert with strong skills in data analysis and organization. The primary tasks you will handle include: - Analyzing business-related data - Organizing the analyzed data in an easy-to-understand format The purpose of these tasks is to help streamline business reporting processes. You must be adept at dissecting large volumes of data and summarizing key points to help inform business decisions. The final deliverable should be a standard Excel file that details the organized and analysed data. Relevant skills needed include data analysis, Excel proficiency, and a keen understanding of business data interpretation.

I'm seeking a computer science tutor to guide me through QuickBooks and Excel. - Topics include QuickBooks, Excel, data structures, algorithms and programming languages. - Primarily need help with data entry and organization in QuickBooks and Excel. - Additionally, assistance with Formulas and Functions in Excel is required. Ideal candidate should have: - Proficiency in QuickBooks, Excel and knowledge of data structures and algorithms. - Strong background in programming languages. - Experience in tutoring or teaching will be a plus. Please note that the volume of entries or rows of data is minimal, less than 100. Looking forward to your proposals!

...project. It requires 2 sections • Employee section • User section And the whole concept is about creating a conditional & dynamic form using gravity form or any other form plugin, and adjust some automations using zapier or any other automation tool like that. Employee section: • Employee register form • Employee dashboard Employee register form ham gravity form main bhi bana sakte hai, ya fir “ultimate members” plugin ko bhi use karke bana sakte hai. Iss se employee ko ek dashboard bhi mil jayega. User Section: • User ko register karne keliye bhi ek form rehega. Jisko ham gravity form main bhi bana sakte hai, ya fir “ultimate members” ko use karke bhi bana sakte hai. • User project submission form (using gravity...

...charged hours multiplied with employees cost, wip production that corresponds to cost plus the margin - Implementing an overview dashboard to show for a selected month and by first half & second half (i.e. by default the current one) for each employee overall chargeability, overall available time, chargeability (calculated as total hours poste on a chargeable job dived by working hours available in the period – excluding holiday) [OPTIONAL] User access management: -Admin role: full access - job owner: full access to a set of job views (could perform data entry) - job viewer: access to a set of job view in read mode - advanced viewer: access to overview dashboard - I prefer a design that is simple and minimalistic, focusing more on functionality and easy user e...

I'm in need of a developer with specific experience in creating a serial port driver (RS232) for a Windows operating system. The key requirements include: - The driver needs to be developed using the C programming language. Profound knowledge of C, Windows APIs and asynchronous serial communication (RS232) is essential. - As part of the project, a communication dashboard needs to be created too. The dashboard must have the capacity to track live data, support multiple connections and should incorporate a customizable interface. Therefore, seeking candidates with strong skills in GUI development, database management and networking too. Looking forward to discussing this project with interested and capable applicants.

Are you looking to master SQL, Excel, or Python? Look no further! With years of experience in data analysis and programming, I offer comprehensive tutoring services tailored to your learning needs. **What I Offer:** 1. **SQL Mastery:** From basic queries to advanced database management, I'll guide you through understanding SQL syntax, optimizing queries, and database design. 2. **Excel Expertise:** Whether you're a beginner or looking to enhance your Excel skills, I'll cover everything from formulas and functions to data visualization and automation. 3. **Python Proficiency:** Dive into the world of Python programming with personalized lessons covering fundamental concepts, data manipulation, scripting, and more. **Why Choose Me?** - **Tailored App...

I'm looking for a capable designer who can create a modern style title card for a jukebox. Key Requirements: - The design must be modern in style - The final deliverable should be in a word or excel format to allow for editing Content: - The title card should include the song title and artist in the right portion - A photo element should also be incorporated for visual appeal in the left portion. I'd like a card similar to the one you see here. It's exactly 18cm wide x 12cm high. However, the photo portion should be smaller, as the text does not contain the Artist, which I need. I have attached some examples here. Photos # 4 5 and 6 are from my actual machine. I need to edit and make 100 of these. There should be 22 columns on the right side for the Numbe...

I am looking for an exceptional web developer to create a we...website for listing rental properties. The main objective of this website is to facilitate property owners in advertising their rental properties and prospective tenants in their property search. Key Features Required: - User Registration and Personal Dashboard: The website should allow users to create personal accounts, list their properties, and view responses. Skills and Experience Required: - Proven track record in website development specifically for property rental, or similar industry. - Proficiency in database management for user dashboard functionality. Note: This project does not require integration of a mapping feature. Anticipate a clean, user-friendly interface that prioritizes ease of property li...

...but not essential to be an expert. Anyone with generic database experience (with different databases) can also apply. Skills already acquired from previously doing this work: - Understand database schema - understand database structures - create database tables based on bespoke requirements (training included) - Working with relatively large sets of data - has exporting skills into SQL - Excel and VBA, - Has experience in different querying languages - Proficient in Microsoft SQL Server Management Studio - Familiarity with Windows OS - Experience in handling multiple databases with SQL - Strong troubleshooting skills I currently manage over 11 databases via Microsoft SQL Server Management Studio, and my system operates on Windows. You would be working an 8hr paid day in t...

I'm seeking an expert in Excel and VBA who can work on an an existing financial model. The primary tasks will involve optimizing formulas, macros, and implementing data validation. I am looking for an hourly regular working engagement where the person will sit with me from time to time online and solve for things one at a time. I cant share workbooks as I have some IP related restrictions so person will have to work on my system, remotely. For Faridabad, Haryana based freelancers, we can do it in physical mode too. Key areas of focus will be: - Refining Formulas and Calculations. - Improving Data Organization and Management - Managing , improving the existing VBAs

I am in need of an excellently crafted web form that can carry out addition calculations. The main purpose of this form is to accurately calculate the cost of chosen servi...system should be able to add up the costs of selected services. - Data entry: Your form would need to support product selection-based data entries. - User interface: the form should be easy to navigate, with clear instructions for inputting service choices. Ideal Candidate: - Proven experience in designing excel forms with integrated calculation logic. - Ability to design a user friendly interface. - Eye for detail, as the calculator must produce very accurate results. - Strong knowledge of Excel features and data calculation techniques. - Excellent communication skills to understand requirements and del...

I'm seeking a proficient Excel expert who can assist me with enhancing my current study time tracker. I need the following features to be incorporated: - Auto-calculation of total study hours: I'd like for this to be automatically summed up based on the inputs provided. - Auto-calculation of average study hours per day: This should also be done automatically, providing me with a clear view of my daily commitment. - Study hours per subject: I require a part of the spreadsheet to allocate study hours to specific topics that I am learning. The spreadsheet will be utilized for tracking my study progress across different subjects. It should allow for easy input of study hours and materials covered. I will provide the current version of the spreadsheet to the chosen freelan...

...task will be to fix a challenge I'm facing with PHPSpreadsheet. My Excel data is not being imported correctly into MySQL as tables are not being created. Despite no error messages alerting me to these issues, the hiccup persists. Below is a more detailed description. After login, the user uploads 4 required and 2 optional Excel files on the dashboard page. The files are uploaded to an “upload” folder on the server and the file names and other info are stored in the “files” table of the mysql database. All of the above works with no problems. Once the actions above are complete, a button at the bottom of the dashboard page is activated. When the button is pressed, PHPSpreadsheet is used to move the data from the Excel ...

I have an IPA file (executable) and the objective is to add in certain features (very simple features to begin with for this part 1 of the improvement) and possibly remove some useless features / calculations that may not be needed. Simply a cleanup of the UI. There is no major change into the design and purpose of the app, its simply just as stated; removing redundant features and to add some life improvements to the current App. Feel free to ask me any questions if you want a more in detail description and or images to the current app. Mind you we will be screening candidates to work with before replying to your message as from previous work we notice a lot of automated bidders and responders. A little detail about the app: - It is simply a calculation helper to tell users what...