Document sharing can be a hassle. A feature that’s already built into Excel can help you use Excel for simple collaboration for small groups. Of course, this shouldn’t take place of a more robust collaboration or document sharing tool, but can be set up in a pinch.
If multiple people need to work on an Excel spreadsheet stored on a network drive, access to the file can be made much easier by setting two options from the Save As dialog box.
These settings can be made at any time, just by using the Save As feature to save the workbook back over itself. You don’t even have to change the name.
The following instructions show you how to set the workbook to use a feature called Read-only recommended as well as setting an automatic backup every time the file is saved.
When the file is open on your computer, click File > Save As and choose the folder you want to save the file into. The Save As dialog will appear as shown here:
Next, click the Tools option and choose General Options.
From the General Options dialog, place a check mark beside Always create backup, and Read-only recommended.
With the options set the way you want, click OK and then click Save.
Now whenever a user tries to open a file, if it is available for writing to (which means someone else doesn’t have it open and is making changes to it) they will see a dialog asking them if they want to open it as Read-Only.
This allows the other user to finish their editing. The user who opens the file as Read-Only will not see the changes from the other user until they close the document and open it again.
If you choose NO, you will be able to write to the file as normal.
If you do not see that dialog box, the file has opened in normal mode allowing you to modify and save the changes.
I hope that helps you work with Excel files with multiple users. I’ve run into this situation where Sharepoint or other document sharing solutions are not in place.
Do you have any suggestions on how to work with Excel files and multiple users? Do you have good experience with Sharepoint? Add details in a comment below!
Earlier today my Instagram friend Vallisdero asked me for suggestions on the best way to learn Procreate for her iPad so I decided to do a little digging. My results for the top 3 courses you should take to learn everything about lettering with Procreate are below.
Since Vallisdero specializes in calligraphy but is just getting started with Procreate I decided to ask designer and letterer Jennifer Grieve (fueled by letters) what her suggestions were. Her answer was simple: Check Youtube. This video by James Julier is probably the best place for anyone to get started if you just want to watch and follow along. As this isn’t particularly a course, consider it a freebie.
I’ve been a fan of the courses on Skillshare for over a year now, so it was a natural place to start looking for tutorials.
1. Digital Illustration Learn To Use Procreate (Free)
This first tutorial is a free course by illustrator Jarom Vogel and focuses on illustrating while learning the basics of the interface, different settings, and different brushes. My wife won an iPad earlier this year and I can’t wait to try out some of the techniques Jarom shows off. You can’t go wrong with free courses.
2. 3d Lettering in Procreate
Next, a bit of 3D lettering by my favourite Skillshare instructor/artist Teela Cunningham, host of the site every-tuesday.com where she provides freebies, tutorials, and incredible bundles.
She’s just released this new course so there aren’t a lot of students yet, but her Master course on font making was absolutely phenomenal (although honestly I’m *still* not done going through all the content yet). She also has a course on metallic textures in Photoshop which is really what got me started back into design in a big way. Thank you Teela!
3. Intro to Lettering with Procreate
Finally, I’m taking a bit of an educated risk here by going with Juniper Calligraphy‘s Intro to Lettering. Of course after visiting her Insta, you’ll see why it’s really not that big of risk. Wow is she good!
I’ve wanted to put together a list of great courses for a while now, so follow me on Instagram and drop me a comment about content you want to see. Leave a comment below too.
It’s been a while since I had access to my email for this domain, but now that I’m back I’m updating the backend of the site.
After updating to the newest version of WordPress, I’ve come across the new block editor which allows for a more intuitive and streamlined way to create web content. If you’ve used Adobe Spark or even a bit of Facebook Workplace, you’ll be familiar with the interface of adding blocks.
The title and body text of this page are from a default block without adding anything. The image below is also added without a block — the feature is already sitting on the page for editing.
A basic blockquote can be added as a block along with other features.
I’m itching to write about tutorials for Procreate, so for now that is all about the new editor in WordPress 5.0.
If you want to help me out with creating more tutorial material, sign up with Skillshare and I’ll get a bonus to use on tutorials so I can learn more, to teach more!
If you teach learners over the age of 17 or 18, then you basically have adult learners on your hands.
According to educator Malcolm Knowles, there are 6 assumptions that you can hold in your mind while you are creating curriculum that is relevant and engaging for your adult learners. I’ve summarized these 6 assumptions here in this image:
I’ve never really like the term human capital to refer to the people that work in an organization. Human power is definitely a resource that any organization needs to sustain itself, there’s no doubt about that.
This article by Mike Hruska, President and CEO of Problem Solutions along with Phil Antonelli — now a senior learning manager at RNA Group in Denver — discusses mobile devices to collect performance data as well as xAPI — an experience application programming interface for learning analytics which could replace SCORM.
There is definitely a lot of talk about today’s eclipse, and this info is probably coming to you a bit late but there is a simple way to view the total solar eclipse (or in my region of Canada, it will be a partial solar eclipse).
My wife and I used this technique for the partial eclipse that was visible in Waterloo a couple of years ago (2014 I think).
To view the eclipse without special equipment, you simply need a piece of paper or thin cardstock such as a business card or even a cereal box.
Poke a hole in the centre of the card.
This is not for looking through! It is used to create a projection of the sun and moon’s shadow onto another card or even a wall if you have one in the right position.
Keep your back to the sun.
Light from the sun will shine through the hole and onto a surface such as a wall or another card or sheet of paper.
Take a photo or trace the image.
This would be a great way to demonstrate the eclipse to children in a classroom or as a keepsake for your kids.
Understanding the difference between vector graphics — which are mathematical sets of instructions on how to display an image — and raster images — which are collections of coloured squares arranged on a grid — is crucial to creating effective designs using computer software. Whether it’s designing a logo, making a web page, or creating a handout for your students, understanding the different types of images and when each is best suited for the job will help you get better results from your design work.
Check out this video from Adobe about the difference between vector graphics and raster graphics. It also explains a bit about Adobe Illustrator, which is the industry standard tool for creating vector graphics and combining them with other elements.
Hello everyone, and welcome to Black Ink Training. We are in the process of developing our online material for a number of applications, but we’ll be focusing on Excel and using Visual Basic for Applications (VBA) first.
As a starting point, below is an older video I created for my computer students what explains the basics of using Excel. In the near future I’ll be updating the material and providing detailed training for Excel 2016 on both Mac and Windows platforms. This video is for Excel 2007, but the basics apply to all current versions of Excel as well as other spreadsheet applications such as Google Spreadsheets and even Apple Numbers.
A lot of people complain that you can’t work with more than 1 million rows of data in Microsoft Excel. Well, now you can!
Using the Power Pivot plug in in Excel 2013 or the fully integrated Power Pivot tab in Excel 2016, Excel now has a powerful database infrastructure that easily handles many millions of rows stores inside the Data Model portion of the file. Your only limits are really just the amount of RAM and speed of your processor.