Sparklines

This video How to create a Sparkline in Excel - So Simple 2022 explains how to use Excel’s Sparklines feature Transcript How to create a Sparkline in Excel - So Simple 2022 This function allows you to create one-cell charts. This is only available in version 2010+. For example, if we want to show the trend in Cell F Six with regard what's the sales, we could highlight them and then go to the Insert tab. Spark Lines shows you the data range and the location is going to be. Then we can actually copy that down and that shows you got a trend. When you click back on it, you'll see again that you have the other designs where you can put a few other things, maybe change your column. But I find that the Line Sparkline works the best. Really good for seeing trends If you still need help, learning more about Excel'Sparklines contact [email protected] Have other questions not covered in this video? Let us know in the comments below. 0:00 Sparklines This function 0:06 allows you to create one cell charts. This is only available in version 2010+. For example, 0:11 if we want to show the trend in Cell F Six with regard what's the sales, we could highlight them 0:18 and then go to the Insert tab. Spark Lines shows you the data range and the location is going to 0:29 be. Then we can actually copy that down and that shows you got a trend. When you click back on it, 0:41 you'll see again that you have the other designs where you can put a few other things, maybe change 0:45 your column. But I find that the Line Spotlight works the best. Really good for seeing trends About Us: College Africa Group is a corporate training company dedicated to helping everyone to Discover their Potential. Learn more about College Africa Group at www.collegeafricagroup.com Not a College Africa Group customer? Learn how you can get training on Microsoft Office Suite and Excel Connect with College Africa Group https://www.collegeafricagroup.com https://www.facebook.com/CollegeAfrica/ https://www.linkedin.com/company/college-africa-group/ https://twitter.com/CollegeAfricaSA https://www.instagram.com/collegeafricagroup/ http://www.arnoldmuscat.co.za/ Subscribe https://www.youtube.com/channel/UCR1x5i6DoDLjiHkCqZVQO1Q?sub_confirmation=1 ● Find out about our current specials is available. Click here for more details https://collegeafricagroup.com/training-specials/ ● Sign up for the www.collegeafricagroup.com Newsletter! ● Read more about Excel tips & watch Excel Videos on the College Africa Group blog: https://collegeafricagroup.com/blog/ ● For additional help, reach out to our support team here: College Africa Group Support Team [email protected] MyPressrelease https://www.pressportal.co.za/business-and-economy/story/how-to-create-a-sparkline-in-excel---so-simple-2022.html
https://drive.google.com/file/d/1-QndWo-206FU_LEIljevExM5BeG2sXnt/view?usp=sharing

#1 How to protect cells in excel the EASY WAY 2022

Protect Cells

Transcript - #1 How to protect cells in excel without protecting sheet the EASY & BEST WAY 2022 A question that's often asked is how do we protect a certain range of sales in Excel? I'm going to try and illustrate that to you this morning. In this case, we want to protect column C so nobody can tamp info or enter any information. Click on column C, the complete column all the way down. Right click Format Cells. Go to the Protection tab and tick locked and press okay, go back and right click Format Sales and then tick locked. You have to do this step first. Then you go to Protect Sales and make sure that Select Lock cells and Select Unlock cells are selected and enter a password. Do not forget your password as you will not be able to reopen it. I've used the simple one called Test and okay, so let's go to cell number and you can see I can start entering numbers and I'm going now to you sell seat two. Try to enter something and it tells me please enter the password and that is how you do that. Arnold Muscat College, Africa. If you still need help, learning more about Cross Casting in Accounting & Excel contact [email protected] Have other questions not covered in this video? Let us know in the comments below. About Us: College Africa Group is a corporate training company dedicated to helping everyone to Discover their Potential. Learn more about College Africa Group at www.collegeafricagroup.com Not a College Africa Group customer?
https://drive.google.com/file/d/1jAIUMYxkDn7VkbTZsCmVQq1SYEhzRzss/view?usp=sharing

Cross Casting in Accounting & Excel in 2022

Cross Casting

Transcript - Cross Casting in Accounting & Excel in 2022 Avoid common calculation problems with simple, effective Cross Casting in Excel. Learn, Share and Discover your Potential Transcript Cross Casting in Accounting & Excel. We always assume that the value, for example, E 10 ten is correct, but we never ever really check it against the corresponding values. So, I always advocate that we should do a simple cross-check to ensure that we are in balance. I linked the one cell to the formula so we got the total there and then I do an auto sum directly underneath for the other values and subtracted two and they should be zero to prove that we are actually in balance. I will illustrate by mending one of the formulas in E four to show you that the values are definitely going to be out. And also illustrated, Microsoft puts a little green corner to illustrate that the formula is not the same as the one nearest to it. This is to try and help you. One reason why you should not edit formulas. If you still need help, learning more about Cross Casting in Accounting & Excel contact mailto:[email protected] Have other questions not covered in this video? Let us know in the comments below. If you still need help, learning more about Excel contact mailto:[email protected] Have other questions not covered in this video? Let us know in the comments below. About Us: College Africa Group is a corporate training company dedicated to helping everyone to Discover their Potential. Learn more about College Africa Group at www.collegeafricagroup.com
https://drive.google.com/file/d/16q7BFI3ZGTyQyVm0nKJSH8FmmknOpvUJ/view?usp=sharing

Awesome COUNTIF In Excel How Does It Work 2022

COUNTIF

Transcript - The Awesome COUNTIF In Excel How Does It Work 2022 This function allows you to count text and numbers if they meet a certain condition within the specified range. In this example, we're going to ask the COUNTIF Function to tell us how many times the word Apple appears in the range you start the formula, and because we're going to be looking for text the word apples, we have to put them in a double inverted commas “ “. Otherwise, the formula will not function. In the next example, we're going to ask CountIF to calculate how many times a product ends with es. In this case, we are going to use the star *, which is equivalent of a Joker and telling us we don't know what it starts with, but they're all finished with es. In this example, I did not put the double inverted commas to show to you that the formula will not function unless I have because we're putting text within a formula. We can also calculate formulas via the Function Wizard. When you click on the Function Wizard, you can go and look for your formula type in the account. If say go and there it will tell you what it's going to do and you can enter the formula this way. In this case, we're going to look at how often does the value 54 occur within that specified that range. It's already telling you it appears to us it's okay, and it inserts the formula into your spreadsheet. If you still need help, learning more about Excel contact mailto:[email protected] Have other questions not covered in this video? Let us know in the comments below. If you still need help, learnng more about Excel contact mailto:[email protected] Have other questions not covered in this video? Let us know in the comments below. About Us: College Africa Group is a corporate training company dedicated to helping everyone to Discover their Potential. Learn more about College Africa Group at www.collegeafricagroup.com Not a College Africa Group customer?
https://drive.google.com/file/d/1g7tZnmDDyZuJ50jHwOjcv7DxsQHqadXy/view?usp=sharing

How to copy and paste only visible cell in Excel 2022

Copy Visible Cells

Transcript - How to copy and paste only visible cell in Excel 2022 Copy visible sales only. Quite often we will use something like group, an outline to minimize the data that we want to see. But when you copy it and place it in somewhere else in a spreadsheet or another worksheet, it actually explodes again. So, what we do is we'll use group and outline here and we only want to see those cells, we highlight them and we're going to use the F five key, the function key F five, click on special visible cells only and okay. And you'll see now that it has some lines, ones there, click on copy, go somewhere and paste and it has not exploded the data. Very handy tool to use. If you still need help, learning more about Excel contact mailto:[email protected] Have other questions not covered in this video? Let us know in the comments below. About Us: College Africa Group is a corporate training company dedicated to helping everyone to Discover their Potential. Learn more about College Africa Group at www.collegeafricagroup.com Not a College Africa Group customer?
https://drive.google.com/file/d/1NVa9QFuHrHkboxZVUgSzCOV9Pgbew4G8/view?usp=sharing

Concatenate

Transcript - How to copy and paste only visible cell in Excel 2022 Copy visible sales only. Quite often we will use something like group, an outline to minimize the data that we want to see. But when you copy it and place it in somewhere else in a spreadsheet or another worksheet, it actually explodes again. So, what we do is we'll use group and outline here and we only want to see those cells, we highlight them and we're going to use the F five key, the function key F five, click on special visible cells only and okay. And you'll see now that it has some lines, ones there, click on copy, go somewhere and paste and it has not exploded the data. Very handy tool to use. If you still need help, learning more about Excel contact mailto:[email protected] Have other questions not covered in this video? Let us know in the comments below. About Us: College Africa Group is a corporate training company dedicated to helping everyone to Discover their Potential. Learn more about College Africa Group at www.collegeafricagroup.com Not a College Africa Group customer?
https://drive.google.com/file/d/1g7tZnmDDyZuJ50jHwOjcv7DxsQHqadXy/view?usp=sharing

Cross Casting in Accounting & Excel in 2022

COUNTIF

Transcript - How to copy and paste only visible cell in Excel 2022 Copy visible sales only. Quite often we will use something like group, an outline to minimize the data that we want to see. But when you copy it and place it in somewhere else in a spreadsheet or another worksheet, it actually explodes again. So, what we do is we'll use group and outline here and we only want to see those cells, we highlight them and we're going to use the F five key, the function key F five, click on special visible cells only and okay. And you'll see now that it has some lines, ones there, click on copy, go somewhere and paste and it has not exploded the data. Very handy tool to use. If you still need help, learning more about Excel contact mailto:[email protected] Have other questions not covered in this video? Let us know in the comments below. About Us: College Africa Group is a corporate training company dedicated to helping everyone to Discover their Potential. Learn more about College Africa Group at www.collegeafricagroup.com Not a College Africa Group customer?
https://drive.google.com/file/d/1g7tZnmDDyZuJ50jHwOjcv7DxsQHqadXy/view?usp=sharing

Cross Casting in Accounting & Excel in 2022

COUNTIF

Transcript - How to copy and paste only visible cell in Excel 2022 Copy visible sales only. Quite often we will use something like group, an outline to minimize the data that we want to see. But when you copy it and place it in somewhere else in a spreadsheet or another worksheet, it actually explodes again. So, what we do is we'll use group and outline here and we only want to see those cells, we highlight them and we're going to use the F five key, the function key F five, click on special visible cells only and okay. And you'll see now that it has some lines, ones there, click on copy, go somewhere and paste and it has not exploded the data. Very handy tool to use. If you still need help, learning more about Excel contact mailto:[email protected] Have other questions not covered in this video? Let us know in the comments below. About Us: College Africa Group is a corporate training company dedicated to helping everyone to Discover their Potential. Learn more about College Africa Group at www.collegeafricagroup.com Not a College Africa Group customer?
https://drive.google.com/file/d/1g7tZnmDDyZuJ50jHwOjcv7DxsQHqadXy/view?usp=sharing

What's new in Excel 2019 -MAGIC EXCEL

Microsoft © has made some big changes in Excel and College Africa is almost ready to offer our MAGIC EXCEL two-day course.

What’s new in Excel 2019 or Office 365 – Windows

Microsoft © has made some big changes in Excel and College Africa is almost ready to offer our MAGIC EXCEL two-day course. 

1 Changes in Excel’s calculation engine, which allows you to input one formula and get many results.

2 New functions known as Dynamic Array functions & used in SPILL ARRAYS.

3 Added new formulae in Excel 2019: CONCAT, IFS, MAXIFS, MINIFS, SWITCH, UNIQUE, FILTER, SORTBY, and TEXTJOIN!

4 XLOOKUP which is better than INDEX and MATCH or VLOOKUP. It’s a single function, unlike INDEX/MATCH, so it’s faster to type.

5 Exciting new Charts, Map Charts, Funnel and Stocks charts.

Goal Seek Function 2022

Share, Learn and Discover your Potential! Arnold Muscat, College Africa Group, Excel tips, Excel free videos

What’s new in Excel 2019 or Office 365 – Windows

Microsoft © has made some big changes in Excel and College Africa is almost ready to offer our MAGIC EXCEL two-day course. Remain relevant and up-to-date

Data Validation List creation

Arnold Muscat, College Africa Group, Excel tips, Excel free videos

Skip to content