Hello friends! After working with a few students in basic and advanced Microsoft Excel techniques, I've created a syllabus that I think will work for anyone trying to learn Excel. Complete with worksheets, tutorials, and homework assignments.
What's happening in the world of private tutoring?
Microsoft Excel BlogsNewest Most Active
From business school to being in the corporate world for over 15 years, I've observed that majority of people 'feel' that they should be better with Microsoft Excel but are not. Nevertheless, they never take the time to learn even the basics of this software and are struggling for hours with some simple work that should take them a couple of minutes to complete. For most people, all it takes is some simple demonstration of the ease of the program and I've seen dramatic improvements in a very short amount of time. If you have ever felt this way, there are ways to get better and more comfortable. I welcome comments and questions regarding getting more comfortable with Excel.
Microsoft Office is suite of programs used around the world for office and school work. The Office suite includes Excel, Word, and PowerPoint. One of the advantages of using these programs is that they have a lot of features, and you can use them to create a variety of projects in many different styles and formats. Another advantage is that many of the shortcuts that work in one program work in the others as well, and they haven't changed from one version to the next. I use Microsoft Office everyday for my job. I also tutor students who want to improve their skills in one or more of these programs. There are hundreds of shortcuts. Most people don't need to know them all (I don't!), but having a few of these in your back pocket. Here are five of my everyday favorites; they work equally well in Excel, Word, PowerPoint, Outlook and OneNote. Ctrl+X means: hold down both Control and X. Ctrl+X -- Cut selected text. Ctrl+C -- Copy selected text... read more
Sometimes you need to repeat the data or formula from just one cell, and you don't want to bother with copy and paste. You can quickly copy the contents of a cell to the cell just below it: Click in the cell just below the cell you want to copy Press CTRL + ' (apostrophe) Press ENTER It's that simple!
Through the years, I have seen numerous reports that provided the reader with no useable information. Why you may ask? Because the report creator didn't understand the difference between data and information. Data is a number; an answer; a disparate answer without focus or label. An example could be 7, apple, The Oscars. Great, what does 7 mean? I know what an apple is, but what is the context? Here's an example of a report, what's wrong with it? Quantity Item Price Amount 5 Apple $10.00 $ 50.00 1 Banana $20.00 $ 20.00 2 Pear $25.00 $ 50.00 Total $120.00 What does this report show? Is it an Inventory Report?, a Sales Report?, a Purchase Order?, an Invoice? You don't know because the all important LABEL is missing. Once the Label(s) are attached, the report is now information. Inventory Report As of 2/28/2013 Quantity Item... read more
It is the mark of an educated mind to be able to entertain a thought without accepting it. (Aristotle) This quote provokes me never to accept the status quo and always challenge assumptions. It is the thought that through education we never stop learning or seeking after truth and knowledge.
The IRS have opened up form 8863 Education Credit and you can file that form now. Many other credits are still not ready and taxpayers await these in order to file. What is my opinion as a tax professional for 26 year? See below. TAX PLANNING: It is perfectly legal to plan your tax affairs to your advantage as long as you don't break Tax Law. Many people don't know this. Some avoid tax professionals, claiming that they file their own taxes yearly... WORD OF ADVICE----when you are sick you visit a doctor, when you car needs repairs you take it to the mechanic---Trust me if you don't take your taxes to a seasoned tax preparer , I guarantee you that you are losing out on solid TAX PLANNING ADVICE ... Food for thought.
Hello! This whole site is pretty new to me, but I wanted to briefly show my interests and experiences, as they are fairly diversified: Sciences: As noted above, most of my experience is with chemistry. Organic Chemistry is my specialty, but I am also familiar with Inorganic Chemistry. I've been a Teaching Assistant for college freshman level courses through upper level chemistry courses. I started off as a Biology/Pre-med major, so courses like Physics and Biology are high on my understanding. Tutoring in most of the sciences will be my highest level of knowledge/experience. Math: I was a mathematics minor as an Undergraduate, so I am very familiar with a fair amount of mathematics divisions. Calculus is fairly fresh, but I am most proficient with Algebra. I have a secret love of the mathematics, so tutoring math in some way would definitely be great. Dance: I just noticed that dance was an option for the "subjects", so I listed it. I am a Lindy Hop dancer and have... read more
Sometimes it's easier to use the keyboard to change to a different worksheet, especially when you're already typing data or formulas into the sheet. To switch to a worksheet to the right of the current sheet, press CTRL+PAGE DOWN (hold down CTRL and tap PAGE DOWN until the appropriate worksheet appears). To switch to a worksheet to the left of the current sheet, press CTRL+PAGE UP.
If you want to quickly select (highlight) all of the contiguous (continuous) data in your spreadsheet (such as a table of information), follow these steps: - Click anywhere within the contiguous data - Press CTRL+A If there are rows or columns within your data that are completely blank, the highlighted selection will stop at those "borders." If you want to select the entire spreadsheet, including any blank rows or columns, press CTRL+A+A (in other words, press CTRL+A, then while continuing to hold down CTRL, press "A" again). Alternatively, you can click on the button in the top left corner of the sheet to select the entire sheet. This button is located at the intersection of the row and column headings, just to the left of the column A button and just above the row 1 button.
Congratulations to MADISON for her dedication and good grades in her challenging business classes. Madison, we're proud of you for doing a great job--it looks like you're going to get A's and B's in all of your classes. Since you are taking some very challenging subjects, passing them all and getting good grades is a praiseworthy accomplishment on your part!
Congratulations to Niesha for getting an "A" on her Operations Management final exam. That was a challenging class, and I know you worked hard for your good grades. I am so proud of you for your dedication and resulting success. Keep up the good work, and before you know it, you will be graduating!
My recommended strategy to Students at all academic levels for learning and successfully passing the course at all modalities (on-line, on-ground) is the culmination of at least ten years of teaching and tutoring statistics at the undergraduate, graduate, and post-graduate levels in business, management, sciences, social studies, and psychology. It consists of the following: 1. The first is to learn how to overcome fear and anxiety from the unknown and look at tutoring as a prudent investment to your immediate future and success. Engage the tutor from the start of the course and don't prolong the decision because of the complexity and quantitative nature of the subject area. This component of the overall strategy is to keep the weekly normal pace and retain basic real life knowledge for ongoing participation in the political and economic process of the National affairs and State-of-the-Union. 2. Academic Reading Materials and Study Guides encompass three distinct sections... read more
I am dedicated to teaching you how to fish. Like the saying goes... “Give a man a fish and he eats for a day; Teach a man to fish and he eats for a lifetime”. I love to teach! Give me the opportunity to teach you to fish. My favorite subjects include: Microsoft Word, Microsoft Excel, Microsoft PowerPoint and Microsoft Visio
Hi! My name is Priscilla. I offer quality tutoring one-on-one and corporate. I have worked with ages from 9 to 89; And, I believe that everyone has the ability to capture the use of a computer tool to accomplish a special project. From Birthday Party Invitations to Home Inventory Insurance Reports, all projects are unique to the person/organization that desires to create them. Matching lessons with educational level and need is a primary goal for me. My favorite subjects include: Microsoft Word, Microsoft Excel, Microsoft PowerPoint and Microsoft Visio
Determining whether to use Microsoft Word vs. Microsoft Excel is debatable. Typically, I look at the usage goal of the end product. Most end products can be created in Excel, Word and/or PowerPoint. If the end product will be maintained online and will require formulas (i.e. automatic mathematical expressions: add, subtract, divide, etc...), I prefer Excel. If the end product will be printed and maintained manually (with no need for automated calculations), I choose Word or PowerPoint. For Example, if an Agenda needs to be maintained in a format that includes the tallying of the amount of time to be spent on each topic, Excel could be used to contain a formula to calculate the total hours spent. Another example is Invoices. If the desired end result is to create a document that is printed and used to hand-tally totals, tax and discounts, a Word document would be desirable. However, if the desired end result is to create a document that will be used on-line to maintain... read more
There is still a segment of the population that has difficulty with computers or “How to Use”: a software program, the computer as a tool, or taming the beast they see on their desk at work. The first thing I say to comfort my students is that they are not going to break their computer by doing something “silly”. They may get a garbage (or unexpected) response from the program, but that is simply because computers are machines that need to be told what to do. True, computers are excellent at doing things, but computers do not have the level of understanding how to read our minds and do what we want the computer to do. This perceived “dumbness” on the part of the computer presents challenges to even the best tutor. Why, because humans all have different learning styles and: 1. Most students learn differently than you do. 2. Each student learns differently from other students. 3. No one teaching method will effectively reach all students. 4. A tutor cannot... read more
My wife is worried about me because I was tutoring in my dreams last night.
Secondary Education Causing Injustice to Students with little to no practice in Microsoft Office Software
In recent years, it has become increasingly apparent that secondary education has begun to place more dependence on students to learn software such as Microsoft Word and Excel on their own or wait for courses at the college level. This is a great injustice to the students as many shortcuts and tools within each program are unknown and the software is not effective or efficiently used by the students. Students have come to accept the pre-formatted fonts and colors for text and plots without consideration to intended use and due to a lack of knowledge concerning how to change these items.
Hello! My name is Kathleen (Kathy). I came across WyzAnt, and I feel like it is exactly what I have been looking for! I have always excelled at all things English. I love spelling, grammar, vocabulary, reading, writing, teaching computer skills, etc. I am fascinated by language and by the choices people use to express themselves. I would love the opportunity to help a student feel more confident in all subjects related to English. I also worked as an Executive Assistant for many years, and am very proficient in all Microsoft Office programs, and find them to be a great deal of fun once you get used to them. Technology is moving so fast, and keeping up with the latest software versions is crucial to surviving in today's workplace. I would love to meet you and see if there are some subjects I would be able to assist you with for your future success.