large Function in Microsoft Excel

Please,also visit my facebook page to get content pertaining to Microsoft Excel.

https://www.facebook.com/Microsoft-Excel-from-beginner-to-AdvancedGet-expert-509461202868400

Please, get access to my Playlist videos:

https://www.youtube.com/channel/UCJ3RHchQG6SJlU5DxOLF3HA/playlists

Please visit my blog to get content about technology you always wanted.
https://wintechology.blogspot.com/search/label/Video?&max-results=8

Excel is a powerful spreadsheet and data analysis application, with many capabilities which will assist you organize and add up of the info and numbers in your life.Microsoft Excel is a powerful electronic spreadsheet program you'll use to automate accounting work, organize data, and perform a good sort of tasks. Excel is meant to perform calculations, analyze information, and visualize data in a spreadsheet. Also this application includes database and charting features.

A spreadsheet program is one among the staple applications that you simply should have in your computer. And once you talk about spreadsheet applications, the primary thing which will come to your mind is Microsoft Excel. For quite 30 years, this office suite from the software developing giant, Microsoft, has been setting the quality for what a spreadsheet app should be.


Who this course is for:

This course is designed for all levels IT and non-IT students.
A beginner user can easily understand the concept of Microsoft Excel
There is a valuable content for Everyone.
This course is perfect for those I T and non-IT students who want to accelerate their career in Microsoft Excel


What you'll learn:

After completing this course,students will be able to use Microsoft Office
2013/2016 professionally.
Students will be able to apply different formats to their data.
Students will be able to apply conditional formatting to make their data more
impressive and professional.
Students will be able to Create advanced calculations.
Students will be able to present their data in tabulated form.
Students will able to calculate long data entries within seconds using Pivot Table.
Students will able to analyze data using different charts formats.
Students will able to implement advanced functions to solve problems in Microsoft Excel Workbook.
Students will able to track records from long data entries using Filtering and
Advanced Filtering.
Students will able to Sort data professionally.
Students will able to Protect Active Excel Workbook and Create Password
Protected Microsoft Excel file.






About me

My Name is Zohaib Khan Babar.I am Computer Engineer.My star is Pisces.

CAREER SKILLS

Software’s

MS Office, Dia, Adobe Photoshop,MS Visio

Operating systems

MS Windows 8.1,10.MS Windows 2000,MS Windows Server 2003,2008.

I am Microsoft Technology Associate(MTA).I have served in telecommunication and oil companies as a
IT support.I have an experience regarding IT for the past 12 years.As everyone believes knowledge is power,I feel honor to deliver my knowledge to my dearest students. Pen is Mighter than sword.


My Certifications:

1) Organization Name: Microsoft

Certificate: Microsoft Advertising Certified Professional


2) Organization Name: Google

Certificate: Technical Support Fundamentals


3) Organization Name: IBM

Certificate: Introduction to Cyber Security Tools & Cyber Attacks


4) Organization Name: Google

Certificate: Operating Systems and You: Becoming a Power User


5) Organization Name: IBM

Certificate: Cybersecurity Roles, Processes & Operating System Security


6)Organization Name: Google

Certificate: System Administration and IT Infrastructure Services


7)Organization Name: Intel

Certificate: Intel® Network Academy - Network Transformation 102


8) Organization Name: Google

Certificate: The Bits and Bytes of Computer Networking


9) Organization Name: Cisco

Certificate: Data Communications and

Network Services


10) Organization Name: Ministry of Information Technology and Telecommunication

Certificate: WordPress


`11) Organization Name: IBM

Certificate: What is Data Science


12) Organization Name: UNICEF

Certificate: Web Accessibility Training


13 ) Organization Name: University of London

Certificate: Information Security: Context and Introduction


14) Organization Name: Microsoft

Certificate: Microsoft Technology Associate (MTA)


15) Organization Name: IBM

Certificate: IT Security: Defense against the digital dark arts


16) Institute Name: Peace Operations Training Institute, Williamsburg, Virginia,USA

Certificate: Implementation of the UN Security Council Resolutions on the Women, Peace, and Security Agenda in Asia and the Pacific


17) Institute Name: Peace Operations Training Institute, Williamsburg, Virginia,USA

Certificate: The Role of United Nations Police in Peace Operations