Monday, October 28, 2019

Basic Excel Formulas And Functions - Microsoft Excel tutorial for Beginners

In this lesson you will learn about the top basic excel formulas and functions.  The basic Excel formulas is critical for beginners to become highly proficient in financial analysis. Microsoft Excel is considered the industry standard piece of software in data analysis. Microsoft’s spreadsheet program also happens to be one of the most preferred software by investment bankers and financial analysts in data processing, financial modeling, and presentation. This guide will provide an overview and list of basic Excel functions.
You have 2 ways to do calculation in Excel:
1. Formulas
In Microsoft Excel, a formula is an expression that show values in a range of cells or a cell. For example, =B1+B2+B3, which finds the sum of the range of values from cell B1 to cell B3.
2. Functions
Functions are predefined formulas in Excel. For example: =SUM(B1:B3). This function will sums all the values from B1 to B3. Each strategy comes with its own advantages. Therefore, before go to the main formulas and functions we’ll make clear all methods, so you can create your preferred workflow earlier on.

Saturday, October 26, 2019

Tutorial help you how to speak excel on cell on enter

in this video I will teach you how to speak excel on enter. This is very detail  step by step. Enable Speak Cells in Excel Under the “Choose commands from” dropdown choose “All Commands” then choose the Speak Cells commands.  This feature will help you save your time. 

First you need to enable this feature.
Then select the cells that you want Excel to convert to speech and click on the Speak Cells button. Make sure you have the headphones/speaker plugged it.
Excel tries it’s best to pronounce the text you enter. If you enter numbers, it will read out the numbers. If you enter random text which is not a word, it will read out the alphabets, but if it is something which is a word, it will pronounce it.


Friday, October 25, 2019

How to make a chart in Ms Excel - Excel tutorial

If you want to make a chart, you can search how to do this on internet. But I will recommend you the easy way to do this. 
You need open the Ms Excel first. Then follow this step in below:

  1. Highlight the data for which you want to create a chart.
  2. Go to INSERT menu > Recommended Charts.
  3. On the Recommended Charts tab, scroll through the list of charts that Excel recommends for your data, and click any chart to see how your data will look. ...
  4. When you find the chart you like, click it > OK.

to make a chart very easy, just select the data you want in the chart and press ALT + F1 to create a chart immediately.



Thursday, October 24, 2019

Saturday, October 19, 2019

How to Use Ms Excel Tutorial For Beginners 2019

You want to learn Excel quickly?. If you are interested in learning Microsoft Excel, I've put together the  best tutorials to make it easy to become an expert. Microsoft Excel is a commercial spreadsheet application, written and distributed by Microsoft for Microsoft Windows and Mac OS X.  Excel is the most powerful tool to manage and analyze various types of Data. Click link below to see this video


Wednesday, October 9, 2019

Tutorial about how to use Quick access toolbar in Ms Word 2019


In this lesson, we learn about how to use Quick access toolbar in Ms Word 2019. 
As you know that in Microsoft Word, quick access tool bar is a customize toolbar that contains a set of commands that are independent of the tab on the ribbon that is currently displayed. You can move the Quick Access Toolbar from one of the two possible locations, and you can add buttons that represent commands to the Quick Access Toolbar.
See this video below for how to use this function. 
And more in my channel also have more video about how to use Ms word, word tutorials for beginners. 

Sunday, October 6, 2019

Top 10 Best Video Editing Software

This list choices for beginners and experienced video editors alike. These tools make cutting, editing and perfecting really simple. This is include software to create and edit video for free and paid. We hope that after see this video with the criteria you'll need to consider when choose  the best video editing software for your needs.

Adobe Premiere Pro CC: The best video editing software for Windows
Final Cut Pro X: The best video editor you can get for your Mac
Adobe Premiere Elements 2019
Adobe Premiere Rush
KineMaster
Corel VideoStudio Ultimate 2019
Filmora9
CyberLink PowerDirector 17 Ultra
Pinnacle Studio 22
DaVinci Resolve