#excel-tutorials

[typosandtea]

@rad-roche NOIR TIME! Turning my assignment in very late.

Agent Phil Coulson may not be a dame, but he does have a lot or weirdly specific things in common with Nick Valentine!

Your tutorial post on pulp covers was wonderful! But this was so many kilometres out of my stylistic comfort zone that the entire time was like agh! what the hell am I doing?.?? (And why it’s taken over a week). I found a lovely cover for reference “The Deadly September” on the archive you have linked in the tutorial.

Below is things I had to adapt to achieve a similar effect in Procreate, the reference images I used and, the worlds’s most convoluted speed-paint. (Learning new things is messy!)

⚠️THE SPEED-PAINT FLASHES QUICKLY A LOT !! ⚠️

Also I’ve listed some of the weirdly specific similarities between Coulson and Nick! so SPOILERS for Agents of Shield seasons 1-6 (I haven’t gotten around to watching 7 yet, and agents of shield isn’t MCU canon anymore anyway) and Nick’s story / far harbour in Fallout 4! (Spoilers below the speed-paint)

Procreate edits:

Totally used the back button more than I should have. I think I changed brush at least 3 times and edited the texture layers way more before it got to a point I was even remotely happy with. The brush I ended up settling with was procreate’s “Tarraleah” in the ‘artistic’ category, unaltered.

Procreate does have screen layers so was able to use that as in the tutorial, I set my chosen grunge at 90% opacity after inversion.

The contrast / brightness layer was tricker since that’s not a feature in procreate (??????), after lots of messing around I found that filling a layer with black and setting it to “soft light” mode and 85% opacity brings the paper texture I used away from the overly white tones without messing with the colour too much.

Since procreate doesn’t support per layer colour dropper, I had all of the texture layers in a folder so it can be hidden with one click, though personally I tend to guess the colour I need on the wheel rather than use colour dropper, so hiding the texture wasn’t an issue for me so much.

The colour check layer was also a black filled layer but this was set to colour mode as in the tutorial.

⚠️THE SPEED-PAINT FLASHES BRIGHTLY AND QUICKLY ⚠️

VVVVVVV SPOILERS FOR AGENTS OF SHIELD 1-6 AND FALLOUT 4 VVVVVVV

NICK VALENTINE AND AGENT COULSON SIMILARITIES (in my opinion):

Good people at heart

Multiple life shattering, personality altering crisis each.

Experimented on against their will by a group with highly advanced technology resulting in their unethical resurrection. Institute for Nick and Fury’s project TAHITI / Guest Host for Coulson.

Consciousness placed into a Synth / Life Model Decoy after their death against their will (LMDs are marvel’s version of synths with all the ‘is it a person’ and ‘the infiltrators are ruining our organisation’ that come with that) both are in highly modified unique Synth/LMD hardware

Both have killed an enemy they have been hunting for years for nothing but revenge, Eddie Winter for Nick and Ward for Coulson. (Though nobody stays dead in agents of shield)

Part of the plot requires entering a simulation with other peoples memories. DiMA’s memories for Nick and the Framework for the shield crew.

A partner that they can’t see because one of them was murdered as collateral damage. Jenny for Nick, and Coulson is the dead one for Audrey (the cellist)

Betrayed at a great personal cost by the organisation they were upholding when the org. Is revealed to be corrupt/evil. Police being in on Winter’s scheme for Nick and shield being hydra for Coulson.

Key Mission requires strapping them into a memory machine and poking around their brains/memories. Nick with kellogg’s memories and Raina’s need of Coulson’s memories from after he died in New York (though Coulson’s is a lot more traumatic on account of him being human at the time and marvel’s memory machine being painful)

Intentional memory loss forced on them by a third party. Nick’s institute knowledge and Coulson’s unawareness of his resurrection by Fury.

So much trauma, they can’t catch a break.

[tj-crochets]

Hiiiiiii

I hope you're okay! Allergies suck so bad 😞

I was wondering if you had any recommendations for someone learning to crochet? I learned the basics and can make a basic scarf or hat but I want to make creatures and I'm so lost! They all look so complicated and difficult! I have no idea where to start

Hey! I'm doing better, thanks! I'm just tired It's been a while since I learned to crochet, so there might be better links out there now (if anyone reading this has some, please share them!) but what I learned from were mostly two sites. Moogly for individual crochet stitches (they have written and video walkthroughs), and AllAboutAmi for amigurumi-specific tutorials and basic, beginner friendly free patterns

[goldenandbrokenandfine]

was anyone gonna tell me they revived Parade on Broadway last year or did I just have to find that out myself

[crowcryptid]

mandatory youtube self promo. this vid took too damn long

I am aware of the minor audio issues, the extracted files already had those glitches so there's not much I can do.

[toestalucia]

guys we have a little problem

[ideallysheets]

Can we leave ugly spreadsheets behind?

It's 2024, there's no more excuses for spreadsheets that make the eyes water. This especially includes messy, hard-to-read, clutters of data (coworkers read up!). Is some of this over-the-top? No.

Here's some styling tips for your spreadsheets!

1. Use Custom Colors (Color Palette)

I like to start my spreadsheets off by choosing a color theme to get an overall feel for it, and a color palette is a great way. Take advantage of custom colors, and not just the ones provided for you (they are bland and basic). Custom colors make a beautiful spreadsheet.

2. Text Alignment and Merging

Aligning your text appropriately adds a professional touch and overall a cleaner feeling to your spreadsheet design. Don’t forget you can horizontally (left, center right) and vertically (bottom, center, top) align! Merge cells when needed!

3. Vertical and Rotate Text

An unknown but useful tool. You have the option to rotate text and make it vertical. This opens up many possibilities for your spreadsheet design!

4. Text Fonts (Additional Fonts)

Just like the colors, spreadsheets give limited font options. However, you can add additional fonts very easily.

Take advantage of bolding and italics, which adds depth to our design. For fonts, many people like to use a serif and a sans-serif font to complement each other, but I am not an expert in font design!

5. Adding Borders

Adding borders is an easy thing to add to make your spreadsheet more readable. You have unlimited options, you can add borders to any edge of a cell, customizing the color and line type. Keep in mind, if you select multiple cells it will act like just one cell when you add borders.

6. Alternating Colors

Alternating colors is a great feature that will automatically make each row an alternating color as you create rows. This makes large amounts of data much easier to follow and read!

7. Emojis and Images

Emojis are the easiest way to spice up your spreadsheets with pictures. The best part? It’s a built-in feature for most spreadsheet software.

See? Emojis aren’t just for fun facial reactions. They add a nice and simple touch. They can be used as icons, visual aids, and much more. Furthermore, you can add your custom images.

8. Freeze Rows/Columns and Adjust Cell Sizes

Freezing the header will make it stay on top as you scroll. This can be done by dragging down the thick gray bars on the top left corner. You can also do this with columns.

9. Add Checkboxes and Dropdowns

Both great ways to style your spreadsheet!

10. Final Touches

I like to remove unused columns and rows, this makes the workspace smaller and cleaner.

Additionally, group and hide columns to keep things clean. Also, make sure to take advantage of the spell check feature.

Here's a run through of me taking a basic spreadsheet and making it beautiful! Good luck! Visual person? Watch this short YouTube playlist I made.

[solar-lilith]

no but how do I draw hobie brown's hair?????

[nikunjbhoraniya]

➡️ What is an Equipment Breakdown? Types of Breakdowns | Examples

[inkstainedpettles]

[mcmadcanvas]

Also getting increasingly frustrated with digital art.....

[shafiqulislam98]

Make salary salary sheet in excel. খুব সহজভাবে এক্সেলে সেলারী শিট তৈরী করা শিখুন

[wisdomfish]

Let your soul admit this:

“I am a pitiful, weak creature, unstable as water. I cannot excel. This corruption is too hard for me, and it is on the verge of ruining my soul. I do not know what to do. My soul has become like parched ground, and habitat for dragons. I have made promises and broken them; vows and engagements have meant nothing to me. I have had many temptations over which I got victory. I should be delivered, but I am deceived. So I can plainly see that without some superior help, I am lost. If I continue on this path, I will be triumphed over until I completely relinquish God. But although this is my condition, let the hands that hang down be lifted up, and the weak knees be strengthened. Behold the Lord Christ, who has all the fullness of grace in his heart and all the fullness of power in his hand. He is able to slay all these who are his enemies.”

There are sufficient provisions in Christ for my relief and assistance. He can take my drooping, dying soul and make me more than a conqueror.

~ John Owen

[excelhelps]

How to Import Text/CSV files into Excel

[prinzessinpluto]

having an absolute blast making a new excel spreadsheet (and notion page) for my books btw

[rambarad]

The XLOOKUP function to find things in a table or range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term and return a result from the same row in another column, regardless of which side the return column is on.

Note: XLOOKUP is not available in Excel 2016 and Excel 2019, however, you may come across a situation of using a workbook in Excel 2016 or Excel 2019 with the XLOOKUP function in it created by someone else using a newer version of Excel.

Syntax

The XLOOKUP function searches a range or an array, and then returns the item corresponding to the first match it finds. If no match exists, then XLOOKUP can return the closest (approximate) match.

Formula

=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])