Here are a short list of CTRL shortcuts you can use in Excel to speed up your navigation.
CTRL A = SELECT ALL RANGE OR TABLE
CTRL C = COPY
CTRL X = CUT
CTRL V = PASTE
CTRL O = OPEN
CTRL W = CLOSE
CTRL HOME = GOES TO CELL A1 (HOME)
CTRL END = GOES TO END (LAST EDITED ROW AND COLUMN of WORKSHEET)
CTRL Z = UNDO LAST
CTRL Y = REDO LAST
CTRL S = SAVE
CTRL T = CREATES TABLE FROM RANGE
CTRL : = INSERT TIME (NOW)
CTRL ; = INSERT DATE (TODAY)
CTRL SPACEBAR = SELECT ENTIRE COLUMN
SHIFT SPACEBAR = SELECT ENTIRE ROW
CTRL PAGEUP = GOES TO PREVIOUS WORKSHEET
CTRL PAGEDOWN = GOES TO NEXT WORKSHEET
Do you have one which is not listed? post it below in the comment section :)
While in many tutorial exercises as well as in job interviews, you may be asked to create a VLOOKUP formula, in the real world you will quickly find that INDEX/MATCH is a far better solution.
To understand why, let's look at the syntax of each:
VLOOKUP(lookup_value, array, col-num, lookup_type)
VLOOKUP(what?, where?, which column? , approximate search: yes or no?), just like HLOOKUP, refers to a specific column number (or row) starting from the first column (or row) of your index search (the “where”). Why the first column (or row)? Because this is where Excel will look for your "what" !!
This means you always have to include at the very least all columns (or rows) starting from the "what" column (or row) all the way to the column_index (or row_index) number in the "where" range.
For example, if a customer discount is in column P, and customer name is in column C, your VLOOKUP function will look something like...
If you are working in a Microsoft environment, Excel or Word and on a laptop, you may have been frustrated having to select the Fn key together with the primary F1-F12 keys to run the desired command.
While the fix is easy on a Mac, it is not so on a PC.
Here are the instructions on how to do this on your PC (Windows 10)
1) In your Search Windows Box, type “UEFI”; this will bring a pop-up option “Change Advanced Startup Options”.
2) Select this option, in the next window select “Advanced Startup” and click on the button “Restart Now” (this will restart your computer)
3) Upon restart select “Advanced Options / UEFI Firmware settings”
4) Click on RESTART
5) Once the computer restarts, you will find a menu with several drop-down lists;
a. select “POST behavior - Fn Lock Options”.
6) The default is Lock Mode Disabled / Standard.
a. Select “Lock Mode Enable / Secondary”
Confirm and Exit and your settings are...
Have you ever received a graded essay handed back with the phrase, "Needs more
structure," or "structure needs work?"
Creating a structure for any written word, whether it is poem, essay, news brief, or novel, is an integral part of the message you intend to convey. Using long, convoluted sentences as means to convince the reader that your argument is very simple will usually only give the opposite impression; simple arguments are best conveyed with short, simple sentences. (For example, the opposite is true in Jonathan Swift's essay, "A Modest Proposal," in which he uses didactic and complex language in an effort to "convince" the people of England that the solution to their hunger and poverty problem is to eat their starving infant children; his complex sentences reflect the sarcastic and satiric nature of his essay, reflecting that he does not see cannibalism as a real solution.)
Structure also helps you keep...
Here's a method that is helping students lock in those AR, ER, and IR verbs!
So, you nod your head a lot and smile while your instructor explains how to conjugate verbs but you really, really aren't getting how they work at all! Sound familiar? Although you might be puzzled, there’s actually a reason that Spanish verbs have different endings for each tense. Well, are you ready to learn?
First of all, why do we even need to change the ending of the verbs in Spanish?
Answer: so that people know who in the world we are talking about!
In English, we have those wonderful pronouns like “I, you, he, she, it, we, and they” tell us what or who we are talking about. We pretty much use them all the time - yep, can't live without them. The good news is, we also have them in Spanish! The difference is that in Spanish we have the choice to use them or not. We have choices people, choices! When we change the ending of the verb in Spanish that's how we know who or what...
Prep your Homeschoolers to be Spanish Savvy!
The moment has come... Your homeschool counselor has added Spanish class to your Homeschool schedule. And the only thing you remember from your highschool Spanish is 'hola' and 'adios'!
Whew! Good thing I started these super savvy blogs, right?😀
Ok, no time to waste here, stick with me and launch your child into pure Spanish savvy!
First step of success is to encourage your Homeschoolers to love.. Yes love.. that he gets to learn Spanish because not everyone gets this chance. Then talk about how much Spanish he,she already knows (and you too). This would be a terrific conversation while sitting at your favorite Taco shop on, of course Taco Tuesday! Words you both already know,for example, taco, burrito, tortilla- you get where I am going with this, right?
Why the pre prep talk? Easy. Because in all of my 25 years of teaching and tutoring Spanish, there is one majorly savvy important fact-Attitude is everything...
I think we can all agree that taking a Spanish class can be exhilarating, invaluable, and unforgettable! Except if you are stuck in a rush hour 30 commute trying to get to that class! Or if you are sweating it out at the last minute to finish your homework so you don't have to really look like you are totally not with the program!
As you know, I am all about solutions, so......it's simple....really! If you really want to keep impressing and embracing your Spanish, take a fresh look at Online Spanish classes. They have improved alot since their subtle, low key entrance into the education world.
Since you also know I am all about the famous four, here are 4 incredible infofacts that will send you to your nearest internet device to sign up!
Infofact #1. Online Spanish classes are literally accessible to anyone who meets the criteria for individual programs. Are you in high school? No problem! Check with your School Counselor to see which meets the transfer requirements...
4 Great Keys to Breathe, Embrace, and Enjoy your Spanish Class!
You know the feeling! You are on a roll, you are finally "getting it", and now you want to eat, sleep, and dream Spanish! How do you do it? Read on mi amigo and discover four key elements to living the bilingual dream!
Key 1 Start using your Spanish with your Wyzant tutor or instructor in class! Any thought that you have, "What was that homework?", "When do we turn it in?" anything that you normally would ask in English, now ask it in Spanish! Not only will you be making them work for their money but you will also undoubtedly make their day :) But the real deal** the more that you do it, the more that you lose the translation process and really turn on the Spanish thought process. (Yes, it sounds deep and it is deep!)
Key 2 Hmmm....This next one is definitely for the 21 and over crowd! Go "Old School" and get a pen pal. A couple of ways you can do this, either...
Where to begin........
So, you've just been handed the southern region of Mexico from your sales director and congratulated on your promotion! There's just one thing......you don't speak Spanish! and sure you have a pretty generous budget but does it include having an interpreter travel with you all expenses paid? Interpreters aren't cheap, I know because I am one as well!
Let's start with..It's going to be okay! We are going to talk about a plan that works if you work with it. There are four major "must dos" to getting off to a good start to becoming bilingual and in this fabulous blog I am going to let go of those four secrets because it has been a really good day!!!
1. Connect with your local college/university/professional social media site, immediately..right now! and find out "who is who", in the Spanish tutoring/instruction world! I recommend a private Wyzant tutor, and yes I know there will be a cost but the investment is what I like to...
It's a fact...If you do not like the way you sound in Spanish you are not going to speak it...chances are even if a mouth watering churro is at stake!
So let's fix that right here, right now with some fabulous tips to accessing your inner Spanish accent.
Tip 1 Get a Tutor! I know, I know, but again ten fold, ten fold! But this time choose a tutor based on their accent. If they don't sound melodic when they speak Spanish then they are not the tutor for this mission. Keep in mind, your tutor does not have to be a native speaker just one that has taken the time to actually master the accent. So when you are what I like to call "proofing" a tutor, close your eyes and ask them to tell you why Spanish is the Language to learn! If you don't feel as if you have suddenly transported to the incredible beaches of Playas then again, this is not the tutor for the mission!
Tip 2 Start to really practice the vibrant pronunciations of the alphabet, numbers, and...
Steps to Developing Effective Study Skills
Step 1: Assessing Your Learning Style
Step 2: Knowing Your Interests
Step 3: Developing Appropriate Tools to Enhance Studying
Step 4: Making the Subject Work for You (even if you hate it or don’t get it)
Step 5: Constructing a Learning-Style-Friendly Environment
Step 6: Other Considerations in Developing Effective Study Skills
When we sit down to study, most of us follow a routine. We get our books together, get comfy (at a desk, on the bed, sitting on the floor, etc.), and set to work. Some of us turn on the TV or some music; others of us make our environment as quiet as it can be. What we do to study varies, but generally we reread our notes, textbooks, or study guides, and call it a day. The day of the test, we struggle to recall what we studied. Afterwards, we admonish ourselves for not studying hard enough or long enough, and doubt our performance. Does this sound familiar? It doesn’t need to be this way. Effective...
“Stay off of Facebook and personal e-mail during the workday. Make a to-do list and cross off items as they are completed.”
—Walter Kloepfer, Homer, Alaska
“I try to remember that today is yesterday’s tomorrow.”
“Feet first, feelings follow. I don’t wait until I feel like doing something, or until I am in the right mood, because that might never happen. So I jump in and start the project. Nine times out of 10, I find that, once I get started, I feel like continuing.”
—Leslie Pressnell, Lakewood, Ohio
“Make short lists of ‘musts.’ Take care of the most important things first, then take on other items. I give myself permission to do at least one ‘tolerable,’ ‘fun,’ or ‘worthwhile’ item each day, even if it’s not on the ‘must’ list.”
—Susan Hsu, Gainesville, Florida
“I need uninterrupted time to work, so I schedule at least one day a week with no appointments (especially if I am working at home). I allow myself one trip...
What you feed your body has a direct correlation to how your brain functions. Diet and nutrition impact cognition, attention, sleep, and mood. According to the Harvard Health Blog, studies show that people who eat “clean” or “whole” diets high in vegetables, fruits, unprocessed grains, and lean meats, are more likely to experience better emotional health. The better you want your brain to perform, the more unprocessed foods, proteins, vegetables, and fruits you should eat. Research shows that protein promotes alertness in the brain. Carbohydrates do the opposite. And artificial colors and flavors are even worse.
Pesticides, specifically organophosphates, found on fruits and vegetables may be linked to ADHD. Western diet — processed meats, fast foods, high-fat dairy products, and sugary foods — doubled the risk of having an ADHD diagnosis, compared with a healthier diet.
If you’re trying to learn something new, you might want to hit the gym a few hours after studying. According to new research, exercising 4 hours after learning a task can improve memory.
Neurotransmitters released by exercise lead to a production of proteins that "help stabilise new memory traces", study author Guillén Fernández, director of the Donders Institute for Brain, Cognition, and Behaviour at Radboud University Medical Center.
The take home message is that exercise should be used as a strategy for long-term memory retention.
Read the story here:
Physical activity — even something as small as fidgeting the hands — increases levels of the neurotransmitters dopamine and norepinephrine in the way ADHD medications do. Both chemicals play a key role in sharpening focus and increasing attention.
Attention “deficit” increases with the length, familiarity, and repetitiveness of a task. In other words, you tune out when tasks get boring! An activity that uses a sense other than that required for the primary task — listening to music while reading a social studies textbook — can enhance performance in children with ADHD. Doing two things at once, she found, focuses the brain on the primary task.
These sensory-motor activities are called “distractions.” But we call them fidgets — mindless activities you can do while working on a primary task. We’re not talking about wriggling in your seat. Fidgeting is more intentional. It’s pacing or doodling while on the phone or chewing gum while taking a test.
It has been my experience as a student teacher supervisor, while observing student teachers, there are instances when a student teacher is in a more supportive role; small group instruction or one to one with a student. There have also been times when I have seen that the Student Teacher's role was rather restricted. Before classroom teachers sign up to be a cooperating teacher for a student teacher program...please research your role. Teachers are so busy so make sure you have some time to enhance your student teacher's learning experience. Take time for weekly conferences, conference with the student teacher supervisor and try to record or observe the teacher candidate while they are giving lessons. When this relationship works and everyone does their part it works out so well for all involved. Its a wonderful learning experience for everyone!
Everyone should have a passion for music. Some students I've tutored got to a point where they think that there advanced players. Its good to interpret music if your own but but to think you know everything about music isn't right. You could always learn from everyone which includes professional musicians. Everyone learns differently and at there own pace. I still learn from professional musicians. I want to be better then I was yesterday.
One question that inevitably crops up is what my job is. I am a full-time tutor. This is all I do. Very few tutors work full-time, and I have a feeling that many other tutors (or anyone else reading this) may have some questions about what it means to be a full-time tutor. Thus, here we are...
Obviously, in order to be a full-time tutor, one must first have a love for tutoring. Tutoring is a very mentally straining job, and if you do not have a love for it, tutoring will wear you out fast. One thing that might not be so obvious is that one must also love driving. About a third of the time that I am "working", I am just driving to meet my next student. Having a good sense of direction and being able to read maps is also handy of course.
Another thing that a newcomer to full-time tutoring may not realize is the high time commitment. I was an analyst before being a tutor, and in order to make what I would have been earning, I work seven days a week, each day working...
I've noticed that more and more, I've been communicating with (usually younger) students who don't know how to approach someone older in a polite or respectful way. I'm a professional teacher, and even though many of my students are non-native speakers, whose grammar lapses I can forgive, I sometimes get messages that are actually rude. As if I'm someone (faceless of course when online) whom they can order, or demand something of, they approach me in a way that makes me not want to work with them.
I would like to urge all students to consider how you write to a potential or current tutor, and I'd like tutors, no matter your age or level of experience, to consider responding only to students who can write politely, or point out to them their lapses of judgment. All of us, tutors, parents, adult students, youth, should approach this business from a position of respect. This is not a social media with anonymous strangers, nor a forum for hiring or being hired devoid of human respect...
I found this in my reading today from Overcoming Dyslexia by Sally Shaywitz, M.D.:
"A child with dyslexia needs a champion, someone who will be his support and his unflinching advocate; his cheerleader when things are not going well; his friend and confidant when others tease and shame him; his advocate who by actions and comments will express optimism for his future. Perhaps most important, the struggling reader needs someone who will not only believe in him but will translate that belief into positive action by understanding the nature of his reading problem and then actively and relentlessly working to ensure that he receives the reading help and other support he needs."
This represents the model all reading tutors should aspire to be for their students.