bqsgibu Meraj (READER)
List of Contributed Questions (Sorted by Newest to Oldest)
No Question(s) Posted yet!
List of Contributed Answer(s) (Sorted by Newest to Oldest)
I started video editing as a side hustle two years ago and now it's my full-time gig. Here's what worked for me as a beginner:My beginner-friendly approach:1. Start with People You Know- Edited my friend's wedding video for cheap- Helped my cousin with his YouTube gaming channel- Did music videos for local bands I knew- Created highlight reels for my nephew's sports team2. Social Media Hustle- Joined Facebook groups for creators in my niche- Offered free edits in exchange for testimonials- Shared editing tips on TikTok that showcased my skills- Used relevant hashtags like #videoeditorforhire3. Low-Barrier Platforms- Fiverr - started with $25 basic edits, now charge $150+- Reddit forums like r/forhire and r/creatorservices- Discord servers for specific content creator communities4. What I Learned the Hard Way- Don't undervalue yourself - cheap clients are often the most demanding- Get deposits upfront - 50% before starting work- Use contracts even for small projects- Set clear revision limits (I offer 2 rounds, then charge hourly)- Specialize early - I focused on YouTube vloggers and it worked great5. My Pricing Evolution- Month 1-3: $15-25/hour or flat project rates of $50-100- Month 4-12: $35-50/hour, projects $200-500- Year 2: $75+/hour, projects $800-2000+The game-changer for me: Creating template packages - I now offer "YouTube Starter Pack," "Social Media Ad Pack," etc. This makes it easier for clients to understand what they're buying and for me to deliver consistently.It's definitely a grind at first, but once you get a few happy clients and build your portfolio, the referrals start coming in naturally!
Answered for the Question: "How to find clients for video editing?"
I got burned by a fake ON protein tub last year, so I've become super careful about verification. Here's my personal checklist:My step-by-step inspection:1. Feel the tub - genuine ON tubs have a specific texture and weight2. Check the lid - should snap on securely, not feel loose or cheap3. Look at the label - colors should be bright, not washed out4. Scratch the code - use a coin, not your nail (can damage it)5. Verify immediately - before I even leave the store if possibleWhat the fake I bought had wrong:- Label was slightly crooked- Colors were dull compared to my previous genuine tub- Scratch-off area felt different - rougher texture- Powder clumped more and didn't mix as well- Taste was noticeably different - more artificial sweetener tasteWhere I find reliable products:- Direct from ON website (most expensive but guaranteed)- Major supplement chains (GNC, Vitamin Shoppe)- Reputable online retailers with direct distributor relationships- Local gyms that are authorized dealersWhat I learned: The small savings from questionable sellers isn't worth the risk. Counterfeit supplements can contain anything from fillers to potentially harmful substances. The verification system exists for a reason - use it every time!Now I only buy during legitimate sales from authorized retailers and always verify the code immediately. It's become part of my routine, just like checking expiration dates on food products.
Answered for the Question: "How to check optimum nutrition authenticity?"
As an Excel power user who works with VLOOKUP daily, here are several methods to remove the formula but keep the values:Method 1: Copy and Paste Special (Most Common)1. Select the cells with VLOOKUP formulas2. Ctrl+C to copy3. Right-click → Paste Special → Values (or Alt+E+S+V then Enter)4. The formulas are replaced with static valuesMethod 2: Drag and Replace1. Copy the VLOOKUP cells2. Right-click on the destination3. Choose "Values" from paste options (the clipboard with "123" icon)Method 3: Using Ribbon1. Select your VLOOKUP range2. Go to Home tab → Copy (or Ctrl+C)3. Home tab → Paste dropdown → Paste ValuesMethod 4: Keyboard Shortcut1. Copy with Ctrl+C2. Alt+E+S+V then Enter (older Excel versions)3. Or Ctrl+Alt+V then V then Enter (newer versions)Method 5: Convert Entire Column1. Select the entire column with VLOOKUPs2. Copy then Paste Special → Values3. This preserves all data in that columnImportant considerations:- Backup your file first - once formulas are gone, you can't undo after saving- Dependencies will break - other formulas referencing these cells will now reference static values- Data becomes static - it won't update if source data changesPro tip: I often keep the original formula columns hidden as backup, then use the paste-special-values for reporting or sharing files with others who don't need the live formulas.
Answered for the Question: "How to remove vlookup formula and keep data?"
Ah, the classic marble puzzle! I've solved several of these over the years. They typically involve getting a marble or ball bearing through a maze or series of obstacles. Here's my approach:General solving strategy:1. Understand the objective - What's the end goal? Usually to get a marble from point A to B2. Identify the obstacles - Look for gates, traps, dead ends, and moving parts3. Work backwards mentally - Sometimes it helps to think from the solution back to the start4. Gentle movements - Sudden jerks can cause marbles to get stuck in unintended placesCommon puzzle types and solutions:Maze-based puzzles:- Tilt gently and use subtle movements- Listen for clicks - some mechanisms activate with specific movements- Look for hidden pathways - some become visible only at certain anglesMechanical puzzles with levers/gates:- Sequence matters - you might need to activate mechanisms in specific order- Timing is crucial - some gates open only briefly- Multiple marbles - sometimes you need to use one marble to trigger a mechanism for anotherPro tips:- Patience is everything - these puzzles are designed to frustrate quick solutions- Clean the puzzle - dust and grime can hinder mechanical parts in vintage puzzles- Watch solution videos for your specific puzzle if you're really stuckThe satisfaction of finally solving one of these is amazing! I remember one that took me three weeks of occasional attempts before I discovered the secret rocking motion needed to unlock the final chamber.
Answered for the Question: "How to solve old time marble puzzle?"
As someone familiar with Arise and Crossover platforms, here's how to verify your "like" or endorsement:Understanding the Context:In platforms like Arise (remote work platform) and Crossover (remote employment), "likes" or verifications typically refer to:- Skill endorsements- Project completions- Performance ratings- Client feedback verificationVerification Process:1. Arise Platform Verification- Login to your Arise portal- Navigate to "My Profile" or "Performance"- Look for endorsement/rating sections- Client feedback should be visible once provided- Certifications tab for completed training verifications2. Crossover Verification- Access your Crossover workspace- Check "Achievements" or "Skills" section- Project completion certificates should be downloadable- Performance metrics are typically auto-verified- Client satisfaction scores appear after project completion3. Third-Party Verification- LinkedIn integration - some platforms allow exporting endorsements- Digital badges that can be shared externally- Verification links that can be sent to potential clients/employersCommon Issues and Solutions:"Like/Endorsement Not Appearing"- Wait 24-48 hours for system updates- Contact platform support with specific project details- Check if client completed their rating processBest Practices:- Regularly download and backup your verification documents- Update your LinkedIn with new endorsements- Keep records of client feedback for your portfolio- Understand each platform's specific verification systemThe verification process is typically automated, but if you're having specific issues, the platform support teams are usually responsive to verification requests.
Answered for the Question: "How to verify like in arise crossover?"