Microsoft Excel Tips and Tricks You Need for Pivot Tables

Microsoft Excel Tips and Tricks You Need for Pivot TablesMicrosoft Excel Tips and Tricks You Need for Pivot TablesPicture this Your new boss needs to present her annual budget to the executive team for sign-off, and shes asked you to format her Microsoft Excel spreadsheet so it looks sharp. What do you do? You try to piece together the key learnings from past Excel training sessions. But if your mind goes blank, dont fret. Professionals in administrative jobs often need to format reports, and weve got the Microsoft Excel tips and tricks you need to get the job done.Meet the pivot reiterleOne of the most useful Excel tips and tricks is the pivot table. When considering a format to best schirm your data, pivot tables are a wonderful vorkaufsrecht to work with. These tables summarize the data in your spreadsheet, extracting the most important points from large sets. This allows you to readily view your data from different perspectives.Proper use of pivot tables also allows users to disp lay and print relevant data in an organized format. However, these tables can be hard to work with because of the way they are laid out on the screen. You can save a lot of time by selecting the easiest layout for your task before creating your report.A good source of Excel tips and tricks specific to pivot tables is ... well, Microsoft itself. Microsoft has createdhandy tutorials for Excel 2010, Excel 2013 and Excel 2016.There are three layout options for pivot tables in ExcelOutline form outlines data in the standard format for pivot tables.Compact form minimizes the need to scroll by showing all fields in one column. This layout contains field nesting for related fields.Tabular form lays out data in table form. This format makes it easy to copy cells to other spreadsheets.Keep in mind that outline form can be hard to work with because data is not easily seen or formatted. This format displays all available data, including subtotals that may not be relevant or necessary, making th e report harder to follow. It may also display so much data that users have to scroll repeatedly to view relevant cells.With that in mind, heres another of our handy Microsoft Excel tips and tricks Before doing anything else, click anywhere in your pivot table to display the Design tab. Click Report Layout from the Layout group in that tab and then choose a layout more conducive to your needs. For example, use the compact layout rather than outline layout to display a cash flow report so you dont clutter your report with subtotals and other irrelevant data.Clean up your report with more Excel tipsOne of the challenges of working with reports is that they can overwhelm you with data. If you see a lot of data cluttering up your screen, you may not know where to begin Other Excel tips and tricks can help you overcome that.Eliminate clutter by setting Excel to hide unnecessary information. You can hide rows and columns by clicking anywhere in the pivot table to display the Options tab. Then, go to Show/Hide in that tab. You can also hide fields you are not using, turn off display of subtotals you dont need to see, and hide empty rows and columns by going to the appropriate area in the Options tab.Use styles and banding for reportsExcel comes with a variety of style options for reports. Look at the available styles by clicking anywhere in the pivot table to display the Design tab and selecting the Style Gallery option. Choose a style that is easy on your eyes. Using a style will automatically format certain elements of the entire report, such as fonts, alignment and how numbers are displayed.You may also want to use banding to make reports easier to read. Banding makes alternate rows different colors so you can see data more clearly. Automatic banding can be added to the report by choosing Banded Rows or Banded Columns from the PivotTable Style Options group in the Design tab.Excel at administrative jobsUsing these Excel tips and tricks to add your own formatting t ouches can help you make your reports easier for your manager and others to comprehend - and make you look like a tech-savvy star.OfficeTeam has the resources you need to succeed in your career. Explore all of our tech tips for more ways to make administrative jobs a little easier.More Microsoft Excel tips and tricks5 Excel Tips and Tricks for Fixing Your Broken Formulas5 Ways to Save Time Using Excel Shortcut Keys6 Excel Tips That Can Upgrade Your Spreadsheets

Hired! Persistence Pays off with Data-Storage Job

Hired Persistence Pays off with Data-Storage JobHired Persistence Pays off with Data-Storage JobSales manager seeks more job security and lands a senior analyst position without relocating.Curtis Breville got a new job when he wouldnt take no for an answer.Looking through job listings on Ladders last fall, he came across a position that had detailed requirements for a senior analyst at Enterprise Management Associates, a data storage company in Boulder, Colo. I had just about every one of those requirements nailed, he said. So I filled out the application form and attached my resume. Two days later, I received an e-mail saying essentially, Thanks, but no thanks, he recalls. The letter said, After looking at your resume, your experience does not meet our needs. It kind of ticked me off, he said, laughing.So the SalesLadder member sent a letter back to the recruiter that read, After reviewing your needs, Ive determined my background is very much what you are looking for. He also create d a table that listed its requirements and across from that, his experience.For each of their 30 different requirements, I wrote my experience, he said. I fully expected them to say, This guy is a jerk, but I felt I had to stand up for myself. I welches qualified for this job. The next day, I got a request for an interview. And after I received a job offer, my new boss said that my letter proved to them how much I wanted the job.Breville said he had never done anything like that before but believes it was his experience in his previous position that gave him the confidence to push back.He had been working for a small French storage-management company as the North American sales manager. I was saying to people, Hey, weve got a product from a small French company that youve never heard of and not getting any interest, then trying again and eventually selling it. Once you do that, it gives you a lot of confidence in your ability to sell something. I had the confidence to push, and back up what I was pushing.Breville had been working at the companys Denver office for just a year when, this past fall, he suspected it was having financial difficulties. When the paycheck isnt in the bank when its supposed to be and expense reports are not paid on time, you see the writing on the wall. Two weeks after my paycheck wasnt there, I took some proactive steps to fix the situation.In late October 2008, he started looking for a new job. He found the job on Ladders the first night he looked at the listings, accepted an offer in November and started his job in December.Breville his wife and three children, ages two, four and 11, had moved to the Denver area just six months previous so he could work for his previous employer. Not wanting to uproot his family yet again, Breville made the decision to limit his search to the Denver area. A lot of the data-storage companies that I would look to for employment are headquartered here or have major offices here. Plus, we love Denver we love being close to the mountains. We wanted to stay in this area.He was totenstill working for his previous employer when he began his search. And while he was a bit nervous about the economy, after doing some research, I saw jobs that needed people with my qualifications, and that calmed my nerves.According to Breville, data storage is a safe field of employment. There is never a lack of need for storage, he said. No matter how bad things get, companies need to buy storage. Every company uses it - every time a store or restaurant rings you up, thats a transaction they need to back up. Every day, millions of transactions take place that have to be saved. Every company that does business is saving its data. I went into this area because I thought it was a high-tech growth market.Initially, Breville was looking for a position in either sales or marketing. And he saw several jobs in that area. But when he saw the listing for the analyst position at EMA, he saw a job where he could u se all his experience technical, customer relationship, management and sales.All that experience comes together in his new position, in which he looks at trends to predict where the market will go and what customers will be asking for. People are paying for your opinion, he said. Vendors of storage products contact them to hear me talk about their products and provide information that might help them produce or market it better. Im helping companies refine their messages, let them know if they are on target for what the market is asking for. I help them with research and development, so they can start coming up with new products and solutions.He also works with consumers who use his company as industry technology experts. Were not selling hardware or software were just helping them figure out the types of products they need.In the end, Breville said he is happy he made the change. His former company is still in business, but he feels better working for a bigger, more stable company. His previous company had a terrific product, it was sorely overlooked, and it got hard hit by the economy. The company is still around it restructured, and is now about one-quarter the size they were before I left. If I didnt have young kids - if they were older and had moved out - and if I didnt have a mortgage, I could have taken a risk with paychecks coming in late. But right now, Im at a time in my life where I couldnt do that.

Resume of James Bond [infographic] - Kickresume

Resume of James festverzinsliches wertpapier infographic - KickresumeResume of James Bond The whole world is in anticipation of the new James Bond movie SPECTRE. Some of you have already seen it, some of you have to wait for a few more days. Here is resume of James BondThe expectations are high because SPECTRE is supposed to be the worlds most expensive movie ever made costing over $300 million.The newest James Bond is played by Daniel Craig again. This British actor has quite some experience with 007 movies. We have seen him in Casino Royale for the first time following with Quantum of Solace and Skyfall.In honor of the 007 agent we have created a TOP SECRET resume of James Bond filled with information about him you didnt know Create your resume for FREE Share Your Feedback or Ideas in the Comments

Tips for Choosing Between a MPA or CPM

Tips for Choosing Between a MPA or CPMTips for Choosing Between a MPA or CPMOne of the common ways public servants advance their careers is to pursue graduate degrees or professional certifications. While some career paths lend themselves to specific degrees or certifications. For instance, a master of public health would be beneficial for someone seeking senior positions in health policy. For those who do notlage have a specific degree or certification that will help them advance their careers, the degree and certified public manager designation are achievements that can benefit just about any public employee looking rise through the ranks. A common choice workers in all levels of government face is whether to pursue anMPA degree or a CPM designation. Here are the major factors playing into this choice. Stage of Career Government workers late in their careers tend not to seek advanced degrees or certifications. They have so much experience that initials behind their name do not to give them a leg up in the government hiring process. Those early in their careers and in the middle of them, however, to pursue advanced degrees and certifications. Mid-career public servants gravitate toward the CPM certification. These people have enough experience to legitimately apply for senior positions but would look more attractive to hiring managers if they have an advanced degree or professional certification listed on the job application. All things equal, a certification could push one candidate over another and make the difference between getting an interview and getting removed from the hiring process. Younger workers tend to go for graduate degrees. These people are used to meeting requirements laid out by professors and are familiar with the bureaucratic processes universities put their customers through. Mid-career employees are sometimes intimidated by the prospect of going back to school. They havent taken formal classes for perhaps decades and do not know how they will assimilate themselves into a graduate program. Time Commitment MPA programs take about two years to complete on a full-time schedule or about three years on a part-time schedule. Some universities require MPA students to attend full-time and only offer classes during the day. Obviously, this does not work for the vast majority of government workers. This is why more and more universities have begun offering classes on evenings and weekends. This is more conducive to a part-time school schedule government workers need. Like MPA programs, CPM programs take two to three years to complete however, the time commitment within those few years is significantly less. Participants meet a day or two per month. Government organizations typically allow staff to use work time to attend such training because the content employees learn can be applied directly to their jobs. While applying material right away may seem like an ancillary benefit, it is really a primary benefit. Particip ants can show their managers immediately how the program is impacting their work performance and improving their management skills. Cost Some government organizations pay for employees to take courses within MPA and CPM programs. When government organizations reimburse college course such as those within MPA programs, some require employees to remain with the organization for a specified period of time. Otherwise, the employee must reimburse the organization for tuition paid. Employees must reisepass a course before an employer reimburses for it. If someone considering an MPA or CPM program will not be reimbursed by an employer, cost becomes a major consideration. MPA programs are much more expensive than CPM programs. Level of Prestige As noted earlier, MPA programs require a greater time commitment than CPM programs. Correspondingly, MPA programs also require a greater amount of effort. Because MPA programs require more effort than CPM programs, MPA degrees are more presti gious than CPM designations. This does not minimize the value of a CPM designation, but it does place a higher value on the MPA in the minds of hiring managers.

Coast Guard College Student PreCommissioning Initiative

Coast Guard College Student PreCommissioning InitiativeCoast Guard College Student PreCommissioning InitiativeMany people wonder if the Coast Guard has an ROTC program, as do the other military branches. The answer is no. The Coast Guard has an Officer Candidate School, and an Academy, as do the other services, but no ROTC program. What they do have, some might think is a better deal than ROTC The Coast Guard College Student Pre-Commissioning Initiative, or CSPI. Under this program, college sophomores can receive active duty pay at the rate of E-3, as well as a scholarship for their junior and senior year. Upon graduation, candidates attend the 17 week Coast Guard Officer Candidate School and are commissioned as an ensign. After commission, they must remain on active duty for at least three years. Sounds like a pretty good deal, right? Two years of college scholarship, two years of enlisted pay, and a commission, all in exchange for three years of active duty. How can you beat that? Well, there are a couple of catches, which well discuss in a bit. But first, a little bit about the program Program Overview The CSPI is a Coast Guard scholarship program for college sophomores (apply as a sophomore, started the program as a junior). The program provides a monthly salary, full tuition, some fees, and the cost of some books during the students junior and senior year. Members in the program must attend enlisted basic training, and participate in various Coast Guard training events throughout the duration of the program. During their junior year, CSPI students attend the Officer Indoctrination School at the Coast Guard Academy or receive on-the-job training at various Coast Guard operational units. Upon graduation, members are guaranteed the opportunity to attend Coast Guard OCS. If the applicant graduates from OCS he/she is commissioned as an ensign in the United States Coast Guardand is obligated to complete at least three years of active duty. Eligibility Re quirements Score 1000 on the SAT, 1100 on the SAT I, 23 on the ACT, or ASVAB GT of 109 or higherBe between 19 and 27 (applicants must have reached their 19th birthday, but notlage their 28th birthday as of 30 September of the fiscal year in which the panel convenes.)Must be a sophomore or junior (with at least 60 college credits completed toward your degree)Enrolled in a four-year degree program at an approved institution with a minimum 25% minority populationMust be able to complete a bachelors degree within 24 months after entry into the program Must not be a conscientious objectorMeet all physical requirements for a Coast Guard CommissionMaintain a GPA of 2.5 or betterMust be a U.S. CitizenMust be able to obtain a Secret security clearanceDependency - If single, may not have sole or primary custody of dependents.If married, may not have more than 2 dependents (your spouse is considered your dependent, regardless of military status).Financial - Must meet all financial obligations , and not have a debt to income ratio in excess of 30% ratio of debt to projected income at applicants accession level (i.e. at the E-3 level). Benefits Full tuition, some or all of textbook costs and approved fees paid for two yearsMonthly salary of E-3 payMedical ( Tricare ) coverage and Servicemembers Group Life Insurance30 days paid leave (vacation) per year Whats the Catch? College/University Applicants must be a sophomore or junior undergraduate student enrolled or accepted for enrollment in a bachelor degree program at an accredited college or university designated as Historically Black Colleges and Universities (HBCU)Hispanic-Serving Institutions (HSI)Tribal Colleges and Universities (TCU)The following colleges and universities located in Guam, Hawaii, and Alaska- University of Guam- The University of Hawaii at Manoa, Hilo, and West Oahu- Argosy University - Hawaii- Institute of American Indian and Alaska Native Culture Online Degrees Online degrees do not qualify f or CSPI - however, individuals attending an online institution may apply if they have acquired a four-year institutions acceptance to earn their undergraduate degree. Foreign Degrees Applicants possessing an associates degree conferred by a foreign school are required to include in their application a course-by-course assessment from an organization such as Education Credential Evaluators, in addition to the inclusion of the translation of their degree (if in a language other than English). Case-by-Case Consideration Coast Guard Recruiting Command may consider, on a case-by-case basis, schools not included in the above description that has had a minority student population averaging at least 50% of the total student enrollment for the past three years. In order to be approved, the applicant must be currently attending that school. Service Obligation. In order to enroll in the program, you must enlist as an E-3 in the Coast Guard with a four-year active dutyenlistment contract, and a four-year inactive reserves duty obligation. Like all anfangsbuchstabe accessions, your total military obligated service is a total of eight years. Whatever portion of that time is not spent on active duty is spent in the IRR (Individual Ready Reserves). For example, if you spend two years in the program, then three years as a commissioned officer on active duty, and elect to separate, you are then placed in the IRR for the next three years (total of eight years), and can berecalled to active dutyduring that time in the event of war or conflict. Enlistment. As mentioned in the paragraph above, you must first enlist on active duty in the Coast Guard as anE-3and attendCoast Guardenlisted basic training. If you fail to complete any portion of the program, fail to maintain a GPA of 2.5, or drop out of the program, the Coast Guard may (and probably will) reassign you as an active duty enlisted member to a Coast Guard operational unit for the remainder of yourenlistment contract. If you then fail to complete your enlistment obligation, you may be required to reimburse the Coast Guard for any expenses they have paid towards the cost of your college education, in accordance with United States Code,Title 10, Section 2005. Duty Requirements. While in the program, you must wear your Coast Guard uniform at least one day per week while attending college classes. You must maintain Coast Guard weight, fitness andgrooming standards. Additionally, you must be enrolled for a minimum of 12 credit hours, attend all scheduled classes and work a minimum of three hours per week for thelocal Coast Guard Recruiter(performing any and all duties he/she assigns you to do). UCMJ. CSPI students are military members on active duty. As such, they are subject to the provisions of theUniform Code of Military Justice(UCMJ). This means students are subject tocourt-martial,nonjudicial punishment, oradministrative sanctionsshould they commit amilitary offense. For example, while in the program, i f you decide to skip a class because you want to see the latest movie, or feel like sleeping in late, the CG could punish you for Failure to Go, which is a violation ofArticle 86of the UCMJ. If you decide to smoke a little week with your college buddies on the weekend, and the CG finds out about it, you could be punished for a violation ofArticle 112a. If you get a DUIor are caught drinkingunderage, or found to be drunk when you should be in class...well, you get the picture. In addition to such UCMJ punishments, you would also likely be removed from the program and required to perform your remaining active duty time as an enlisted member. Still interested? Then the person to see is your localCoast Guard Recruiter. The recruiter can give you additional details, as well as yearly application date deadlines.

The Key to Successful Wordpress Resume Theme

The Key to Successful Wordpress Resume Theme Google Fonts also have the theme that are nice for customizing the typography. Elegant Resume is a completely free WordPress theme that may be utilized to konzept easy and stylish resume. Wordpress Resume Theme Options Possessing a resume website definitely provides you an edge in the hunt for the best job for your career. Its simple to customize and has an attractive design so that its excellent for somebody who requires a CV website for potential employers to view. When looking for employment, resumes are all we want to present relevant details about ourselves. There are angeschlossen resumes and portfolios that could aid you with that. The Battle Over Wordpress Resume Theme and How to Win It You must also make certain you have installed WordPress. WordPress is an ideal option for hosting your online Resume, you are able to easily setup a website with WordPress and decide on the suitable Resume WordPress theme to suit your de mands and personality. WordPress is a perfect platform to create a professional on-line presence. WordPress is a superb tool to clearly show your resume to prospective customers and companies youre interested in working for. Together with a beautiful resume design module and various different elements, the Cascade WordPress theme is well worth testing out whether you need something easy and modern. If youre searching for exposure by means of your online resume, the Online CV WordPress theme is a very helpful tool. The Max CV theme package also has a complete set of blog post templates and ecommerce compatibility should you want to sell services and products from your private site. The theme is totally responsive and you may also customize it to the backend to integrate your individual brand. Up in Arms About Wordpress Resume Theme? Kemies website is the ideal presentation of her illustration abilities and her personality. In addition to the homepage designs, in addition, the re are templates for the blog and portfolio sections of your site. In addition to that, the theme is not difficult to translate to a different language and supports a responsive design. If youre looking for a flexible theme to construct your resume or portfolio site, then have a look at Ultra. The theme also has parallax features for grabbing the interest of possible employers. It includes a responsive, retina-ready design with the ability to import the demo content as well as numerous customization options. It is designed to look good on all devices and easy to configure. The WordPress theme can readily be become a blog without the resume features or you may use both to maximize your odds of being discovered online. The translation-ready files let you translate your site. Regrettably, its difficult to capture the complete experience, so I advise that you take a look at the demo if youre intrigued. The page backgrounds are simple to manipulate and Google Maps shortcode gu arantees that employers know where youre located. A one-page theme also makes it simple to create dedicated sections for every kind of information, like your biography, work history, and references. Its very quick to setup and simple to customize. The theme includes a minimal navigation menu pushed off to the left side that makes it feasible to concentrate on the primary content of your resume. Examine the box beside your resume and then click the add to menu button. It is possible to add numerous buttons. Theme setup is rather easy and hassle free. The plugin provides you with the instructions and the link you should create the API and find the appropriate keys. In the event you face any trouble, you could always reach out to us and well be happy to assist you with your queries. If you would like an exceptional theme with a lot of customization choices, look no further than BookCard WP. Wordpress Resume Theme Help The extra 3 widgets mean you have various alternatives to display your abilities and experience. Its flexible options make it possible for you to earn a stunning website with no coding skills. WordPress websites are an excellent means to showcase work that youve done and describe the type of work that you do. A terrific personal website will reveal your nature and your skills while still keeping a professional tone. The Wordpress Resume Theme Stories The themes homepage involves a region to enter a concise sentence about yourself and your contact info. Its possible to learn all about how to create a terrific personal resume website. The theme also supplies completely free lifetime update and has a choice to setup your site just enjoy the demo site utilizing the sample content provided. After you have selected the WordPress topic of your choice, hosting the site is the sole thing keeping you apart from your awesome online resume.

3 Things Your Recruiters Should Understand - Spark Hire

3 Things Your Recruiters Should Understand - Spark HireStaffing Talk lays it out clearly for staffing businesses on how to quickly turn off a business owner. There is nothing worseto a hiring manager or business owner than relying on a recruiter to deliver quality results, only to be faced with broken promises and poor quality.When you are hiring your team of recruiters, there are 3 things that you need to make sure they understand early on, in their training period. If one of your new recruiters doesnt seem to get it then you need to quickly send him packing because not only will he be unsuccessful, but he will taint your staffing companys reputation.1. Focus on building AND maintainingOne of the complaints Staffing Talk brings to your attention is the fact that many staffing businesses approach them as a sell it and forget it type of sale. This is a HUGE mistake in staffing and many other industries.When your recruiters are approaching existing and potential customers, they not onl y need to be focused on building their new business pipeline, but also focused on maintaining that existing pipeline. Selling for the long-term is what you want them to think about here. The first placement is the beginning of a relationship with each customer. This placement can lead to the second, third, fourth, fifth placement and so on.Stress to your recruiters the importance of good presentation as well as solid follow through. The better the relationship with each customer, the better the chance of follow-on business.Keep in mind ways that you can provide incentives to your recruiters to not only focus on bringing in new business, but also on maintaining existing business.2. Always communicateYour recruiters should always be accessible. If you have a recruiter who is letting customer calls or emails go by the wayside, its time for you to seriously consider next steps with that sales rep.Customers want to be heard. Its as simple as that. Recruiters need to have good, verbal con versations with your customers. Your recruiters need to be listening to customer concerns and needs, addressing how your company can best help where it hurts.Communication is a key skill in any recruiter, especially when in the staffing business.3. Be accommodatingUnderstand that your customers are just as busy as you are. However, in order to keep your customers satisfied it is necessary for your recruiters to be accommodating when it comes to scheduling calls and interviews.Consider various ways to accommodate your customers busy schedule. For example, face-to-face meetings are key with customers. If schedules do not align between you and your customer for a face-to-face meeting when you have traveled to their location, consider scheduling a video call instead. Not only will the video call still maintain lines of communication but it will also help to develop that personable relationship that a face-to-face meeting provides.Likewise, if your customer is unable to schedule an in-pe rson interview with a top candidate, consider suggesting a live video interview versus only a phone interview.By offering your customer more options, you are providing better customer service, letting your customer know that you want to work with them and accommodate to their needs.What are some other things that you make sure your recruiters understand when working with customers? Please share your tips in the comments below.bild alexraths/BigStock.com