Tag: excel formulas

Microsoft Excel Tutorial for Beginners | Excel Training | Excel Formulas and Functions | Edureka

🔥 Advanced MS Excel Certification Training: https://www.edureka.co/advanced-ms-excel-self-paced
This Edureka video is a complete guide to Microsoft Excel which covers in-depth knowledge about different excel formulas, conditional formatting, Lookup, macros & VBA in Ms Excel.

1:08 Excel Functions
1:08 SUM Function
3:58 SUMIF Function
13:27 COUNT Function
17:27 COUNTIF Function
19:37 COUNTIFS Function
22:22 AVERAGE Function
27:17 ROUND Function
31:52 CONCATENATE Function
37:17 INDEX Function
40:02 OFFSET Function
44:57 MATCH Function
51:07 MAX Function
51:12 TRIM Function
53:57 LEN Function
55:07 SQRT Function
56:12 IF Function
1:07:42 AND Function
1:12:32 TODAY Function
1:13:17 Quick Access Bar
1:18:37 Conditional Fomatting
1:37:58 Color Scale
1:38:33 Using Formulas for Conditional Formatting
1:47:48 Logical Excel Functions
1:57:58 IFERROR Function
2:00:43 IFNA Function
2:03:41 NESTED IF Function
1:11:46 TEXT Functions
2:11:56 LOWER Function
2:13:16 UPPER Function
2:16:46 RANDBETWEEN Function
2:17:31 NAME RANGEs IN Excel
2:20:11 Lookup Functions
2:20:26 VLOOKUP Function
2:22:51 HLOOKUP Function
2:23:56 Formula Auditing
2:24:01Trace Precedents & Dependents
2:25:26 Error Checking
2:26:46 Show Formulas
2:27:16 Text To Column
2:29:51 Data Validation
2:40:16 What-if Tools
2:49:42 Scenario Manager
2:54:27 Data Table
2:56:17 SORT
2:56:27 Filter
3:00:02 WRAP Text
3:01:22 Merge Cell
3:01:27 Insert Comments
3:11:52 Large Function
3:23:32 Charts In Excel
3:41:12 Pie Charts In Excel
3:41:32 Pivot Tables
3:58:38 Slicers In Pivot Tables
3:56:18 Data Analysis Using Excel
4:02:09 VBA & Macros
4:15:19 Assign A Macros
4:15:24 Record A Macros
4:15:29 Debugging

Subscribe to our channel to get video updates. Hit the subscribe button above: https://goo.gl/6ohpTV

Instagram: https://www.instagram.com/edureka_learning
Facebook: https://www.facebook.com/edurekaIN/
Twitter: https://twitter.com/edurekain
LinkedIn: https://www.linkedin.com/company/edureka
Castbox – https://castbox.fm/networks/505

– – – – – – – – – – – – – – – – –

#edureka #exceledureka #excelTutorial #excelTutorialForBeginners #excel #excelCompleteCourse

For more information, Please write back to us at sales@edureka.co or call us at IND: 9606058406 / US: 18338555775 (toll-free).

Excel Tutorial: Learn Excel in 30 Minutes – Just Right for your New Job Application

Learn how to use Excel in exactly 30 minutes starting with the very basics (for the complete beginner) and then move to more intermediate features such as charts, mail merges and reports. For more info. and to learn more visit http://learn.kaceli.com.

I have designed it to be a resource for anyone starting to learn Excel or is applying for a job and wants to know how to use Excel and enhance their resume with Excel skills. The tutorial is based on Excel 2016 and all features also work in Excel 2013, Excel 2010 and 2007.

If you like the video, please “Like,” “Favorite,” and “Share” it with our friends to show your support on this work. Subscribe to this channel so that you do not miss out on the new videos on this series.

The full Excel 2016 Tutorial is available from here: https://www.youtube.com/watch?v=8lXer….

In more detail, as you can see below, it includes everything you would need to know to sharpen your skills for a new job application.

Data File if you need to follow the tutorial hands-on: https://kaceli.com/a/excel-2016-data-file/

Learn concepts related to Excel spreadsheets such as cells and references and formulas.
Learn how to enter formulas in Excel including, SUM, AVERAGE, MAX, MIN etc.
Learn about other mathematical calculations in Excel.
Learn how to sort and filter data in Excel.
Learn how to create charts in Excel.
Learn how to change the page layout and create headers and footers and change the margins including setting the printing area.
Learn how to use conditional formatting and other formatting features in Excel.
Learn how to do cross-sheet calculations in Excel.
Learn how to even perform mail merges in Excel
Learn how to link a spreadsheet with Word for reports.
Learn how to email an Excel spreadsheet and even save it as a PDF.

Excel in 30 minutes URL: https://youtu.be/7RCdzTpKO0A

Keep in touch:
Website: http://kaceli.com
YouTube Channel: http://youtube.com/skaceli
If you want to take get a deeper understanding of Microsoft Office applications, take a look at http://learn.kaceli.com

**Copyright notice: These videos may not be downloaded or distributed in any way without permission from Sali Kaceli. Contact me if you have such a need.