5 Design Tips for Better Excel Reports & Dashboards

in this video I'm going to share with,you five of my favorite design tips when,I create Excel reports and Excel,dashboards it's a part of my upcoming,online Excel dashboard course and I'm,going to put the link to it in the,descriptions below so make sure you,check it out to see if it's something,for you,designing dashboards involves making,decisions about what data to emphasize,which in turn depends on the message,that you want to communicate the,following design principles are going to,help you showcase the information as,clearly and directly as possible,number one is contrast contrast creates,emphasis so you may want to add a strong,contrast for headings to communicate,really fast the KPIs that are on display,in your dashboard for larger or longer,tables you could even use a subtle,contrast on the table rows as a visual,aid to help the reader connect the,numbers they see on the right-hand side,to the correct category labels they see,on the left hand side,number two is alignment alignments,connects different elements so use it to,show relationships so in this case the,change to previous year has been aligned,to a center line so either left of the,center line for decrease and right of,the line for increase so the viewer,should logically deduce that the center,line is previous year and left or right,reflects a negative or positive change,from previous year so using layout in,addition to color to communicate in this,case loss or gives makes this more,legible from a distance and also more,quantifiable for tables numbers in a,table should be right aligned in their,cells so you can immediately tell larger,or smaller numbers apart the general,convention is to align numbers to the,right and text to the left all the table,headers can be an exception it's really,based on your preference how you think,looks best in your table number three is,rapid,repetition encourages the brain to draw,parallels and create associations for,example abbreviations should be,standardized throughout the report color,usage should be standardized throughout,the report also the common visual,shorthand of a down red arrow and a,green up arrow is in this example,repeated in the table each time,positioned next to a minus percentage or,a plus percentage so using these icons,in addition to color eases the,readability from a distance so the,viewer can visually filter high,performing or low performing companies,before even going up close to examine,the details,number four is proximity proximity,organizes content,it creates focal points another way of,looking at proximity is grouping its,opposite is separation so this example,shows the metric percentage change the,previous year grouped with its visual,just a conditionally formatted bar chart,to imply that they are connected and the,whitespace separates this set from,another metric which is the percentage,change the budget and its visual for the,use of proximity helps clarity and it,also adds visual punctuation to what,would otherwise be

The above is a brief introduction to Better Reports

Let's move on to the first section of Better Reports

Better Police Reports: Professional Sentences

Better Police Reports: Professional Sentences

welcome to better police reports I'm,Jean Reynolds,today's topic is professional sentences,over the years I've heard many police,officers say they wish they had a more,extensive background in English grammar,usage well there's good news because,police reports are such a specialized,form of writing you can predict many of,the sentence and punctuation issues,you're going to run into that means you,can prepare for them and that should,build your confidence so today I'm going,to give you some concepts and strategies,for writing professional sentences and,punctuating them now if you're planning,to write say a Pulitzer Prize winning,novel you're going to need a more,extensive toolbox but think about this,police reports are supposed to be,efficient and straightforward that means,you don't want a lot of fancy sentence,patterns so everything I'm going to give,you today is quick practical and jargon,free let's get started I'd like you to,read this example and decide how to,punctuate it and it's not a trick,question well obviously you're going to,put a period at the end there's no need,to put a comma because this goes,straight from the beginning to the end,he ran into the wooded area across the,street now if I ask you why you put the,period there that seems like a very,simple question right it's a sentence,but how do you know it's a sentence and,this is where a lot of professional,writers including police officers,sometimes run into problems you've got a,group of words it got many groups of,words some are small some large how do,you know what you need a comma or a,period how do you know whether it's,really a sentence when I was in school,my teachers used to say to me that a,sentence was a group of words expressing,a complete thought well when I started,teaching I discovered that that,definition didn't,work very well in fact it confused my,students especially the idea of what is,complete for example somebody would say,we don't know who he is we don't know,what the street is yet its complete it's,a sentence so I began searching for a,definition that worked better and the,definition I came up with is also very,good for police reports and this is what,it is,a sentence is a group of words that,begin with a person place or thing the,minute you see that word he at the,beginning you know that you've got a,sentence that's going to end with a,period now in your Pulitzer Prize,winning novel this isn't going to work,for every variation that you use but,this works great for police reports,because think about this in a police,report you want to start most of your,sentences with a person plays your thing,in fact usually a person you're telling,what you did so it starts with I or what,another officer did or a victim or a,suspect or a witness when I started,working as an English teacher I used to,call these independent clauses and I,found that that confused my students as,well their sentences why not call them,that so hold on to that thought because,we're going to need it a

After seeing the first section, I believe you have a general understanding of Better Reports

Continue the next second section about Better Reports

Writing Better Police Reports: Building Your Brainpower

Writing Better Police Reports: Building Your Brainpower

better police reports building your,brain power,i'm gene reynolds,i wrote criminal justice report writing,i'm a trainer and consultant as well as,the author of 11 books i've helped many,cadets officers instructors and,administrators solve problems with,report writing,my background includes teaching english,in college classrooms,and studying language theory in graduate,school,i have two important messages for you,today one,you know more about writing than you,think you do,two,sharpening your writing skills is easier,than you might expect,let's talk about police reports,you already know that police reports are,important,they help solve crimes and prosecute,criminals,but perhaps you don't feel confident,about writing that's true of many cadets,so i'm going to talk about a resource,you might not have thought much about,your brain,your brain has 86 billion neurons,many of them are devoted to language,the language circuitry in your brain is,incredibly complex,and it's been developing since you were,born,what was the first language you learned,as a child,whether it was english or another,language,it shares a foundation with all other,languages,every language has a systematic,structure,a large storehouse of vocabulary words,the capability to express complex,information and ideas,now think about how you learn to speak,no one sat you down with a grammar,textbook you figured it out yourself,you listen to other people talk,and then you try doing the same thing,yourself,no matter what language you're using,your amazing brain efficiently deals,with intricate language structures all,the time,now that you understand the power of,those 86 billion neurons,you can see why your brain holds the key,to better writing,what many people don't realize is that,neurons can change,this picture represents ordinary neurons,and this picture shows the result of,learning,neurons pair up and connect to one,another,when you stimulate your brain,it responds by organizing neurons and,making new connections,the learning process can feel,uncomfortable even scary,while your neurons are on the move,but when your brain makes the,connections you feel great,how can you stimulate your brain,through active learning,something that happens all the time in,your academy training,practicing new skills stimulates the,neurons in your brain to organize,themselves and make connections,when you complete your academy training,you will have a better brain,it's just as important to know the kinds,of learning that don't build a better,brain,sitting quietly while someone else is,talking may not do much to stimulate,your brain,of course you can acquire a lot of,information from a speaker or teacher,but if your goal is a better brain you,also need to plan many active learning,projects,here's the good news,your report writing classes will include,many tasks designed to stimulate your,brain,you'll be talking with other students,performing a variety of writing tasks,reading,and using your thinking skills to tack

After seeing the second section, I believe you have a general understanding of Better Reports

Continue the next third section about Better Reports

Aldi Reports That Prices Of Thousand Of Grocery Items Will Double In 2023

Aldi Reports That Prices Of Thousand Of Grocery Items Will Double In 2023

all the customers have always been loyal,to the grocer due to its cheap prices,and unique product range however the,supermarket chain hasn't been able to,escape inflation at shortages in recent,months Shoppers have been furious at,Aldi for doubling the price of hundreds,of items with some of them noting that,larger competitors such as Walmart and,Kroger are selling Essentials at lower,prices than the discount retailer While,others say that the amount of money,they're saving at Aldi is not as great,as it used to be a flood of consumer,complaints detail unbelievable price,increases at stores in the past few,weeks but the company Executives warned,that the worst is yet to come given that,the chain will be forced to pass,exploding costs onto their customers,this year that's what we're going to,expose in this video but before moving,on WE kindly ask you to support our work,with a thumbs up and don't forget to,subscribe,after retail week exposed last week that,Aldi is Raising prices at a higher rate,compared to many other cruises,Executives were forced to admit the RPS,it would be ridiculous for me to sit,here and say that our prices aren't,going up of course they're going up,exclaimed all the International Group,managing director Niall O'Connor in fact,just days before the end of 2022 the,grocer announced that prices would,inevitably have to rise further due to,global inflation Refreshers revealing,that hundreds of products were about to,face increases of up to 50 percent a,spokesperson cited soaring manufacturing,and farming costs as well as The,Economic Consequences of the Ukraine,crisis and broken supply chains as the,main reasons driving that decision,since the beginning of the conflict in,Ukraine we're experiencing jumps in,purchase prices that we have not,experienced in this way before said,Florian schulerbeck during a press,release as a result Aldi customers will,see essential items getting,significantly more expensive in the,weeks and months ahead he added the,latest price hikes are affecting,Pharmacy items cleaning products baked,goods snacks Frozen fruits and,vegetables and several other product,categories milk and dairy are among the,items that have faced the fastest price,facts Yahoo reports in the past two,weeks milk prices have shot up by 20,percent at the supermarket chain fresh,food inflation hit its highest rate in a,decade at all these stores with items,like poultry and butter seeing some of,the largest increases due to Soaring,costs of animal feed a near-record,commodity prices the outlet muted,similarly the grocery shopping blog,simply grocery deals compared prices at,the grocery for the past 12 months and,it found that chicken prices at Aldi,Rose above the national average of 22,going up by 27.5 since January 2022. the,cost of 10 ounces of chicken breast,jumped from,1.79 to,2.29 a significant increase for those,who are on a limited budget meanwhile,shrimp went up by 25.6 percent while,ground beef soared by 28.21 ham prices,climbed

After seeing the third section, I believe you have a general understanding of Better Reports

Continue the next fourth section about Better Reports

IGCSE English as a second language 0510/0511 - Write better reports, reviews, or articles

IGCSE English as a second language 0510/0511 - Write better reports, reviews, or articles

please subscribe,like and share it really helps us out,and of course,if you have any questions comment below,and we will answer you as soon as we can,welcome to this video in our series on a,gcse esl exam preparation,in today's lesson we will be learning,about how to write a better article,report or review,if you haven't seen our previous videos,click on the card above,this video focuses on the new topic of,formal writing in the revised pattern of,examinations starting from 2019 in,cambridge igcse,english as a second language which needs,to be answered together with a few basic,rules related to formal register it,describes various features you should,include when you use the formal register,it also focuses on specific phrases and,expressions used for reporting,accurately,giving opinions and making,recommendations,also to put forward your views and,arguments as well,apart from friendly letters or emails,you need to produce either a report,a review or a school magazine article,which you need to complete in a formal,register,you should never forget that your,readers or audiences will be a group of,students or your teachers so you have to,present the facts and recommendations in,a formal or semi-formal tone depending,on the topics,formal language structure is the most,important part of your writing that you,need for making formal writing,an exam type question usually contains,function words,for example write a report giving,suggestions or recommendations an,opinion let's start with some language,tips,the best way to master the formal,language is to learn to use phrases,associated with language functions,for example it is high time that a,government increased the tax,some general tips for formal writing,1. when writing formally is appropriate,to include formal tone and register,2. you should not use the words and,phrases that belong to the friendly,register,three no slang words or phrases,four no humor because topics are serious,of nature or factual,five no personal style this type of,writing should be impersonal,six you should always keep your audience,in your mind,first off time picks or phrases try,using these,as soon as we reached there we arrived,at the site,once we all arrived the journey to the,site was tranquil and scenic,next phrases for introduction or what is,the purpose of this report,try using one of these the aim of this,report is to highlight what we learned,the report aims to highlight this report,purports to highlight,this report aims to investigate,this report aims to recommend the,purpose of this report is to highlight,this report aims to present what we,learned from the trip,this report highlights what we learned,now phrases for generalization try using,these phrases,significant number of students i love,the number of parents that,almost all students a vast majority of,students,a large number of teachers,moving on phrases for the positive side,try using these phrases,many students were captivated to see,students were amazed to lear

After seeing the fourth section, I believe you have a general understanding of Better Reports

Continue the next fifth section about Better Reports

The world’s best airport just got even better | CNBC Reports

The world’s best airport just got even better | CNBC Reports

Singapore’s Changi Airport has been ranked the world’s best for seven years in a row now.,But just because it’s at the top, doesn’t mean it’s staying comfortable.,It’s called Jewel, it’s a nearly $1.3 billion dollar project which connects,three of the four terminals at Singapore’s Changi Airport.,It aims to increase the number of passengers coming to Singapore for both visits and stopovers.,It’s even being dubbed a destination for the locals, too.,And maybe that’s not so crazy, considering it also boasts its own movie theater and grocery store.,But if you come to this airport for just a layover, well, you will need to clear immigration to enter this dome.,Unless...,Say you have a stopover at the airport, but you don’t want to go through immigration?,Well, this train allows you to hop onboard and go right through the Jewel,so you can experience it without actually getting off.,By riding on one of these trains, you can experience Jewel, without technically ever entering Singapore.,So what exactly is this place, which feels like an airport, a tourist attraction,,and a gigantic mall, all combined into one?,Jewel builds on Singapore’s goal of being a "City in a Garden.",Here are the three elements that make Jewel unique.,Number one, the HSBC Rain Vortex.,This is where the water originates, it goes down through this funnel which then creates the vortex.,The total length of the waterfall is more than 130 feet,,making it the largest indoor waterfall in the world.,Jewel is comprised of five floors above ground and five floors below ground.,I’m standing two floors below ground right now and this is actually the base of the waterfall,,which goes inside the glass. And the glass, you can even touch the glass.,The Shiseido Forest, which is sort of meant to feel like you’re going on an actual hike.,It spans across five levels and is nearly 100 feet from the bottom to the top.,There’s about 60,000 trees, plants and shrubs.,And there are actual signs that refer to it as a trail.,Many studies were conducted to ensure the plants and flowers,will survive the right temperature, humidity and sun exposure.,To build this forest they’ve imported trees from the U.S., China and Australia.,And if you walk up to the top of the forest, you get to what this area is known as, Canopy Park.,Don’t worry, you can also take the escalator.,Here, you can walk the entire perimeter of Jewel and see more views of the rain vortex,,along with inter-terminal airport trains passing by.,It’s also home to different gardens, activities and more restaurants.,Singapore’s Changi ranks number seven in the world in terms of international passenger volume.,But it wants to climb the ranks by increasing the number of people coming through the airport.,That’s one of the reasons for this endeavor.,Singapore’s spot on the map puts it within a 7-hour flight,of some of the world’s biggest populations, including China, India and Indonesia.,Construction of Jewel broke ground at the end of 2014, and it was fin

After seeing the fifth section, I believe you have a general understanding of Better Reports

Continue the next sixth section about Better Reports

Secrets to Better Status Reports - Project Management Training

Secrets to Better Status Reports - Project Management Training

today we're talking about secrets to,better status reports and I found the,best kept secret is to know your,audience think about it whether you're,presenting one-on-one or to a group,different people process data,differently so you want to present the,data and the status reports accordingly,some people like to view status reports,online so they can see data more,real-time some people like to print the,status reports physically so they can,write notes on them so maybe if you're,presenting to a group you can do things,like present the status reports on the,screen visually but also provide,handouts or printout so those who want,to take notes can also some people,prefer to receive the raw data and they,may be able to take that data and work,the numbers or even export that data,into other spreadsheets if they want to,manipulate or export that to incorporate,into other systems some people want to,see visuals or graphs so they can see,how data trends they may want to see,trending data that may be increasing or,decreasing or maybe stay stagnant that,those insights help them with the,project I also think the second secret,is software of course you can generate,reports manually but typically it takes,longer and it leaves room for error,and the worst thing that you want to be,doing is presenting status reports to,either your project team or your,stakeholders with arrows instead we can,use software some of the benefits of,software is it can save you a lot of,time and a lot of effort because think,about it that data is in the system and,most tools have a button for status,reports and you just click the button,and then you can take the reports and,you can format them and customize them,again for your audience if you're,presenting it to your team members you,can customize them at a different level,you want to present them more detailed,and for,for the project versus the stakeholders,you can customize those status reports,to show a more high-level maybe the,milestones and then you can also backup,and archive the status reports either,maybe you want to is some later date go,back and view those but also you can,back them up for other team members to,retrieve if they maybe missed your,meeting but also a big point is to,remember no matter how you present this,data and who you presented to you want,to tell a compelling story about the,status of your project if you need a,tool to help you generate better status,reports then sign up for our software,now at projectmanager.com

After seeing the sixth section, I believe you have a general understanding of Better Reports

Continue the next seventh section about Better Reports

Home Depot reports better-than-expected Q3 earnings

Home Depot reports better-than-expected Q3 earnings

but these numbers at least at first,blush look like the company is is able,that's up four points already to I don't,know do whatever it does the business,model works at Home Depot regardless it,seems like of the environment the,estimate was for 412 uh and the company,earned uh well above that there's the,number 424. uh the revenue number 38.9,billion for sales I believe that's also,above and then same store sales they had,forecasts three percent and in the U.S,it was up uh four and a half no yeah a,U.S same store sales yeah four and a,half and total same store sales up 4.3,now for fiscal year they still three see,just three percent so they beat,currently reaffirming guidance in in the,quarter and for the year and operating,margins a company still sees 15.4,percent so let's talk about Brian Nagel,he may be able to explain joining us now,senior research analysts at Oppenheimer,and that's what we always ask seven,percent mortgage rates uh it does a I,don't know just a bad sentiment a bad,feeling in housing does it ever affect,Home Depot people were worried it might,because there were some other companies,involved in that market differently but,Home Depot seems to just shake things,off and and just keep just keep rolling,right Brian Hey Joe good morning yeah,well look I think so I'm just digging,through this results now and I mean wait,I'm gonna uh they're very boring which,is actually quite good you know as you,laid out it's an easy it's an easy beat,from Home Depot and this is coming,despite all these concerns about housing,slow down the United States but look I,think it just shows how how well,positioned Home Depot is how well-run,this company is that the company,continues to put up these type of,numbers despite you know look there,clearly are some housing pressures out,there I think there's there's more,housing concerns within the market but,Home Depot is performing very well here,just,odd that in a we're not in a recession,hopefully but in a slowing economy or in,a recessionary environment why you would,think people might not choose to do,remodeling or Home Improvement so it,doesn't just have to be new home sales,or mortgage they may not take a loan,with rates higher may not have to do,that but it just seems like they would,get less aggressive about making,improvements and that has not been the,case yet Ryan or as you say they just,manage it so well,well look I think it's a very,interesting Dynamic right now,um so clearly you know if you look at,the housing debt housing turnovers slow,home sales are slower okay but that in,and of itself is actually a very small,piece of Home Depot's business Your Home,Depot really plays so to say it's in,more of the you know the fixing of,existing homes the enhancing the,existing homes and right now I think you,know again despite something a lot of,concerns out there I think the consumer,is actually in good shape so in a in a,way and Home Depot has mentioned this,I've talked a lot about to our clients I,think th

After seeing the seventh section, I believe you have a general understanding of Better Reports

Continue the next eighth section about Better Reports

The World Economic Forum Sends an Eerie Warning to Elon Musk | Direct Message | Rubin Report

The World Economic Forum Sends an Eerie Warning to Elon Musk | Direct Message | Rubin Report

strong bipartisan eye vote yield back,the balance of my time in which everyone,a happy healthy and safe New Year happy,holidays Merry Christmas Happy schwanza,Happy Hanukkah whatever it is you,celebrate be safe,ever it is you celebrate this is the,Reuben report I'm Dave Rubin we are,rolling into 2023 we're live streaming,on Rumble and YouTube and,ones uh,I hope you guys had a great schwanza I,didn't ask you the other day when I saw,you for the first time in the New Year,how was your schwanza hope your schwanza,was great people uh we are going to be,doing a Reuben report.locals.com,Community Q a it's a great cross-section,of questions for uh I would say the the,start of the year and and how we're,going to frame things going forward and,it's a little all over the place which,is just the way I like it but what I,wanted to start with today was a little,bit about the sort of conspiracy,craziness that we are all in right now,that a whole bunch of us kind of saw,things a certain way saw through some of,the lies but the lies just keep coming,and the more that the conspiracy,theorists the conspiracy theorists I,should say uh point to some stuff the,more that the machine tries to discredit,those people but at this point I think,it is fairly obvious to most of us that,there is some level full of coordinated,effort by global actors is this crazy,stuff,to put in some sort of government in,charge of everybody and that we won't,really have States we will just have,this one giant machine telling us what,to do oh and by the way we won't have,anything but we'll be happy so uh so,let's get right into it uh first up,here's a tweet from an account called,covid1984. they noted that on the world,economic Forum website they've removed,Twitter from their how to follow page,now that might seem like sort of nothing,to you like Zippity Doo Dah except that,have you heard of this world's richest,man this Elon Musk guy well he bought,Twitter in case you've been living under,a rock uh he bought Twitter a couple,months ago and he has been releasing,these Twitter files which have of course,shown us information about the,suppression of the hunter Biden laptop,story which has shown us suppression of,counter narratives when it came to covid,and other Free Speech related things so,the idea that the world World economic,Forum which is the organization that is,ushering in this globalist government or,whatever it is okay uh that they don't,want people going on Twitter anymore in,essence right they're saying Twitter is,not a trusted source of news or of,information except Twitter is where,reality seems to be online right now,that's sort of ironic I suppose in light,of the last couple years of Twitter but,that really is what it is and because,Elon Musk has come in and basically said,hey I am for free speech I don't really,like journalists I want people to be,able to spread their message and and,find out truth and all of those things,the world economic Forum ain't happy,with them uh but we

After seeing the eighth section, I believe you have a general understanding of Better Reports

Continue the next ninth section about Better Reports

Wells Fargo reports better-than-expected Q3 revenue

Wells Fargo reports better-than-expected Q3 revenue

let's get back to the banks JP Morgan,and Wells Fargo let's get more reaction,to those numbers Leslie picker joins us,now again rejoins us hi Leslie,Hey Joe well some merger activities,should serve uh at least JP Morgan,pretty well here because they did see,their Investment Banking Revenue drop,during the quarter as the entire,entirety of Wall Street essentially but,just to kind of dig in a little bit more,on Wells Fargo as I mentioned earlier,this has been the standout performer,this year obviously trading below book,but has been you know outperforming the,other large Banks and you can see their,Shares are up more than two percent this,morning part of the reason behind the,bullishness surrounding Wells Fargo is,its liquidity position its ability to,redistribute Capital to shareholders and,they say in the third quarter they,increase their common stock dividend by,20 and their cet1 ratio which is a,measure of Health in the bank was 10.3,percent that's 110 basis points above,their current regulatory minimum,including buffers so Capital levels,they say they'll be prepared for a wide,range of scenarios including a slowing,economy and Market volatility another,key play here is Wells Fargo is much,more of a pure play on the rising,interest rate environment so you can see,during the quarter net interest income,was of 36 from the year ago quarter,that's largely based on higher rates,higher loan balances now here's the,question on nii that a lot of analysts,and investors are asking is when you can,see that inflection point have rates,driven risen to a level that those,benefits will start to taper off a,little bit and you can see deposits down,there loans are up their provisioned for,credit losses in the third quarter and,2022 included about 385 million dollar,increase in the allowance for credit,losses reflecting loan growth and a less,favorable economic environment so you,start to see different elements of kind,of this nii trend that they've enjoyed,so much this year how is that shifting,as we start to reach a threshold that I,think many people didn't see possible,with regard to where the FED funds rates,will go will it be Beyond four percent,and if so how does that impact kind of,the nii the margins that these banks,have enjoyed all year,kind of like life Leslie they get the,you know if it were a nice yield curve,be great for them but then you got to,offset you know I guess you offset the,potential slowdown and credit losses,with the higher rates so it's uh,something wins out but today at least it,it didn't disappoint even after those,big gains so far didn't this point after,those big gains this the soccer saw,yesterday,and that tells you something too because,obviously with the big gains we saw,yesterday I thought it would take you,know,quite a big beat or quite a a lot of,um you know Improvement in order for,these stocks to to rally on their,earnings but you can see there they're,up pretty significantly on at least Top,Line beats for each of them and

Congratulation! You bave finally finished reading Better Reports and believe you bave enougb understending Better Reports

Come on and read the rest of the article!

I am a shopify merchant, I am opening several shopify stores. I use ppspy to find Shopify stores and track competitor stores. PPSPY really helped me a lot, I also subscribe to PPSPY's service, I hope more people can like PPSPY! — Ecomvy

Join PPSPY to find the shopify store & products

To make it happen in 3 seconds.

Sign Up
App rating
4.9
Shopify Store
2M+
Trusted Customers
1000+
No complicated
No difficulty
Free trial