#basic to advanced excel course

[warmlyskeletalstarlight]

Advanced Excel Course – Become an Excel Power User

Take your spreadsheet skills to the next level with our in-depth Advanced Excel course. Perfect for professionals, students, and entrepreneurs who work with data every day.

✔ Master advanced formulas – VLOOKUP, XLOOKUP, INDEX-MATCH, nested IFs ✔ Create dynamic dashboards using PivotTables, PivotCharts, and slicers ✔ Automate repetitive tasks with Macros and Visual Basic for Applications (VBA) ✔ Use Power Query to clean, merge, and transform messy data ✔ Build powerful data models using Power Pivot and DAX formulas ✔ Perform What-If Analysis with Scenario Manager, Goal Seek, and Solver ✔ Apply conditional formatting to highlight key insights visually ✔ Work through real business case studies and industry examples ✔ Learn Excel’s role in financial modeling, HR tracking, sales reporting, and more ✔ Practice your skills with downloadable exercises and quizzes ✔ Gain expert tips and time-saving shortcuts used by professionals ✔ Track progress and receive instant feedback on your performance ✔ Mobile-friendly, responsive course interface for learning anywhere ✔ Pause, rewind, and revisit lessons at your convenience ✔ Learn at your own pace with full lifetime access ✔ Get support from certified Excel trainers when you need help ✔ Receive a professional Certificate of Completion ✔ Boost your confidence for interviews, promotions, and career moves ✔ No prior advanced knowledge required – build step by step ✔ Trusted by learners from corporate, academic, and freelance backgrounds ✔ Stay competitive in today’s data-driven job market ✔ Course content regularly updated with the latest Excel features ✔ Suitable for Excel 2016, 2019, Office 365, and Excel 2021 users ✔ Designed to make you Excel-ready for real-world challenges ✔ Enroll now at www.mwcedu.com and master Excel like a pro.

[cacms1]

http://cacms.in/excel-and-advance-excel/

Excel/Advance Excel

Now a days, many jobs require advanced Excel skills.Formulas make Excel smart. Without them, Excel is just a data keeping tool. But by using formulas, you can crunch data, analyze it and get answers to most complex questions. While anyone can use a simple SUM or IF formula, an advanced user of it would be able to seamlessly write & combine formulas like SUMIFS, SUMPRODUCT, INDEX, MATCH, LOOKUP formulas.

[jeetechacademyrohini]

This guide will assist you in examining the career scope, job possibilities, salary patterns, and future prospects in computer courses in Delhi education if you are debating which computer course is most suited for your career.

[esscomputerinstitute]

ESS Institute is one of the best computer institute in Delhi. We offers a range of computer courses and programs for students of all ages and backgrounds. Our programs are designed to help students reach their full potential and make a positive impact in their professional life. Get enrolled today!

[kontentedgee]

Maximize Your Efficiency with our Productivity Tools Online Course

Our thorough Productivity Tools Online Course will help you maximize your efficiency and improve your workflow. Whether you're a professional trying to increase productivity or a student looking to improve your study habits, our course is designed to provide you with the necessary skills and approaches. Learn how to manage activities efficiently, maximize time management, and use the best productivity apps available today. Kontentedge specializes in providing the best Productivity Tools Online Course that equips students with practical knowledge and hands-on experience. From job prioritization to integrating modern productivity technologies, our course equips you with the tools you need to excel in today's fast-paced world. Join us and learn how to work smarter, not harder, through our expert-led online training. Begin your journey to increased productivity.

[essinstitute123]

Google Search Console: complete tutorial

Have you ever wondered what will happen if the pages of your website are not visible in the search engines. Definitely this can be the scariest thought you can ever have. But due to lack of technical knowledge, this is happening in the real world with the newbies in the SEO industry. Well for beginners, this is the opportunity and the solutions to this problem to get your pages searched and appear in Google search results. It is important that these pages are indexed in Google and to get the web pages indexed, Google search console or search console is the one-stop solution. Before we dive deep into this topic we are going to cover all the basics of search console like what are search console and its importance the working of search console.

What Is Google Search Console?

Let’s start by knowing it. Google search console is formerly known as Google webmaster tool. It is a web service provided by Google developers which is mainly responsible for optimizing a website for its visibility, indexing website, detecting crawl errors etc.

After understanding what is Google search console, now we need to focus on why search console is an important part of search engine optimization.

A website’s technicalities are directly or indirectly related to search console. Consider you have created a website for your business but from past few week, is not visible in search result pages. Here, search console comes into action. There is a possibility that search engine crawlers are not able to crawl your website thus it is not visible in the search result pages. To make crawlers crawl your website, you will need to optimize your website using search console. Some other technical aspects of search console includes fixing indexing problems, sending the updated content or pages for indexing, generating search traffic reports, generating alerts, if there are any issues related to indexing or any other issue, gets the list of sites linking to your website, keep the track of mobile usability, AMP pages and more.

Now, is the right time to understand how search console work. But before we begin this topic have a look at the question for you. What will you do at first, if your web page fails to appear in search result pages? Well, let me know your thoughts below and stay tuned with this blog. Even though you don’t have the answer right now, by the end you will surely be able to answer this question. Read more

[elodieunderglass]

Why are jockeys not supposed to look at smartphones?? will it make them heavier

No, of course not!

It’ll make them criminals

This is in reference to something I mentioned about a prominent female jockey leaving the sport over breaking smartphone usage rules. Nanako Fujita, who raced for Japan, was an excellent jockey with a promising career and international prospects. She was lucky, talented, and in a sport that’s starving for public interest, popular. But she used her smartphone on a weekend, so on October 2024 she tearfully penned her resignation letter and left the sport.

Now, this is slightly more about Japanese sporting authorities than general horse racing practice, but it’s embedded in the idea that jockeys are inherently just such unscrupulous little bastards that they can only be prevented from cheating by locking them in hamster cages.

Going back to how horse racing is historically the province of organised crime, disorganised crime, chaotic crime, things that aren’t crimes but should be, crimes that haven’t been invented yet, and felonies; and given that it all happens for the amusement of billionaires and royalty, not noted for being generous and scrupulous; and given that - much like how claiming a hobby of “knitting” is really a cover story for collecting yarn - horse racing is really an excuse to gamble;

Given all that background - there’s always been a lot of anxiety about jockeys “fixing” races. After all, they’re historically treated as disposable and make inconsistent and indifferent money while entire fortunes are wagered on their backs they’re in an obvious position to influence race outcomes, and there are unbelievable amounts of money at stake.

Thus, the sport feels that we have to assume that jockeys are simply inherently susceptible to bribery. In the UK, jockeys can’t bet on any races and have to declare their mobile phone numbers to the horse racing authority, and have restrictions placed on where/how/what they can use smartphones for around the tracks. They can’t bring a phone to work, basically. Which isn’t too unusual in some professions. The idea is that jockeys with phones could communicate with each other or outsiders to change racing outcomes, or share information in advance before it can impact on the betting odds (like insider trading on the stock market.) this is not commonly practiced in other UK sports. It’s a working condition imposed by anxiety about preserving the integrity of the gambling.

The Japanese licensing authority is more strict. The night before a race meeting, Japanese jockeys surrender their phones and go into separate quarters without lines of communication. So you might give up your phone at 9pm Friday night, enter a sort of corporate youth hostel, work for 2 days, and recover your phone on Monday. Nanako was caught using her phone during this period of sequestration, even though there’s no evidence that she was using it for race fixing (another jockey caught for the same thing in the crackdown was making a restaurant reservation.) again, this level of control over personal communications isn’t practiced in other Japanese sports! Even Japanese pop idols, famed for having restricted personal lives, don’t risk getting pushed out of their job entirely for touching a phone.

It’s about a lot of things, but the level of control exerted over jockeys is interesting to me! and speaks to their position as athletes who aren’t the focus of the sport they do; of jockeys as the disposable pilots of things that are far more valuable than they are; of workers whose working conditions are unique; of sportspeople whose sport is defined by the anxieties of the rich about gambling; of people whose bodies are ferociously honed for a specific set of rules that don’t even necessarily make sense; of a sport thousands of years old, one of the oldest continuous sports of human history, in which the humans who play it are invisible; of ancient once-immovable traditions colliding, in the 2020s, with renewed interest in animal and human welfare and renewed pressures to Perform for social media and everything changing in ways we can’t see because we’re in the middle of them. Like when I say “one of the oldest continuous sports in human history”, as old as the domestication of horses, think about it for a minute and think how strange it is that the human athletes are this invisible, this disposable, this secondary to considerations. Why is it that you’ve been forced to learn about football against your will all your life, and you never thought for a second about this. Isn’t that wild? I think it’s wild.

(Disclaimer: I’m really not an expert, just a mild fan, which is a bit unusual for my demographic; despite the sport being ancient and internationally known, it isn’t very relatable to “people like us,” so this is kind of the first time anyone on tumblr’s really posted about having an interest in horse racing/jockeys. I’m really not an expert and I barely follow the news and do NOT attend races or understand the stats/gambling. It’s just that it was my first career ambition when I was 6, and it’s one of those things where literally no one else cares, so you get to feel like you have Secrets and a Unique OC.)

[lead-academy]

Mastering Excel: From Basic Functions to Advanced Techniques - Your Ultimate Training Course

Our Microsoft Excel Training Course Basic to Advanced is the perfect solution for individuals and teams looking to master the world's most widely used spreadsheet program. With access to our entire library of 450+ courses, all staff members can benefit from our engaging learning materials, which are compatible with all major browsers and devices. Our diverse range of courses ensures that learners can take 10-minute micro-learning video lessons or full 40-hour courses, depending on their needs. Our CPD approved learning material guarantees that individuals receive the highest quality training. Additionally, new course material is regularly added to our library to ensure that learners stay ahead of the curve. With 24-hour customer support and dedicated account managers, our clients can be assured of an unparalleled learning experience.Here is the course link:https://lead-academy.org/course/microsoft-excel-basic-to-advance-level

[lbsti]

Certificate in Advance Computer Software

[gruucy]

[cacmsinsitute]

How to Create a Mail Merge in Microsoft Word: A Step-by-Step Guide

The mail merge feature in Microsoft Word is a powerful tool that allows users to automate the process of sending personalized emails, letters, or labels to a large number of recipients. The mail merge functionality can save you time and effort when organizing a mass mailing for a marketing campaign, sending personalized invitations, or generating custom reports. This article will walk you through the process of creating a mail merge in Microsoft Word.

Step 1: Get Your Data Source Ready

Before you begin the mail merge process, you must first have a data source with the information you want to merge into your document. An Excel spreadsheet, an Access database, or even a simple Word document with a table can be used. Make sure your data is well-organized and that each column represents a specific field, such as "Name," "Address," or "Email."

Step 2: Create a new document and begin the mail merge.

Open Microsoft Word and create a new document. Locate the "Start Mail Merge" group in the "Mailings" tab and click on the "Start Mail Merge" button. Choose the type of document you want to create from the dropdown menu, such as letters, emails, envelopes, or labels.

Step 3: Determine Recipients

In the same "Mailings" tab, click the "Select Recipients" button and select the appropriate option for your data source. If you have an Excel spreadsheet, choose "Use an Existing List" and navigate to it. You can also create a new list in Word or use an Outlook Contacts list.

Step 4: Add Merge Fields

It's now time to add the merge fields to your document. Place your cursor where you want the first field to appear (for example, the recipient's name) and click the "Insert Merge Field" button in the "Write & Insert Fields" group. Choose the desired field from the drop-down menu, such as "First Name" or "Email Address." Rep this step for each additional field you want to include.

Step 5: Preview and Customize

It is critical to preview the results to ensure that the mail merge works as intended. Click the "Preview Results" button in the "Mailings" tab. This will open a preview pane where you can navigate through each record and ensure that the merge fields are correctly filled out. Make any required changes to the document layout or field formatting.

Step 6: Finish the Merge

When you're happy with the preview, click the "Finish & Merge" button. Select the desired action from the dropdown menu, such as printing the documents, emailing them as individual attachments, or creating a new document. Follow the prompts to complete the merge process, making any necessary adjustments.

Conclusion: Using Microsoft Word's mail merge feature, it is simple to create personalized documents for a large recipient list. You can efficiently create professional and customized letters, emails, envelopes, or labels by following the step-by-step guide provided in this article. Utilize the power of mail merge in Microsoft Word to save time and improve your communication efforts.

Join CACMS today to improve your Microsoft Word abilities! With our detailed step-by-step instruction, you can learn how to establish a mail merge in Microsoft Word. Enroll now to become a mail merge pro and obtain professional knowledge. Don't pass up this chance to improve your document automation skills. Enrol now and begin mastering Microsoft Word: http://cacms.in/excel-and-advance-excel/

[cacms1]

Best Computer IT Courses|Short IT Courses in Amritsar | CACMS

CACMS offers Professional and Short term -IT Courses in Amritsar which includes: Advanced Excel, Advanced PowerPoint, Advanced Outlook, MS Word, Basic Graphics, Secured Programming.

[jeetechacademyrohini]

This guide will assist you in picking the ideal computer course depending on your market demand, skill level, and career goals; but with so many choices, how do you decide which course is the most suitable for you?

[vixensdungeon]

Alright, time to talk about one of the hot button issues in D&D today: skills, and how they've evolved over the 50-year lifespan of the game. We'll start, of course, from the beginning.

Dungeons & Dragons (1974)

So there actually isn't a skill system here. But the primordial origins are there, in the various neat little procedures of adventuring. Firstly there are languages. Humans know the "common tongue," which at this point isn't a single language, it just refers to the local Lingua Franca. I think all non-human player characters are assumed to be in 20% of other creatures who speak the language along with their own one. You also know an alignment language (Lawful, Chaotic, or Neutral), and one additional creature language for every point of Intelligence above 10.

NPC reactions. This is rolled on a simple 2d6 table for recruiting hirelings. Another 2d6 table is for monster reactions.

Surprise rolls. There are no stealth or perception skills, and adventurers are simply assumed to be sneaking around while in dungeons, with surprise rolled when monsters are encountered.

Doors can be listened at and secret doors found, with simple d6 rolls.

There's also a chance of getting lost in the wilderness, which sort of implies a general ability to not do so in most situations.

And that's basically it! You can already see several different skills we know today forming in the primordial soup.

But you feel like something is missing, right? Ah, of course! We must take a little detour to

Greyhawk (1975)

Did you know that in the original game, the only classes were fighting man, magic-user, and cleric? That's right, the now classic thief would not be introduced until the first supplement! And with them came for the first time actual named skills.

Thieves could open locks, remove traps, listen for noise, move silently, pick pockets, and hide in shadows. Additionally they could read languages, treasure maps, and even magical scrolls at higher levels.

Now, these skills are only for thieves, so what are other characters to do? Well for most of them, nothing. It simply is not a fighter's job to pick pockets, or a cleric's job to open a lock. Certainly an item can be forcefully taken from an NPC, and a door bashed open, so they are not completely helpless in these tasks. But the thief simply excels at doing such things with superior ability and grace. And of course any character can hear noises behind doors, thieves are simply better at it. Moving silently and hiding are two slightly odd skills, as they overlap with surprise rolls but don't interact with them. It can be assumed that a thief moving silently can scout ahead and report back without actually encountering the monsters they find, and a hiding thief can let wandering monsters pass by even when there isn't sufficient cover (as only shadows are needed, other characters can obviously still hide behind cover if they are aware of the need to do so). Other characters can also climb using ropes and other tools, but won't be able to climb sheer surfaces unaided like thieves can, so again the thief can simply do something general in a superior manner.

There are many classes with their own skills to be found in various magazines, but I'm not going to dig through them. So let the totality of original D&D skills be the above.

Next time: we get Advanced

[maddragon15]

Obscenely late hermitaday day #23 & 25! - Impulse & Tango

Was this meant to be a simple cel shaded drawing on the 30th? Yeah, yeah it was lmao but somehow the power of fire excels at overtaking the rendering capabilities.

But since it's late I'll use this as excuse to ramble below about well, the headcanons and the process down yonder. Also there's variations.

(Also just realized that the compression is high with this one, please click on it to see the details pretty pleasee)

So! Let's talk about that haircut shall we? First off Tango's haircut is basically just me slapping my very neglected oc's haircut onto him lol. There's no function usage or any other lore about it, literally just I wanted to use that haircut more. But Miners and Crafters that's not all! The intensity of the flame actually has meaning believe it or not.

Since Tango in the headcanons is already a nether born blaze hybrid the redstone kinda didn't have an effect on him. This is because blazes produce glowstone which is a power source onto itself. He gets minor effects instead which is a mild (there's literally no other word) high, a intensified hair flame and a brighter eye night shine. Negative effects include mild joint & jaw pain, and a small localized headache behind the left eye.

I like to imagine that other blaze hybrids' hair flame aren't normally that intense, not white-hot heat but rather more red n orange hot similar to the flats. Mainly due to the fact that glowstone is not as powerful as redstone and it's also dependent on how strong a blaze is. Now imagine with me that blazes determine how strong each other are via the color they're emitting. Now remember the blaze boss Minecraft had a vote on to add or not to add? What if Tango is constantly mistaken as a high ranking blaze because of how intense his fire is and he doesn't get attacked a whole lot except for the few that want to challenge him. Meanwhile Tango is just highly infused with redstone like all the other redstoners and he doesn't know what's happening half time as seen by his terrified scream-laughs /hj

He's also semi modified with redstone for the pure purpose of comms just like the other redstoners minus mumbo. I also would've leaned into the steampunk aspect of this season but I figured I'd do a character sheet like etho for all of the redstoners and finalize the aspects on those.

Onto Impulse!

I like to imagine that Impulse was a regular human and over the course of redstone exposure he gained pointed ears and horns. For what reasons? I have no idea but redstone works in mysterious ways and mutates on whatever happens to be in their system. You may see that he has purple lines across his face but then red pupils, why is that? Well since he's cyperpunk themed this season he modified his redstone implants to be rgb. He can change everything else except his pupils because those are deeply affected by redstone and would require surgery to remove the build up of redstone. Will any of the redstoners ever actually get rid of it? No but you can beg all day.

You also might be wondering what's happening in their ears? Well those are the advanced comms that are actually used across all hermits except the ones who've opted out for glowstone variants. They kinda work like bluetooth except more hermit-magic way. I haven't had time to fully think of how it'd work down to the circuitry (that's my usual process for headcanons before I ship them out) but I'll post about it when I think of the full layout. Other design aspects on impulse are derived from his skin and the poster design by applestruda!

Process wise for this piece was kinda a rollercoaster heh. I had started this piece a while ago (can't remember the day on the dot) and then I got insanely busy during the last week of hermitaday. I had done sketch, refined sketch and flats in two days. Then events proceeded forth and we arrive on the 4th which I tried for an entire day to figure out how to render this piece. I then gave up and tried again the day after and pulled up references this round on Pinterest. Tango was surprisingly easy to paint with ref and went rather fast. I will admit the entire time I was rendering him I did say every minute or so "I love you man" because he was turning out so good. Halfway through I then realized I still had to render Impulse. That's when I pretty much ended that night because it was already 5 am working on Tango and demotivation was setting in fast. The next day I was able to continue with hesitancy on Impulse but I managed to keep on keeping on and in the early hours of today I finished up the piece. Where I'm now writing about it close to 2 pm in a restaurant. Man though it was kinda hard to make Impulse and Tango look like cohesive and as if they were painted together.

Enjoy!

(Side note I applied for inprint and if I am to be accepted this will be available along side the three different eefs I've drawn and doc.)

[ma1dita]

basic chemistry

'between certainties and doubts' installment  part of the mean!remus agenda, aka a moment from a terrifyingly convoluted teenage situationship between remus lupin and an unidentified Hogwarts student (x fem!reader) wc: 2.5k a/n: amortentia fic!! they don't know that we know what they don't know! this kept me sane during finals, hope you enjoy! bit angsty, unedited. feel free to send requests for them!

—

“So is it true?”

The chair underneath you scrapes against the cobblestone as Pandora’s voice catches you by surprise. There are fifteen minutes before Advanced Potions starts, and the room is absolutely empty, save for Professor Slughorn phasing in and out of his office with two armfuls of scrolls in tow. Suddenly the blanket of peace that you’ve wrapped around your shoulders this morning feels like it’s been ripped from you—as a lot of things have in the wake of becoming the center of the rumor mill for everyone in your year.

“You’re mad if you believe that shit, Dora.”

“S’why I’m asking you. And I’m mad regardless of that,” she says with a smirk that makes her eyes glint in the candlelight, “Did you or did you not puke on Remus Lupin’s trousers at the party last week?”

“Is that what they’re all saying?”

A thick strand of blonde hair falls over her face, the color of a sunbeam—your best friend is grinning now as she scoots her stool closer to yours, “Some. I was going to ask you if you shagged him next.”

Your eyes lift up from the desk and you sniff, “I did not, for your information. I was drunk out of my mind.”

Technically that’s true. The drunk part at least—and you didn’t shag him. But you did sleep with him, next to him. All you remember of what happened after is faint breath against your neck and waking up to an empty bed. That time, he left before you did.

But the only thing consistent about it was that you ended things alone.

The door to the dark classroom flies open, and students start filing in, some with their eyes flickering to you and Pandora’s desk in the front of the room. Even with your head turned you could feel the weight of their stares and hear the hushed whispers no matter how much you tried to block them out. It’s been a week of dodging fake niceties and a week of Remus trying to make it up to you.

Of course, another thing you both have been consistent about is the inability of having a real conversation.

Professor Slughorn glides in with Remus in tow, his posture as stiff as a board. They’re murmuring to each other and even if you don’t mean to—you find yourself distracted by him and try to listen in.

“Well if you didn’t sleep with him, why’d he run after you through the portrait hole after you kicked him in his family jewels?”

“What?”

Your focus rips back to the blonde, who’s grinning now. She caught you staring at Remus’ back—and the sound of your voice makes him turn away from the lecture Slughorn is droning on about.

Your eyes lock.

Like a riptide, he pulls you in and draws back without a warning and without asking. You only start breathing again after you force yourself to look away. But it only took that singular moment for it to click in both Pandora and the professor’s heads from their vantage point at the front of the room.

“Ah yes, I have an excellent idea my boy—for this lesson, we’ll try something new,” the ghost chuckles, going to pat Remus’ shoulder, in which his hand phases right through to the boy’s rapidly beating heart. “You are a bright boy, Mr. Lupin. But you have to want it. Passing Advanced Potions will be an asset to your Auror registration, if you’re following in your friends’ footsteps!”

“I’m still not sure actually, pro–”

“Uh-uh,” Slughorn tuts, “nonetheless, you must not give up! Miss Rosier,” he says, floating over to your desk, “will you do me the pleasure of being Mr. Potter’s partner for the day?”

“Anything for you, professor,” she smiles sweetly to her head of house, before shooting you a look and gathering her satchel.

“But professor! Moony’s essentially my sous chef,” James bellows from the doorway as he falls onto his stool.

“The sooner you both stop looking at this Potions classroom as a test kitchen for mayhem, the sooner you’ll have better marks in this class!” They continue to lightheartedly argue and Pandora eventually wrangles James back into the seat she took next to him.

“Can’t even cook,” you mutter under your breath. Remus is gently setting his stuff down next to you like he’s trying not to set off a bomb, but smiles softly. It’s the first time you’ve addressed him since the party. Your body language tells him you’re still upset, or worse—that he can’t fix whatever he broke within you that night, but he’s trying in his own way. Brushing against you in any way he can in the halls, treats from the kitchen delivered by the house elves, and waking up early to feed the toads before you run Frog Choir practice, no matter how much they freak him out.

“I’ve always been better under your direction.”

It has been a long, agonizing week without his calm. And Remus reckons he’d do anything to have you back, if only you’d spare him a proper glance, even though you’re already hunched over the same desk.

“Amortentia! The potion that emulates the feeling of being in love,” your professor sighs dreamily as he walks between and through the desks and classically spirals into a tangent. He makes a point to walk through Sirius who reacts with a full body chill, making Dorcas snort beside him at the sight. The rest of the words go blurry in your head. You just have to get through this class, and everything will go back to normal—whatever that is must be better than giving Remus the cold shoulder.

“But be warned, my students—Amortentia will never be able to replicate true love. People spend most of their lives trying to find that feeling. And let me tell you right now, that it won’t be at the bottom of a vial,” he says knowingly. At the table next to you, Severus cracks his knuckles and looks uncomfortable. Lily Evans looks up from her notetaking to glance at him from afar, before turning back to Emmeline.

Everyone starts moving around you two, and you slowly push yourself up from the stool, “I’ll get the Ashwinder eggs. Start cutting the thorns of the roses,” you say simply. The tone of your voice makes Remus’ smile drop.

You’ve had a lot of time to think in your week of being Remus-free. But you’ve realized that he’s everywhere you can see, even when you’re not looking for him. Even when people stop their conversations when you walk past, or the tense silence that follows when you both walk into the same room, Remus Lupin is in the way you drink coffee in the mornings with a square of chocolate. He’s in the grass stains on your favorite jeans after laying in the field to read a book. Moonbeams through windowpanes on walks after dinner, and crescent-shaped indents in your palm because he’s not there to hold your hand. Worst of all, he’s even there when you close your eyes and tuck yourself into bed at night—the missing shape of him against your backside like a phantom pain you can’t quell with any spell you’ve learned at school or potion Madame Pomfrey can prescribe.

And now he’s here and looking worse for wear. Tired and sullen, with bags under his eyes like he always looks around the middle of the month when all his responsibilities and problems catch up to him. Maybe his mum is sick again, though you’d really like to think he’s losing sleep over you for just this once.

The bowl of Ashwinder eggs clink onto the desk with a sizzle once you’ve made it back to him.

And the lesson continues.

“Is this how it’s going to be?” Remus mutters, looking like a kicked puppy from the view you have of him in your peripherals.

“I don’t know what you mean,” you say simply, slipping your dragonhide gloves on and cracking three of the eggs into the cauldron with practiced ease. The glow coming from the mixture makes your face glow warm like sunlight in the dreary dungeons, he notices, momentarily distracted, and then he tries again.

“Cariad, what more can I do to make it up to—”

A gloved hand catches his wrist before he nicks himself with the blade, “Watch. Be careful. Eight rose thorns, and then stir for fifteen minutes counterclockwise.”

“You’ve always been better at this,” he mumbles. Not like another scar would’ve done anything— he’s had worse after all. But not like this. The simple touch is not enough. He wants to feel your skin again, wants it all back now that he can’t have it. He supposes that’s the cruelty of his fate, being sat next to you and not being able to do anything about it.

You pass him one of your gloves wordlessly, nodding in agreement as you remember the sun-soaked afternoons in Hope’s kitchen, a mess of flour and something always burning on the stove because he’s too busy kissing your neck or getting invested in the stupid magazines you read aloud to him.

“Potions is like basic chemistry,” you swallow, cleaning the leftover stems as he makes smooth chops over the sharp edges, “Everything needs to be precise and done with intention for it to work, or else the results will be unexpected.” He gets a whiff of your perfume and feels like he can breathe again, the pearl dust erupting in a plume of sparkling smoke, making you cough.

Immediately, he drops the knife and rubs your back in gentle circles with his bare fingers coming up to rest at the nape of your neck without a second thought.

“Moony! You smell anything yet?” Peter calls out from his station across the room, accidentally dropping whole pearls into his cauldron and making Evan pinch the bridge of his nose in frustration.

Right. You’re not alone.

He drops his hand then, biting his lip as he starts to stir, “Never understood it. Chemistry. The reactions are incomprehensible to me, I suppose, like magic.” Remus feels like he’s talking to himself, but he knows you’re listening with the way you watch him slide on the glove.

The only sound at your table is that of the ladle clanking against the side of the cauldron in steady, measured motions, just as you’ve taught him.

—

“What a lovely sheen!” Professor Slughorn gushes, inspecting the contents of the cauldron in front of you. The fire burns low underneath it, a simmering bubble releasing a scent that wafts over its onlookers, you with eyes frozen onto the hardwood of the table, Remus staring at it curiously, and the professor who clearly thinks pairing you two up is the best idea he’s had in months.

“And the smell! Truly wonderful! I think you and Mr. Lupin have earned his first O for this course. Lovely work, you two!”

Remus is grinning proudly, hand going out to squeeze your thigh under the table and you flinch, blinking away any wetness that’s pooled in your eyes—the L word has you shaken about the other L word you’re coming to realize. Bells ring overhead and you grab your things, leaving him in the dark swirl of your school robes.

“Actually liked that lesson,” James chuckles, the other two boys dragging their feet behind him as everyone starts to leave the dungeons, “Maybe you should stay away from me more often Moony. Rosier isn’t half as bad as her twin.”

“She’s really not!” Peter pipes up, “Though I think I’m more scared of Pandora.” Sirius laughs next to the blond boy, helping him with his bag, “So is Evan.”

Remus hasn’t said a word, stuffing scrolls and half-bent quills into his knapsack and Peter shoves his shoulder, “So? What’d you smell?”

It was a peculiar situation, Remus will admit, as he looks up at his boys and shrugs, “Didn’t smell anything.”

Three resounding gasps of confusion arise as the Marauders look at their friend in utter confusion. Sirius scoffs, “Funny man you are, surely you must’ve smelled something.”

The green-eyed boy shakes his head again, “I didn’t smell anything. Honest. Maybe it’s a placebo or something.”

James rolls his eyes, “You and your secrets. Actually how does Slughorn smell if he’s dead?” The boys fall into a conversation of their own, and Peter hands Remus the glove left on the table, “Oh don’t forget this!”

“Thanks Wormy,” he sniffs going to clear his cauldron, and for a split second his eyes look up to see you crossing the threshold with Pandora and Evan. He can smell the notes of your perfume from all the way across the room as well as the Cadbury Milks he’s asked his mam to mail him sitting in the bottom of his bag—he’ll give them to you later if he’s still feeling well. The full moon is tomorrow night, and every sense of his is elevated, he reasons. With a tap and swish of his wand, the air feels different as the magic evaporates—musty and frigid, unlike the warmth it held before.

“So what was that?”

“Drop it, Dora,” you grumble as you walk briskly down the hall with the twins hanging off of you.

“Oh no, I saw it too,” Evan teases as he pokes at your side, “There’s a lot of tension there. Either you want to kill him or fuck him.” He only laughs when his twin slaps him upside the head for his crudeness, running off to join Severus and Regulus, since the younger boy’s been waiting for them in the hall.

“He won’t say anything. You know him,” Pandora says, making you take a deep breath as you blink tiredly.

“I know. I just don’t want to talk about it anymore.”

“Last thing I’ll say and then I’ll drop it. Pinky swear,” she says with a comforting smile as she links your fingers together, swinging them between you with every step. The crowded hallway begins to thin as you both walk toward the Ravenclaw common room to play Exploding Snaps with Xeno before dinner.

“If you must.”

“The way you look at him, honey. That’s not nothing,” your best friend says, tugging at your arm that suddenly feels like jelly under her touch—but she brings you back to earth as she says, “Alright, subject change. What did you smell in the amortentia?”

You sigh and take a deep breath again as if you’re still in front of the bubbling cauldron and the cloud of sparkles that got into Remus’ hair. The smile on his face that was too knowing, too intimate for acquaintances in the eyes of the rest of Hogwarts’ student population. It made your stomach twist into knots and your heart drop even further, fall even more at the confirmation of what you already knew months prior.

“I couldn’t place the smell,” you say cautiously, almost as if resigning to the truth, “but it reminded me of summer.”

—

i don't do taglists anymore! follow @ma1dita-mail & turn on post notifs for updates :))