Connect with us

How To

How to edit legend in Excel

Published

on

edit-elgend

Other than utilizing worked in outline formats, you can physically add or alter singular graph marks, for example, the diagram title or hub titles.

Change the Chart Title

The graph title frequently shows up over the outline and is utilized to depict the information that is being introduced. You can add a totally new diagram title or just change the content of a current one.

  1. Select the chart.
  2. Right-click the chart title.
  3. Click the Edit Text button.
  4. Enter the new chart title.
  5. Click anywhere outside the title area.

Now Add Axis Title

The pivot titles portray for watchers the classification of information that is being spoken to. Without them, it very well may be hard to precisely depict data.

  1. Select the chart
  2. Click the Chart Elements button. Hover the mouse over the label options in the list to preview them on your chart before making your selection.
  3. Select the Axis Titles check box. A text box is added for both the vertical and horizontal axes.
  4. Enter descriptive axis titles.
  5. Click outside the title area.

Based On Your Searches You Might Be Interested In: office.com/setup

Position the Chart Legend

Normally when a diagram is made, a legend is added consequently. The legend distinguishes what data is depicted in the outline’s plot territory.

  1. Select the chart
  2. Click the Chart Elements button.
  3. Click the Legend button.Be careful not to click the word “Legend” or it will turn it off, just hover over it until the list arrow appears.
  4. Select a position for the legend.

Be mindful so as not to tap “Legend” or it will turn it off, simply drift over it until the rundown bolt shows up.

Conclusion

This is how you will edit legend in Excel once you are done with Office Setup. Also, learn about locking a cell in Excel. If you have any feedback for us, please feel free to use the comment section.

Continue Reading
Comments

How To

Pinnacle Crypto Education Review – How Does It Work & Can You Really Make Money?

Published

on

By

Pinnacle Crypto Education is a relatively new initiative in the crypto sphere and it immediately caught my attention as it offers users the chance to win crypto prizes (from $500 to $50,000) for just learning about blockchain and crypto.

So, I did a bit of digging and decided to try out this platform to see if it is legit and to see exactly how it works.

What is Pinnacle Crypto Education?

As you can probably figure out from its name, Pinnacle Crypto Education is a platform which aims to attract more people to the blockchain and crypto industry.

Or, as they describe themselves: “Pinnacle Crypto Education is a Switzerland-based not-for-profit platform created with the sole purpose of improving Blockchain & Crypto education across the globe.”

They are based in Zug, Switzerland and they currently have a basic crypto course available on their website (they have said they will be adding more to it in due course.)

The site is free to join and it took me less than two minutes to register with the site and get started.

 I should stress that when you are registering, if you were referred by a friend or family member, it’s a good idea to put their username in the “referral” field as this will multiply yours and their chances of winning a crypto prize by three.

For every article you read on their site you are awarded a raffle ticket (or much more if you refer people, as I discuss later.) It is these raffle tickets which enable you to win a prize, as they are entered into their crypto prize giveaways every few days.

So, the more raffle tickets you earn, the greater your chances of winning a crypto prize are.

My Experience

I signed up with Pinnacle Crypto Education and immediately began completing their course. On average, I spent around 20 minutes a day accessing their lessons (you have to be on each lesson page for 30 seconds to win a raffle ticket, so in 20 minutes you can win 40 raffle tickets.)

I did this every day for almost a week, and I also referred 3 friends and family members. This meant that instead of earning one raffle per lesson, I was now earning 9 raffles per lesson (as the number of raffles you win is multiplied by 3 for each person you refer.)

You can read the same lesson as many times as you want per day, so even though their current course is quite short and basic, you can win as many raffle tickets as you want per day by repeating it.

On August 1 I received an email from their customer support saying that I had won a crypto prize worth $1,600. I replied with my ETH wallet address and I received around 0.64 ETH to my Binance account that same day.

Is It Really Free?

Yes, at no point was I asked to deposit money – you just need to make an account with your email and provide your crypto wallet address if you win.

In Conclusion

Obviously I think using Pinnacle Crypto Education has been worth it for me (around two hours of reading about crypto for $1,600 is definitely more than I earn at my day job!) and I will continue to access their platform to try to win more prizes (they said this is allowed on their website’s FAQs page.)

Do I think other people should join as well? If you’re willing to spend some time reading about crypto and can consistently do it every day for a while, then yes, because then you have a good chance of winning.

It’s also a good idea to refer friends and family, or even other people on the internet, so you have a much better chance of winning crypto on their site, as you earn more raffles per lesson this way.

Lastly, I want to say that it ultimately depends on luck, so not everyone is guaranteed to win a prize by joining Pinnacle Crypto Education, but as you don’t lose anything for trying (as their platform is free to use), I strongly recommend it.

Continue Reading

How To

5 Common Misconceptions About Writing

Published

on

writing

There are two main reasons why people write almost every day –  First, they love writing. And second, it is their job to do so. Most writers love their job.

Did you know that some people love writing but are driven away from being a writer due to the misconceptions attached to writing?

Misconceptions are common beliefs that contradict existing evidence. It is important to overcome misconceptions as it discourages people and prevents them from doing what they love the most. 

This post discusses some of the common misconceptions about writing. Do not let them hold you back from pursuing writing as a career.

#1. Writing is not a real job

Don’t you just hate it when people say that? Well, as long as you are getting paid to do the work, it is considered a job. However, many writers do not have it that easy.

The thing with writing is that people need to practice their craft to put forward their best work. Does it require hard work? Yes, but then again, what job doesn’t? Writing is a creative job and different from usual jobs.

In typical jobs, you get paid if you show up and get fired when you do not. Writing, on the other hand, is quite the opposite. You need to find the motivation from within to do it. And that is what makes it so beautiful. 

#2. Heartbreak is the best thing that can happen to a writer

Not only does it sound cruel but makes zero sense. Yes, the vulnerability of a broken heart will help a writer convey their emotions freely, but that can be done even without a broken heart. Good writers know how to bring forward their outstanding creativity. 

To write, the experiences do not necessarily have to be your own. You can take inspiration from the experiences of your close ones, your friends, family. Let’s say you have to write about being in love and you have never been in love. Maybe your friends have, so write from their experiences. That is what is going to make you an outstanding writer. 

#3. Writing is easy

A lot of people believe that writing is easy, all you need is a good vocabulary and a pen and paper. Well, here is a shocker: Writing is not at all easy. It takes hours of brainstorming, research, and planning. It can frustrate a person. 

Writing does come naturally to some people but others tend to struggle a fair bit. As a writer, you need to develop characters, voices, and images in your head. You need to have a vivid imagination and produce some magical, out-of-the-box content. 

However, writing is not too difficult either. All you need is a good amount of dedication and hard work. Just like any other work, writing requires commitment and effort. 

#4. Writing is nothing more than a hobby

A hobby is something that people enjoy doing in their free time. All writers know that writing is so much more than just a hobby. It does not just bring words to life but offers an opportunity to escape reality. Writing takes time, commitment, and constant days of endless effort. It can even be stressful and unpleasant at times.

#5. Writing well is a gift

It is often believed that good writers are born and not made. Well truth be told, writing is a skill that anybody can learn. Talent is indeed important to be an exceptional writer, but writing is a craft. And just like any other craft, it can be learned. There are many writing classes available that you can take up and learn the craft of writing. 

Check out our online writing classes by the legendary Ruskin Bond. In this unluclass, you will learn valuable lessons required to jumpstart your career in writing. Join this online writing course and unlock your true potential. Subscribe now! Visit our website for more information.

Also Read: How to learn to generate ideas for writing an essay?

Continue Reading

How To

The Most Common iPhone Repairs We See In Our Cell Phone Repair Store

Published

on

By

iPhone has been on people’s favorite list for a long time. Even after being one of the expensive phones, it is always making its way to people’s hands and minds. Though, as technology advances with time, the problem also keeps on increasing. Not only iPhone but many other smartphones also have regular repair issues which can come up not necessarily in all single mobile phones. However, even though iPhone is one of the most expensive smartphones it still can give you some issues and can increase your service or a pair of visits.

It necessarily doesn’t mean that each and every iPhone will arise with this problem or any other. It simply means that these are the common iPhone repair problems which any of the iPhones can come with and it is not a big thing to worry about as it can be solved with the repair visits and proper care if taken within time. After all, iPhones are also just another smartphones that can sometimes give up some problems just like any other smartphone, or technology of electronic device will.

  • Software issues

The iPhone offers one of the best-operating systems that are iOS. Though, it is still high-end technology and can come up with problems with time like any other smartphone or operating system. You cannot stop any internal or external problems from arising. There have been some software issues with certain iPhones which have been noticed over time. These issues mainly include applications that become unresponsive; the iPhone may get stuck on its Apple logo while switching on all while updating its software. It is also noticed that at certain times the iPhone screen goes blank white which probably makes it stuck for a while.

  • Screen damage or display issues

Screen damage or display issues are another set of reasons that might cause problems in an iPhone. These problems mainly include the breaking of the screen or getting see will be damaged because of internal or external activities. By internal activities, we simply mean if the iPhone is jailbroken or certain malfunctions are performed in the iPhone this can also lead to screen or display damages. By physical damage, we obviously mean that a slip of the hand can have a high chance of breaking the iPhone screen as it is one of the most delicate and exquisite displays.

  • Water/liquid damage

There have been problems with iPhones related to liquid or water damage. It is simply because some people can miss taking the features mentioned that the iPhone is water-resistant only in some of its models. Water-resistant models don’t mean that the iPhone is completely waterproof. Therefore, it can certainly cause high damage to the iPhone if the phone is exposed to a large quantity of water or any other kind of liquid. If your phone is exposed to liquid do not try to turn it on once it switches off on its own. You must definitely take it to our service center.

  • Lagging

The iPhone might start to lag just like any other phone. This is because there might be a lot of unwanted data or applications on your mobile phone and this might be reaching its level best that is maybe your iPhone is getting nearly to be its storage fully. In such cases, you can easily format some data that you do not wish to keep on your iPhone be it photos, videos, or even applications or other documents.

  • Charging port issues

Issues with charging ports are usually faced with other mobile phones too. It is certainly one of the major problems in the iPhone as the charging portal is always open and therefore is exposed to a lot of dirt, dust, and liquid. Also, pulling out the charging cord brutally can also damage the charging port. You must not try to clean the charging port on your own because you could end up damaging that area of your iPhone. You must always take your iPhone to regular service visits to take proper care of it.    

Looking to sell your old mobile phone? Get in touch today to find out more about our sell old phone.  

Continue Reading

How To

How to get 24-hours Insurance Quotes Online?

Published

on

Insurance Quotes Online

If you need insurance for a short period, buying a full time and long-term insurance plan is not a feasible looking option. These policies are costly too and can directly affect your budget. To save money for customers and provide them with a better opportunity, Temporary car insurance was introduced. 

With temporary car insurance, you can get coverage for your car when you need it. With life-changing every moment, we strive for flexibility in everything. And the flexibility offered by this insurance plan is fantastic and fascinating at the same time as you will be stress-free while driving your friends, family member’s, or rental car.

This insurance is specially designed to suit your budget and stop the wastage of money on unnecessary policies and plans. Let’s get an in-depth view of this policy.

Steps to get 24-hour Car Insurance Quotes?

Getting temporary car insurance is as easy as you can think. You can get your quotes online within minutes as you have to answer some questions. 

To get affordable temporary car insurance:

Provide details of your car

Car models are one of the essential factors in deciding the price of your car insurance plan. Also, give adequate details to your insurance agents such as your card number, car history, your driving history, and any unpaid fines. This will be the first step for you to get the quotes. 

Provide your driving details

With the help of your driving details, insurance companies will get to know your driving habits. If you have a good driving record, then you will get cheaper rates for your policy. Having multiple tickets and offences will hamper your premium rate, and you may have to pay more. So, drive safely to keep your policy rate down.

Compare the quotes

There will be hundreds of quotes in front of you, so, compare the quoted for better results. By comparing various sections, you will make sure you get the best insurance plan that can fulfil your requirements at a reasonable price. 

Lock your rate

Once you have decided on your 24 hour car insurance quotes; ask for your insurer agent and lock the favourable policy with him as he will confirm your insurance plan and will complete the remaining formalities to insure you’re your vehicle with temporary car insurance.

In what manner does temporary full coverage car insurance fulfil your needs?

Temporary car insurance will help you get your car insured for one day to 84 days. It is an alternative to an expensive long-term yearly insurance policy. If you use your vehicle for grocery shopping and perform errands, then this short-term insurance plan is best for you. 

Even if you own a luxurious car like Porsche, you can also get cheap Porsche car insurance for the short term and save money. The main reason to insure sports and luxury cars with short term insurance is that you scarcely use them and do not drive often. Instead of wasting money on a long-term insurance plan, use a short-term insurance plan and cover your car as per your usage. 

Looking for cheap car insurance quotes in the market is a daunting task. Well, not anymore! Get help from our experts at Alias Insurance. We will help you get the best insurance for your car and get you the best deal on your car insurance.   

Continue Reading

How To

The Interactive Guide to AWS Essentials: How to use it

Published

on

By

AWS Essentials

AWS Essentials has explicitly been designed for those who have no knowledge or experience with AWS. Using non-technical terms, simplified explanations of concepts, and introductory hands-on walkthroughs, this course teaches you all about the basics of AWS, from creating an account to using core AWS services. 

This course will educate you on the security measures AWS provides and fundamental concepts of AWS Identity and Access Management (IAM). It will help you understand AWS management tools like Auto Scaling, Elastic Load Balancing, and AWS Trusted Advisor. You will also learn about AWS foundational servers, including Amazon Elastic Cloud Compute (EC2), Virtual Private Cloud (VPC), and Simple Storage Service (S3). 

After completing this course, you will be able to use AWS database servers like Amazon DynamoDB and Amazon Relational Database (RDS). It will help you become proficient in identifying AWS services, allowing you to make well-informed decisions about IT solutions based on what your business requires. 

Since it is a beginner-level course, no prior AWS experience is required. However, it is recommended to have some basic knowledge of AWS concepts and a fundamental understanding of IT, storage, networking, and databases.

How to create an AWS account?

Before starting with AWS, the first step is to create an account. To do so, follow these steps:

  1. Open the Amazon Web Services home page. 
  2. Clicking on Sign in to the Console will give you two options – to sign in or create a new account. 
  3. Enter your account information and then click on Continue. Make sure the information you have entered is correct, especially your email address. 
  4. After filling in your credentials, you will be presented with two options: A personal account and a Professional account. Both of these accounts have the same features and functions. A Professional account is for your business, while a personal account is your private account. 
  5. Read and accept AWS Customer Agreement. 
  6. Click on Create an Account and Continue. 
  7. Next, you will need to enter valid credit card information. AWS is a free tier use offering, and you won’t be charged anything as long as you follow the free tier use guidelines.
  8. After clicking Continue, you have to go through an identity verification process. All you have to do is put in a security check code along with your phone number. 
  9. Next, choose one of the available support plans.
  10.  After choosing an appropriate support plan, the process of your account activation starts. 
  11.  Click on Complete Sign Up, and now you have full access to all AWS services.

Services and Tools

Identity and Access Management (IAM)

AWS Identity and Access Management (IAM) enables you to securely access control mechanisms for all of your AWS services and resources. With the help of IAM, you can create and manage AWS users and groups. It allows you to assign specific policies and permissions to specific users or groups. You can also set up multi-factor authentication for additional security. Some of its key features are:

  •  Authentication

AWS IAM allows you to create and manage identities like users, groups, and roles. An IAM user is an individual that interacts with your AWS resources or services either using the AWS CLI or from the AWS Console. 

An IAM group is a collection of users and the permissions assigned to them. Creating IAM groups is a suitable way of managing users by categorizing them according to their needs, job function, department, or other requirements.

An IAM role is an entity within AWS that defines a set of permissions the respective role can perform and what entities can assume the role. 

  • Authorization

IAM’s access management or authorization is made of two primary components: Policies and Permissions. 

Permissions allow you to carry out actions on AWS resources. They are assigned in the following two ways:

  • Identity-based: Directly attached to users, groups, and roles.
  • Resource-based: Attached to AWS resources like S3 Buckets, ECR Repositories, etc. 

A policy is a document consisting of a set of rules with one or more statements. There are two policies:

  • Managed Policies: These policies can be created or attached to multiple entities. AWS has various built-in policies that cover a variety of use cases. They can also be mixed and matched to give generalized access to users, groups, and roles. 
  • Inline Policies: These policies can be directly applied to IAM entities. These policies are used for a specific objective. 
  • Shared Access to AWS accounts

Most companies have more than one AWS account, and you need to delegate access between them. IAM allows you to do this without sharing your credentials. AWS has also recently launched ControlTower that simplifies multi-account configurations. 

       2.  Virtual Private Cloud (VPC)

Amazon Virtual Private Cloud (VPC) is a foundational AWS service in the compute and network AWS categories. VPC creates an isolated virtual network environment in the cloud for your AWS account. A VPC behaves like a conventional TCP/IP network that can be scaled based on your requirements. It defines your AWS resource needs such as IP addresses, subnets, routing, networking functionality, and security. 

Each Amazon account can host multiple VPCs. Since they are isolated from each other, you can duplicate private subnets among VPCs.

       3.  Simple Storage Device (S3)

Amazon Simple Storage Device (S3) is a high-speed, scalable, web-based cloud storage service. It is created to archive data and applications on Amazon Web Services. Amazon S3 can be used by all organizations, regardless of their size. Due to its availability, scalability, security, and performance ability, it is suitable for a variety of data storage use cases such as data archiving, disaster recovery, data storage, IoT devices, media hosting, mobile applications, application hosting, website hosting, running big data analytics tools on stored data, and software delivery. 

It provides 99.999999999% durability and supports multiple security and compliance certifications. You can also link S3 to other AWS security devices like CloudTrail, CloudWatch, and Macle. It comes in seven storage classics:

  • S3 Standard:

It is suitable for frequently accessed data that needs to be delivered with high throughput and low latency. It targets dynamic websites, content distribution, and big data workloads.

  • S3 Standard-IA:

It offers a low storage price for data that is not needed much but needs to be quickly accessible. S3 Standard-IA is used for backups, DR, and long-term data storage.

  • S3 Intelligent-Tiering:

It is suitable for data with access needs that keep changing. It further has four different access tiers: Infrequent Access, Frequent Access, Archive, and Deep Archive. 

  • S3 One Zone-IA:

This type of tier is suitable for data that is infrequently accessed without high resilience or availability needs. 

  • S3 Outposts:

It adds APIs to an on-premises AWS environment. It is used when performance needs call for data to satisfy specific data residency requirements.

  • S3 Glacier:

It is used only for archival storage because it takes a lot of time to access the data.

  • S3 Glacier Deep Archive:

It is the lowest-price option for S3 storage. It retains data that only needs to be accessed once or twice a year. 

       4.  Elastic Cloud Compute (EC2)

Amazon Elastic Cloud Compute (EC2) provides resizable compute capacity in the AWS cloud. It allows businesses to run applications on the public cloud. Using the EC2 web interface, you can easily create instances of virtual machines and configure the scaling capacity of instances. You can also build apps to automate scaling according to your needs and peak periods. Its key features are:

  • Secure

Amazon EC2 provides a secure and robust network of resources. You even have the power to control which instances remain private and which ones have internet exposure. 

  • Inexpensive

You only pay for the resources you use. It consists of multiple purchase plans such as on-demand instances, spot instances, reserved instances, and many more. You can choose any of these plans based on your requirement. EC2 offers hourly rates. 

  • Flexible Tools:

Amazon EC2 offers several tools for developers and network administrators to build failure resilient applications. You can also isolate yourself from common failure situations using these tools. 

  • Reliable: 

Amazon EC2 provides a highly reliable environment where you can replace instances. Service Level Agreement commitment is 99.9% for each Amazon EC2 region.

      5.   Amazon Relational Database Service (RDS)

Amazon Relational Database allows you to create, run, and manage relational databases in the cloud. This database functions with a relational model. The relational model is a technique of structuring information that uses tables with columns and rows. The top features of Amazon RDS are:

  • Availability:

Amazon Relational Database Service allows you to access data anytime, anywhere. It provides high availability through a feature called Multi-AZ deployment. It maintains a redundant copy of your data in a different location. 

  • Scalability:

It offers two different types of automatic scaling: Horizontal (adding more machines) and Vertical (adding more resources). It has a load balancer that can distribute requests even when the database is under increased demand. You can also add RDS instances to an instance class that can scale them simultaneously. 

  • Performance:

Amazon RDS consists of a Performance Insights dashboard that allows you to analyze and troubleshoot the performance of your relational databases. It enables you to form metrics to get a clearer view of your business. The system provides two different types of storage: General Purpose SSD Storage and Provisioned IOPS Storage. 

  • Price:

You only have to pay for what you need. It comes without any minimum fee. If you want to test out the service, you can use the free tier, which offers 750 hours of use with 20 GB of storage. 

      6.   Auto Scaling

It is defined as a cloud computing technique that dynamically assigns computational resources—providing you with recommendations that help you optimize, your performance, costs, or balance between them. It simplifies scaling. 

AWS Auto Scaling helps you build plans that automate how groups of different resources respond to changes. AWS Auto Scaling monitors your applications to ensure that they are operating at your desired performance levels. It is free to use and allows you to optimize the costs of your AWS environment.

      7.   Route 53 (Domains and DNS)

Amazon Route 53 is a highly scalable and reliable Domain Name System (DNS) web service. It connects the internet traffic to suitable servers hosting the requested web application. In addition, it contains information about the mapping of IP addresses to domain names. Following are the key features of Route 53:

  • Resolver:

Route 53 can perform DNS resolution between local networks and VPC. It supports both IPv6 and IPv4 formats. 

  • Health checks, Monitoring, and Failover:

Route 53 directs internet traffic to healthy target instances as per the specified configurations. In case of an outage, the traffic will be routed to healthy endpoints by health-checking agents. 

  • Domain Registration:

The DNS management service allows you to transfer management of existing domains or register new ones to Route 53. 

  • S3 and CloudFront Zone Apex:

Zone apex allows you to return requests for the root domain without suffering any performance penalty.

  • Can be used with other AWS services:

Route 53 lets you map domain names to your Amazon S3 buckets, Amazon EC2 instances, and other AWS resources.  

    8.     Simple Notification Service:

Simple notification service (SNS) is a highly scalable, cost-effective, and flexible web service that makes it easy to set up, operate, and send a notification from the cloud. Amazon SNS enables you to group multiple users using topics. The topic, here, is an access point that sends duplicate copies of the same message to the users. There are two clients of SNS:

  • Subscribers:

Web servers, email addresses, SQS queues, and AWS Lambda functions act as subscribers. They receive the notification or message from SNS over one of the supported protocols.

  • Producers:

Also known as Publishers, they generate and send the message to the SNS which is a logical access point. 

Whether you are a developer, an architect, or a technical project manager, the AWS essentials course is the right place to start. This course will reinforce your learning with real-world scenarios and hands-on activities using a live environment. Earning an AWS certification offers lucrative advantages. It helps you advance your expertise, build credibility and confidence. Once AWS certified, you will be able to claim benefits at aws. 

Continue Reading

Trending