Is this you? As a journalist, you can create a free Muck Rack account to customize your profile, list your contact preferences, and upload a portfolio of your best work.
Claim your profile
Articles by Joshua Crowder
Methods for Filtering Google Searches
While Search results usually return the most relevant information, they tend to be overwhelming. This is especially true if you end up searching beyond the tenth result when looking for something specific. What you might not know is that Google offers various search techniques and operators to help users filter search results effectively. In this article, I provide some of the more useful filtering methods that you may find useful for conducting Google searches.
Use Microsoft Word, PowerPoint, and Excel at No Cost
With multiple free options online for creating spreadsheets, presentations, and conducting word processing, Microsoft offers an option that allows you to use many of its most popular apps online. To access Microsoft tools such as Word, PowerPoint, and Excel, all you need to do is create a new Microsoft account or log in to your current Microsoft account. With the Microsoft 365 free version of these apps, you do not necessarily get all the features that you will see in the desktop version.
Create CSV File From a Spreadsheet in Excel
There is a standard way of generating a CSV by saving a file as that file type and it can also be done with Visual Basic Applications (VBA) in Excel. This article is for someone who has data in the stand Excel format and needs to generate a CSV format. This tutorial will start out discussing two ways to generate a CSV in Excel followed by discussing how the VBA option can be customized. Unfortunately, the VBA will only work on Windows operating systems.
Convert Comma Separated Data Into Columns in Excel
In this tutorial, I discuss ways to separate comma-delimited data that appear in one column of an Excel Spreadsheet. Sometimes data like address information and names are grouped together from legacy data. Over the years, Excel has developed several ways to separate this type of data without using complex formulas. Look at the sample data image below. The data contains a first name, age, gender, and city. We are going to use 3 methods to split the data into separate columns.
VBA to Open Mac Programs From Excel
In this article, I will give you some options of programs that you can open while working in Excel using Visual Basic Applications (VBA) by creating a macro. Often, we find ourselves opening multiple programs to complete processes while working on our Excel files. With the code presented to you in this article, you may open one or more programs at once while working in Excel for Mac. I will cover a few specific examples that I have used in the following sections.
Auto Create Excel Sheets Based on Dates
When we routinely create Excel sheets from templates, we save time because another sheet doesn't need to be designed. If you have a similar process that you maintain on a daily basis, you can further automate your process. Running a macro whenever your workbook is reopened can ensure that a new sheet is created for the workday. If the sheet is already created, sheet creation can be ignored.
How to Dynamically Populate Excel Ranges
You are here because you are trying to figure out how to populate data in one or more ranges of an Excel workbook automatically. I will cover several ways to conduct this type of task to ensure that I have a better chance of helping you with your specific situation. I will start by showing you how to reference a whole column dynamically.
Use VBA to Insert Shapes in Excel
If you have a lot of shapes that need to be entered into your Excel workbook, you can now insert shapes automatically. The Visual Basic Applications (VBA) in this article allows you to select a range of cells for your shapes to be auto fitted to. This macro can make the task of adding multiple shapes to your Excel workbook projects less redundant. This option is really beneficial when you need to add buttons as a shape and they need to appear in the same row or column.
Use VBA to Insert Checkboxes in Excel
If you have many checkboxes that need to be entered into your Excel workbooks, you now can insert checkboxes automatically. The Visual Basic Applications (VBA) macro in the article allows you to select a range of cells for your checkboxes to be auto fitted into. in addition, the checkboxes are automatically assigned to the cells that it is placed in. Insert Checkboxes Macro The VBA code (macro) that can insert checkboxes can be found in the image below.
The Dive Deep Leadership Principle: Staying Connected to the Details
To dive deep as a leader means acting to obtain knowledge and understanding of the full scope of a situation. Making assumptions about problems or events could open the door to history repeating itself or compiling unnecessary errors. In the domain of leadership, the principle of dive deep relates to how a leader conducts themselves and how their team operates.
The Dive Deep Leadership Principle: Staying Connected to the Details
What Is the "Dive Deep" Leadership Principle? To dive deep as a leader means acting to obtain knowledge and understanding of the full scope of a situation. Making assumptions about problems or events could open the door to history repeating itself or compiling unnecessary errors. In the domain of leadership, the principle of "dive deep" relates to how a leader conducts themselves and how their team operates.
Decoding Amazon's Principles of Effective Management
This rather lengthy article describes how leadership at Amazon is recognized, practiced, educated, and executed. Amazon's 16 management principles are essential for the company's continued growth and success. Applicants for Amazon must understand these principles and use the star method to answer interview questions directly related to the principles.
How to Use the ROW Function in Excel
The Purpose of the ROW Function in Excel The ROW function in Excel is a simple formula that can yield powerful results depending on the spreadsheet application that you use it for. In this tutorial, we will look closely at the ROW function in Excel and see how it can be applied to various data scenarios. Whether you are a beginner or an experienced Excel user, this guide will give you some added knowledge that you could use to better utilize this function in the future.
Excel VBA Code That Make Sense to Run at Shut Down
Believe it or not, shutting down your Excel workbook can actually help you be more productive. How you may ask? When you shut down Excel you can trigger a macro to run and complete specific tasks. For some people, it may be a dream to have a mechanism to display a reminder of what to update next. Others may enjoy automatically saving a backup version of the file. In this article, I demonstrate some great reasons to run macros to be set to run before the document closes automatically.
Excel Visual Basic Code Examples That Open Hyperlinks
There are many ways to open hyperlinks from an Excel file and that's exactly what this article is all about. Opening websites automatically can help you streamline your processes when those processes require updating websites or conducting research. In this article, I provide several Visual Basic codes that all open hyperlinks in various ways for different applications. You can find a list of the codes used in this article here.
Excel VBA Code That Make Sense to Run at Startup
A key ingredient to growth is increased productivity which can be achieved automatically in your spreadsheets. Setting yourself up for success by assigning macros to run when your Excel file initially opens can put you in a position to quickly begin your work day by setting reminders and document customizations. This article will cover some easy-to-implement VBA in Excel that make sense to run automatically when your Excel file opens. Find a link to all the codes for this article here.
Common Tasks a New Excel User Should Learn
It is essential for beginners of Excel to learn a variety of tasks followed by more training to build on those previously learned tasks. It's best to start with common tasks in Excel to give you a strong foundation because building on them will put you on a path to becoming an expert in Excel. In this article, I present to you 4 common tasks in Excel that you should know and get used to if you are to continue using the software. 1.
How to Use the XLOOKUP Function in Excel
The Purpose of the XLOOKUP Function The XLOOKUP function is a recent addition to Excel's vast amount of lookup functions. If you are old-school Excel like me, it's really tough to stop using what you are used to using or in my case the VLOOKUP function. In this tutorial, we take a close look at how you use the XLOOKUP function to locate values in a range. The XLOOKUP Function Syntax & Arguments Below you'll find the syntax of the XLOOKUP function in bold.
Strive to be Earth's Best Employer: The Ultimate Commitment to People-Centric Leadership
In the domain of leadership principles, the principle of striving to be Earth's Best Employer was formulated by Amazon in 2021. This principle rises above the ordinary, underscoring a dedication to creating an environment at the workplace that fosters empowerment, diversity, growth, and personal success for all employees. As I have worked for the company, I have an understanding that many of the attributes of this principle already ran deep within the company before its announcement.
Strive to Be Earth's Best Employer: The Ultimate Commitment to People-Centric Leadership
In the domain of leadership, the principle of striving to be "Earth's Best Employer" was formulated by Amazon in 2021. This principle rises above the ordinary, as it underscores a dedication to creating an environment at the workplace that fosters empowerment, diversity, growth, and personal success for all employees. As someone who has worked for the company, I recognized (early on) that many of the attributes of this principle ran deep within Amazon before its official announcement.
How to Use an Excel Macro to Hide Rows From Unauthorized Users
Hiding rows in Excel from specific people can be challenging. When you do hide data there is the task of using a password to unhide sensitive areas. What if you could make a list of users who have access? I have developed a code that will leave a specified row viewable only if a user is on a list in another sheet.
How to Use an Excel Macro to Hide Columns From Unauthorized Users
Hiding columns from specific users in Excel can be challenging or downright annoying for users who need quick access to the data. There is no automated solution available to solve this problem using Visual Basic in Excel. I have just developed a code that will leave a specified column open if a user is on a list. If the user does not appear to be on the list, then the column will remain hidden and locked with a default password. Let me walk you through setting up your worksheet.
Create a Button in Excel to Open Multiple Hyperlinks
In an effort to become more efficient on tasks, sometimes you just have to simplify the process by getting all your data right out in the open. I started a new process recently that required me to view the same webpage with different views. The problem was setting up each page. I had to set a date and a number of other attributes on each page to find the data that I needed to create my report.
Use VBA to Open a URL From a Button
It's convenient to have the freedom of opening a uniform resource locator (URL) from your Excel files. Here I'm going to cover a few different ways you can open a URL from a button to display a webpage. The first part of this tutorial describes how to add a macro to a button followed by different options for opening a URL with a button. Adding a Button & Assigning a Macro Adding a button to activate Visual Basic Applications (VBA) code is quite easy. Go to the insert tab and insert a shape.
Create a Calculator With HTML
In this article, I will show you how to create the basic HTML and Java Script structure to build a calculator. If you have the inputs for an equation, you should be able to build a calculator out of it. Building an HTML Calculator Building a calculator for your website can allow for a better user experience. For instance, if you are a real estate agent, you may want to make it possible to calculate mortgage payments directly from your website.
Customer Obsession: The Leadership Principle for Business Success
Jeff Bezos, the founder and former CEO of Amazon, is known for his unwavering obsession with Amazon customers. His customer-centric philosophy has been a key driver of Amazon's success and has helped the retail giant become one of the world's most valuable and innovative companies. Bezos once famously said, “We’re not competitor obsessed, we’re customer obsessed.
Customer Obsession: The Leadership Principle for Business Success
Amazon's Customer-Centric Philosophy Jeff Bezos, the founder and former CEO of Amazon, is known for his unwavering obsession with Amazon customers. His customer-centric philosophy has been a key driver of Amazon's success and has helped the retail giant become one of the world's most valuable and innovative companies. Bezos once famously said, "We're not competitor obsessed, we're customer obsessed.
Bias for Action In The Workplace - A Leadership Principle
Simply put, bias for action in the workplace is a mindset that emphasizes acting and making decisions quickly. This is true for all situations, even in the face of incomplete information or ambiguity. Consider it a proactive approach that prioritizes getting things done over indecisiveness, analysis, or paralysis. Bias for action involves a willingness to take risks, learn from mistakes, and focus on results with urgency.
Origins of the Name James
The name James has its origins in the Hebrew name "Yaakov" meaning "one who follows" or "supplanter." Historically, a supplanter may have been one who gained power by overthrowing a ruler or the property of another. In the Bible, James is seen as an English translation of the name Jacob. Jacob was born by one of the twelve sons of Isaac and also the father of the twelve tribes of Israel. In the English-speaking world, James was popularized through the New Testament of the Bible.
Origins of the Name James
Origins of the Name James The name James has its origins in the Hebrew name "Yaakov" meaning "one who follows" or "supplanter." Historically, a supplanter may have been one who gained power by overthrowing a ruler or the property of another. In the Bible, James is seen as an English translation of the name Jacob. Jacob was born by one of the twelve sons of Isaac and also the father of the twelve tribes of Israel.
The Line: A Futuristic Eco-City Pushing the Limits of Sustainability
The Line is a 170-kilometer-long, 500-meter-high linear city that has sparked a heated debate about the future of architecture and urban planning. The futuristic city, part of the Kingdom of Saudi Arabia's new nation-building megadevelopment NEOM, promises a carbon-free lifestyle for over 9 million people, with cutting-edge technologies and a minimal physical footprint.
Understanding Amazon's Management Principles
Amazon's 16 management principles include customer obsession, ownership, invent and simplify, are right, a lot, learn and be curious, hire and develop the best, insist on the highest standards, thinking big, bias for action, frugality, earn trust, dive deep, have backbone; disagree and commit, deliver results, strive to be earth's best employer, and success and scale bring broad responsibility. Each principle is essential for the company's continued growth and success.
Strategies to Reduce Taxes in Retirement
Retirement can be a time of great financial uncertainty. While you may have worked hard to accumulate wealth throughout your working years, you also want to make sure that you are able to preserve that wealth and enjoy a comfortable lifestyle in your golden years. One of the biggest challenges you'll face in retirement is figuring out how to minimize your taxes.
A Short Biography of Justin Roiland
Justin Roiland is an American actor, animator, writer, and producer. He is best known as the co-creator and executive producer of the animated television series Rick and Morty, in which he also voices the characters of Rick Sanchez and Morty Smith. Roiland began his career in animation as a writer and animator for the Cartoon Network series Fish Hooks. He later went on to co-create the Adult Swim series Rick and Morty with Dan Harmon in 2013.
Google Search From a List in Excel
I often use Google searches to conduct search engine optimization (SEO) research for articles that I write. The searches are mainly to completed to analyze titles that I want to use for future article or title enhance content that I already have written. There are three types of searches that I use and are listed below.
Create an Excel Job Application Dashboard
I tend to create a lot of dashboards for myself to streamline processes. Using a dashboard does not necessarily help everyone, but having a custom centralized location to work from can assist in keeping you organized. In this article, I cover step-by-step how I would create a custom dashboard using Excel to track my job applications. Not all of my suggestions are required. I just wanted to show you the types of tools that you can utilize in your own tracker.
How to Create an Excel Job Application Dashboard
I tend to create a lot of dashboards for myself to streamline processes. Using a dashboard does not necessarily help everyone, but having a custom centralized location to work from can assist in keeping you organized. In this article, I cover step-by-step how I would create a custom dashboard using Excel to track my job applications. Not all of my suggestions are required. I just wanted to show you the types of tools that you can utilize in your own tracker.
About the National Debt Ceiling
The United States federal debt ceiling is a catastrophe waiting to happen. While the ceiling is always raised, the never-ending periodic rise of borrowing power is a cycle without a foreseen end packed with bargaining levers. What is the Debt Ceiling? The debt ceiling is important for all Americans to understand because it is the federal debt limit keeping the debt from growing beyond a certain point by law. This is the debt of all Americans so citizens should take this topic seriously.
Aluminum Wheel Manufacturing - Personal Experience in the Industry
Joshua earned an MBA from USF and writes mostly about software and technology. History of the Aluminum Truck Wheel Industry The Aluminum giant Alcoa who proves to be a global leader and inventor of forged aluminum wheels brought the steel wheel truck industry to its knees. Alcoa knows what they are doing considering that it invented the first forged aluminum wheel back in 1948. At this time the company was using an alloy developed explicitly for aerospace.
How is Kayne West So Crazy?
Joshua earned an MBA from USF and writes mostly about software and technology. After Ye (formally known as Kayne West) tweeted a not-so-flattering image of Elon Musk getting sprayed off with a hose on a boat, I thought something was up. He even posted that it was going to be his last tweet! It seems like taking things to the edge is not what Ye stands for. For the life of me, I can't understand this behavior. I'm not on Twitter enough to already know the controversy. So I had to dig a little deeper.
30 Years Ago The First Text Message Was Sent
Joshua earned an MBA from USF and writes mostly about software and technology. It's been 30 years ago today at the time of this writing that the first text message was sent. I can't image texting way back in 1992. Mostly because at the age of 10 I was only tasked with remembering my phone number. I did send a text until about 9 years later after I received my first cell phone. The message was sent by Vodafone engineer Neil Papworth on December 3rd, 1992.
Euchre Card Game Instructions
Joshua earned an MBA from USF and writes mostly about software and technology. Euchre In my opinion, Euchre is an easy game to learn. Heck, despite what you may think because you didn't pick it up in one night, it can be such an easy game to play. In this summary, I will cover the game of Euchre in as much detail as needed to start playing with friends and family. When I say this game is easy to learn and play I'm not implying that it's easy to win.
Update Concerning Student Loan Forgiveness
Joshua earned an MBA from USF and writes mostly about software and technology. In August of 2022, the Biden administration announced their plan to provide debt relief to an excess of 40 million Americans with federal student loans. Citizens with student loans signed that signed up for updates concerning student loan forgiveness received the email below on October 20th, 2022. Borrowers were given an application link and told that they could receive up to $20,000 in student loan debt relief.
The IRS Gives House Committee The Tax Returns of Donald Trump
Joshua earned an MBA from USF and writes mostly about software and technology. Remember way back during the 2015-2016 presidential campaign when Donald Trump refused to make his tax returns public? The house Ways and means committee has recently collected 6 years’ worth of Trump’s tax returns. Back when Trump was asked if he would reveal his tax returns, he claimed that he was under audit. Later he claimed he was still under audit and the trend continued.
Show More
loading
Actions
Is this you?
As a journalist, you can create a free Muck Rack account to customize your profile, list your contact preferences, and upload a portfolio of your best work.Get in touch with Joshua
Contact Joshua, search articles and posts on X, monitor coverage, and track replies from one place.
Learn more about Muck Rack