<p>https://steemitimages.com/DQmXUGkeAVjhfxsnDgRq2V5Bs6Kig3TYVtDS3doXg8PqLeo/S45-00th.jpg</p>
<p>For spreadsheets and collaboration online, what works better than <em>Microsoft Excel</em> for me as an entrepreneur online today?</p>
<p>I love<em> Microsoft Excel,</em> but I'm showing you today <em>Airtable</em> because I like <a href="https://airtable.com/"><em>Airtable</em></a> even better than <em>Microsoft Excel</em> because it's easier to collaborate with.</p>
<p>https://steemitimages.com/DQmbbd8LdQJDA1aZYWa3ZmPfQaZ9g6MuZXbqwRwA8FUsKxU/S45-01.jpg</p>
<p>Read this post or watch the original video from <em>YouTube</em> to learn how I use <em>Airtable</em> in my business daily.</p>
<p>https://www.youtube.com/watch?v=O38Zxzdzpn4</p>
<h2><strong>Best Microsoft Excel Alternative in 2017 is Airtable</strong></h2>
<p><br /><em>Microsoft Excel</em> is a program I've been using for <em>15</em> plus years and here's something that I do in it that's one of the most helpful <em>spreadsheets</em> I've ever made.</p>
<p>https://steemitimages.com/DQma88Xoz5EHZtgBwuuwb2wj91d2xLhVBemXtfbV23hWEZi/S45-02.jpg</p>
<p>In this <em>spreadsheet,</em> I track the work I do each day. I track the number of audio files, number of videos I upload, number of messages, and then I put the exact project that I'm doing in here with it, and I track each of these by days.</p>
<p>This is an example of something <em>Microsoft Excel</em> is extremely helpful for. Yet, when I do it in <em>Airtable,</em> this is even easier.</p>
<p>In <a href="https://airtable.com/"><em>Airtable</em></a>, I've got my <em>"Diary."</em></p>
<p>https://steemitimages.com/DQmV4vBwj9YA4kcasodfBsXsp9EkDiCHRwbzpARX86ptZrv/S45-03.jpg</p>
<p>When I click on <em>"Diary"</em> I can then see a <em>spreadsheet</em> that I was easily able to copy and paste from <em>Microsoft Excel.</em></p>
<p>https://steemitimages.com/DQmXSx41NpiX4xmwNoS5VrGozxcvV6KCBqDyJd2A9TjoacJ/S45-04.jpg</p>
<p>The difference in <em>Airtable</em> is that some of the things I want to do anyway are automatically done. In <em>Microsoft Excel</em>, I had to create formulas to make the second row at the top and calculate the <em>"Total,"</em> and this is automatically done over in <em>Airtable.</em></p>
<p>I can even switch these up however I want to. I have the <em>Sum,</em> I can put the <em>Average</em> down here for example. I can just easily switch that to an <em>Average,</em> and then switch that back to a <em>Sum.</em> I can switch all these over to averages if I want to.</p>
<p>https://steemitimages.com/DQmQ43d3DftwrEVE8MHZ6889tsTFMfDZgMKTXSAxgohdxqM/S45-05.jpg</p>
<p>This is so easy down here, you can even put things in like <em>Standard Deviation.</em> You can put in things like the number of <em>Empty</em>'s or you can put in the <em>Max.</em></p>
<p>This is easy in <em>Microsoft Excel</em> in theory, but in practice, you think, <em>“Well I should be able to just set up a simple formula.”</em> Well, you've got to manually do all these and I'm sure there are things I don't know about in <em>Excel.</em></p>
<p>This is even easier in <em>Airtable</em>.</p>
<p>Now, this is not where <em>Airtable</em> really shines though, because this is nice having this <em>spreadsheet</em> on one computer, but what if I want to update this <em>Microsoft Excel spreadsheet</em> when I'm over here using my <em>iPhone?</em></p>
<p>https://steemitimages.com/DQmcSV36KNDBNFFskAchtbsDKjaV4b2uUDTHZH7FGjcmefk/S45-06.jpg</p>
<p>What if I want to just quickly add an entry at the end of the day without having to turn on my computer and load up this <em>spreadsheet?</em></p>
<p>What's amazing about <a href="https://airtable.com/"><em>Airtable</em></a> is that I'm able to access this on everything. I can get to this on my <em>iPad</em>, on my <em>iPhone,</em> on my laptop and on all three of the computers I have in here just as easily.</p>
<p>https://steemitimages.com/DQmeZbdkNYxEeuDgeEU3duqBKHfaVB7SrZ3ca5BdKs2dBw7/S45-07.jpg</p>
<p>Now, with <em>Excel,</em> the problem is keeping track of the file. When I want to use the file on more than one computer, then I need to have something setup like <em>iCloud Drive,</em> <em>OneDrive,</em> or <em>Google Drive.</em></p>
<p>All of these are good, the problem is what if I'm traveling and I just want to update my <em>spreadsheet?</em></p>
<p>Then I've got to sign in to my <em>iCloud Drive</em> from somewhere. Or If I'm on my <em>Mac</em> and it's not connected to the <em>Internet</em> and I make a change on the <em>spreadsheet</em> here, but then it doesn't update on the <em>iCloud Drive,</em> then all of a sudden I've forked my <em>spreadsheet.</em> I've got two different copies of my <em>spreadsheet,</em> which is annoying when that happens.</p>
<p>However, this even is not the very best feature.</p>
<p>This is a nice feature of <em>Airtable</em> to do that, but what I like best about <em>Airtable</em> is the collaboration. This has taken my collaboration to a whole new level. I started this off with my friend <em>Joe Paris,</em> I'm doing some ad campaigns for him. We initially were awkwardly sending spreadsheets via email, which was quite annoying because every time he'd update something then I'd have to change the file.</p>
<p>Airtable really shines in collaboration.</p>
<p>What I'm doing now is I'm using <em>Airtable</em> for all my collaboration online. My friend <a href="https://steemit.com/@gmichelbkk"><em>Michel Gerard</em></a> is helping me with my <em>Steemit</em> posts. We have a sweet system that we're able to use here to get everything done.</p>
<p>What I do in <em>Airtable</em> is I post a <em>Steemit</em> post title, I put my <em>YouTube</em> video, and then I throw a <em>GoTranscript</em> in here.</p>
<p>https://steemitimages.com/DQmYbHiBPjTyUbYrekqo37BZi6jR2eMVGEivHMXGRnFbryg/S45-08.jpg</p>
<p>This is a feature that at least I don't know how to do it on <em>Excel.</em></p>
<p>You can literally drop an attachment from a <em>Word</em> document, which I've put in this one or you can throw pictures in as you scroll over further. I can actually drop thumbnails in here. I can then directly make post links over here, and then I can add comments.</p>
<p>https://steemitimages.com/DQmPZ1vTe9DsLA4r4m849fLjGxVYEiGAssR6PgKKrTNVM2K/S45-09.jpg</p>
<p>Here's another sweet feature, I've got different statuses that we can change following the work's progress. I've got this <em>spreadsheet</em> over here and you can see that there are different statuses on it.</p>
<p>https://steemitimages.com/DQmTJ2Znf2cZXdzCyYqD2wEGWhvJmMN5u9H1JpLJZmXxB4H/S45-11.jpg</p>
<p>If I turn this status over here to <em>"Posted,"</em> this entry will actually then hide within the <em>spreadsheet.</em></p>
<p>https://steemitimages.com/DQmcEtDmesS25Xv14DBEDcXpMLps13T2djyqYPSakSk4Qgt/S45-10.jpg</p>
<p>I will just show you real quick what it looks like on this one.</p>
<p>Let's just say I'll try it on this one, I hit <em>"Posted"</em> on here, you see that it says, <em>"Record filtered."</em> Now, if I change my mind I can put it back.</p>
<p>https://steemitimages.com/DQmaKNSKVi4qCX9CLQFANrXuP5ss4HZdnThTf1BaLUMYNu6/S45-12.jpg</p>
<p>This allows us to keep a very simple clean interface while maintaining all of our data.</p>
<p>This is the most amazing thing I've seen for collaboration online since emailing and being able to do videos. With <em>Airtable</em> you are able to collaborate, get things done and you can use it for anything you do online whether it's blog posts, videos, ad campaigns or event management.</p>
<p>There are all kinds of templates in <em>Airtable</em> that they want to show you. If you go over here to <em>"Templates,"</em> it will bring all these different things up like <em>Advertising Campaigns, Launch Calendar </em>or<em> Project Tracker.</em> They have a ton of different templates that are really helpful.</p>
<p>https://steemitimages.com/DQmcJypovoHjV7sRy7tQszxMUvAUjktasoEA4Hf2oLZtX7v/S45-13.jpg</p>
<p>Once you get a nice template setup, it's extremely easy to collaborate. Instead of sharing <em>spreadsheet</em> files back and forth, then you just work in the same interface and everything saves instantly.</p>
<p>If you're thinking, <em>"Oh man, this is so good, this must cost a fortune."</em></p>
<p>That's the best part. I've not spent a dollar on this yet.</p>
<p>I'm using this for free to collaborate with three different people online.</p>
<p>My friend <a href="https://steemit.com/@aarellanes"><em>Albert</em></a> is working on these<em> "Upvotable"</em> posts that we're doing with <em>Steemit.</em> I'm collaborating with <em>Albert</em> to be my right-hand man on <em>Steemit.</em></p>
<p>https://steemitimages.com/DQmX58wzDY69zt625CQNoN5QpwRvngEiaFpQja6tbL79k5x/S45-14.jpg</p>
<p>I'm doing ad campaigns with <a href="https://steemit.com/@joeparys"><em>Joe Parys</em></a><em>.</em></p>
<p>https://steemitimages.com/DQmbJ79EGocmfuJxkm5vxF4mW8PXjueJscWAcNJhHZLdFec/S45-15.jpg</p>
<p>Then you can see my collaboration with <a href="https://steemit.com/@gmichelbkk"><em>Michel Gerard</em></a> who uses videos like this one on this post with a transcription I get done through <em>GoTranscript</em>, then he edits it and takes screenshots, and gets them ready for a <em>Steemit</em> post.</p>
<p>I'm collaborating with three different people on three different projects all effortlessly in the same interface.</p>
<p>Then, I put <a href="https://www.youtube.com/c/jerrybanfield">my <em>YouTube</em> videos</a> up, I've been using this to make the descriptions. I've even got a nice filter I can apply right here. You can see all these videos I've already done.</p>
<p>https://steemitimages.com/DQmT5jueFW5oRcReFWfUBcRSCk9DYxZEtn1iA6dEGMkUUzv/S45-16.jpg</p>
<p>It's nice because if something were to happen to my <em>YouTube</em> videos, I'd really hate to lose all of this work with the descriptions. I write these long descriptions with an incredible amount of detail.</p>
<p>I've got an automatic character counting tool here so I know not to go over. Then, I've got all the videos linked right here as well.</p>
<p>https://steemitimages.com/DQmQg9AN7oEKDJoxFe8ACMam1r4bMmB6X9pBcYT938iFiht/S45-17.jpg</p>
<p>Along with collaborating, I've got everything in one interface.</p>
<p>Then I can just use a filter in here. I can put the filter to <em>"is empty" </em>and I can actually hide all those old video descriptions that I don't need any more, so I can just put the newest descriptions.</p>
<p>https://steemitimages.com/DQmc4UGdaoVMCVMNx6PbU34VrSqxbWbsejnoSBJ4Xz2Tzus/S45-18.jpg</p>
<p>I've got my key business tasks all in <em>Airtable</em> now, which means I can access them easily on any device. I'm finally saving some energy doing this because in <em>Excel</em> it just would have been too annoying to do it. It's so easy to set these things up in <em>Airtable.</em> I now have this one simple interface and it’s got all these critical tasks for me in a very small place.</p>
<p>https://steemitimages.com/DQmd17sRTbSTeZk68vcLc1cwedBkr87QjJDzQcES4a7Jkqx/S45-19.jpg</p>
<p>I've got all my data <em>Steem</em> records in here. I've got these posts I've made, my rewards, my investments. I've got all these key things about <em>Steemit</em> in this one place.</p>
<p>https://steemitimages.com/DQmQL7J9TCFwzZG8LzFMU4MnNZo9w74pWCTzeLXZUXdGW2z/S45-20.jpg</p>
<p>I'm very grateful that my friend <a href="https://steemit.com/@jordanarsenault"><em>Jordan Arsenault</em></a> invited me to <em>Airtable.</em></p>
<p>I still haven't paid anything using it in a couple of months now. The price is one of the very best parts about <em>Airtable</em> because all the things I've shown you are available totally for free.</p>
<p>https://steemitimages.com/DQmQv5gni1NhRbi3NWGcMwDDdEnfrzrB76dsJpAgnMXD9Yh/S45-21.jpg</p>
<p>Nothing I'm doing so far is paid.</p>
<p>You see, you get unlimited bases.</p>
<p>So what is a base?</p>
<p>A base is each of these different tabs here. I've got the tab with <em>Michel Gerard</em> that's one base. Then the <em>YouTube</em> videos, that's another base over here. Therefore, I can make as many of these bases as I want to.</p>
<p>https://steemitimages.com/DQmYBUWvBg7yhT9bznjkgQW2YpUv9SZRoaEmFiNEc28QefW/S45-22.jpg</p>
<p>I can have up to <em>1,200 </em>records per base, which at the rate I'm going, it's going to be hit reasonably soon.</p>
<p>I can also have two gigabytes of attachments per base. I've got these thumbnails over here on the base with <em>Michel</em> and that counts for my attachment space on this base. So that's just per individual base and I'm probably going to start hitting that soon.</p>
<p>https://steemitimages.com/DQmV2TuMnLkD1rLqafuoQpN5DZREW4BAkvg5DMs6suWteab/S45-23.jpg</p>
<p>Then you can have two weeks of<em> "Revision and snapshot history."</em></p>
<p>That means for the last two weeks, if I go mess something up, I can go back to check and say, <em>"Oops, I didn't mean to delete that or I didn't mean to edit that this way."</em></p>
<p>You've got two weeks of revision and snapshot history then. I haven’t even had to upgrade and a lot of users may not even need to upgrade for a year or more using <em>Airtable,</em> because if you're not putting that much data into it, there's no reason to upgrade.</p>
<p>Now, the awesome thing is that you can upgrade to just <em>$10</em> a month with the annual plan, which this is probably the next upgrade I'm going to do. It expands to <em>5,000</em> records per base and it gives you another <em>2 1/2</em> times the attachment space, so <em>5</em> gigabytes of attachments per base, and <em>6</em> months of revision history.</p>
<p><em>https://steemitimages.com/DQmVyNBQXuWpbxDmMhwRnT4H8fvgcDVHWxtUVWT5BYnrKN9/S45-24.jpg</em></p>
<p><em>$10</em> a month is an outstanding value. If you chose the monthly plan, it's actually <em>$12</em> a month.</p>
<p>On the <em>Pro</em> account here then you can get <em>50,000</em> records per base, I’ll probably need to upgrade to this in a year or so, and then you even get <em>priority support, custom-branded forms, </em>and<em> more colors and styling options.</em></p>
<p>https://steemitimages.com/DQmR2cnqmbU34vzb4WMNPvyhxzpRT5sq5GHPb3DA9jUkwx3/S45-25.jpg</p>
<p>This is an incredibly cheap tool and incredibly effective, which is why I've taken the time to share it with you today because this is one of the tools that helps me out the most online.</p>
<p>If you would like to join <em>Airtable,</em> would you please <a href="https://airtable.com/invite/r/qGLfO5Yn">use my link</a> because I get a discount on my bill. Right now I'm grateful I’ve got already about <em>$100 </em>in credit, meaning I have about a year's worth of billing.</p>
<p>https://steemitimages.com/DQmdY4qJpvkVECwmbmZS8zthds9jEMYJMbf1rfX9zPALM6i/S45-26.jpg</p>
<p>Now, the one downside on <em>Airtable</em> is that every single collaborator I work with costs me more money. That means, for <em>Michel,</em> <em>Joe Paris</em> and <em>Albert,</em> that's another<em> $10</em> plus me. I'm then looking at <em>$48</em> a month for the minimum plan by collaborating with different people.</p>
<p>I would hope that they would get their <em>Airtable</em> account upgraded for free. This means if you are doing collaboration, it can be a bit more expensive. However, if you're collaborating you're also likely getting a lot more value out of it.</p>
<p>Would you please use my link because that will help me lower my bill and it won't cost you anything: <a href="https://airtable.com/invite/r/qGLfO5Yn"><em>https://airtable.com/invite/r/qGLfO5Yn</em></a></p>
<p>It helps <em>Airtable</em> to recognize that you found out about this through me. I used my friend <em>Jordan Arsenault's</em> link to join <em>Airtable, </em>so he's got a credit for me joining. If you’d like to just use a shorter affiliate link, I have <a href="jerry.tips/iairtable"><em>jerry.tips/iairtable</em></a>.</p>
<p>Then on <a href="https://jerrybanfield.com/resources/">my resources page</a> on my website, I've got listed links to all the other stuff I use in my business. You don't have to hunt down the list of all the things that you need to use in your business online or the most valuable tools that are working for me, you can just see a list of all of them very quickly.</p>
<p>I got this video transcribed by <em>GoTranscript</em> and <em>Michel</em> at <a href="https://steemit.com/@gmichelbkk"><em>@gmichelbkk</em></a> used our <em>Airtable</em> collaboration here to get this turned into a <em>Steemit</em> post that you are reading right now, because you might prefer to read instead of watching something like this.</p>
<p>I know that sometimes I'm just in the mood to read something instead of watching a video. If you’d prefer to have the option to read and see future posts, would you please <a href="https://steemit.com/@jerrybanfield">follow me on <em>Steemit</em></a><em>?</em></p>
<p><em>Steemit</em> is a social media network where you actually get paid for what you contribute to the website instead of making something that goes viral and getting nothing but likes for it.</p>
<p>If you make something that goes viral on <em>Steemit</em> as I've made a few things that have gone viral, you can earn thousands of dollars on one single post. That’s why <em>Steemit</em> is incredible. That's why I'm working with <em>Michel</em> to transcribe these video tutorials and get them over onto <em>Steemit.</em></p>
<p>Thank you, I hope you have an awesome day and I hope to see you again soon.</p>
<p>If you found this post helpful on <em>Steemit,</em> would you please <em>upvote</em> it and follow me because you will then be able to see more posts like this in your home feed?</p>
<p>Love,</p>
<p>Jerry Banfield with edits by <a href="https://steemit.com/@gmichelbkk">@gmichelbkk</a></p>
<p><strong>Shared on:</strong></p>
<ul>
<li><a href="https://www.facebook.com/jbanfield">Facebook page with 2,257,393 likes.</a></li>
<li><a href="https://www.youtube.com/jerrybanfield">YouTube channel with 198,227 subscribers.</a></li>
<li><a href="https://twitter.com/JerryBanfield">Twitter with 105,581 followers.</a></li>
</ul>
<p>PS: Witness votes are the most powerful votes we make on Steem because one vote for a witness lasts indefinitely!  Would you please make a vote for jerrybanfield as a witness or set jerrybanfield as a proxy to handle all witness votes at https://steemit.com/~witnesses because when we make our votes, we feel in control of our future together?</p>
<p><a href="https://steemit.com/~witnesses"> <img src="https://i.gyazo.com/9325a7f4bb4cd0802fd901804a56deaf.gif" alt="Vote Jerry Banfield Steem Witness" width="100" height="100" border="0" /> </a></p>
<h3>Or</h3>
<p></p>
<p><a href="https://steemit.com/~witnesses"> <img src="https://i.gyazo.com/e41b5378209532d6b282543f780b0278.gif" alt="Jerry Banfield Steem Proxy" width="100" height="100" border="0" /> </a></p>