Course Description
The first version of MS Excel was released in 1985 and was widely adopted across the globe and became the most prolific and important programs for over 750 million users. Many people assume that Excel is only used by accountants, analysts, scientists and other similar professions that points to the fact that there is a real problem with the understanding of what in this book. Through this book we will explain why Excel is such an amazing program and why it can do so much more than you think.
Course Objective
Use Conditional Logic in a formulaIF statementsUse the SumIF and CountIF functionsProduce a chartSort and filterApply subtotalsData ValidationWhat-if-Analysis ToolsIntroduction to Pivot TablesIntroduction to MacrosAdvanced Image Processing Operations
Learning Outcomes
New to Excel 2016 or upgrading from a previous version? Use this guide to learn the basics and advance features of Excel. This user guide will introduce you to some of Excel’s 2016 more complex functionality
Skills You Will Gain
Excel
Course Content
- Overview of Excel 2016
- Cell References and Range
- Working with Formulas and Functions
- Data Validation
- Protection
- Sorting a Database
- Filtering a Database
- Subtotals
- Pivot Tables
- Conditional formatting
- What-if-Analysis Tools
- Working with Multiple Worksheets, Workbooks and Applications
- Working with Charts
- Macros
Partners
iTrack is not another Online Courses Platform or a content Distribution Platform or a new LMS, but the world's first eLearning Platform which understands the pain point of each stakeholder - College, Faculty, Student, and Industry (CFSI™) and brings them together to thrive in the NEW WORLD.
Certificate
Shareable on:
You can share your Course Certificates in the Certifications section of your LinkedIn profile,
on printed resumes, CVs, or other documents.
Instructors
From iTrack Partner
Frequently Asked Questions (FAQs)
Ncell Pathshala Courses Are Entirely On-Demand. You Need To Register On Ncell Pathshala From A Valid Ncell Number To Subscribe To Courses.
You Need Not Start Your Self-Paced Learning Course According To Any Schedules. You Can Learn At Your Comfort.
Ncell Pathshala Supports Airtime Balance Deduction From Your Registered Ncell Mobile Number. More Information On Ncell Pathshala Payment Methods Can Be Viewed On The Website.
Yes. You Will Receive A Course Completion Certificate To Document Your Accomplishment And Endorsements. The Certificate Will Be Provided On Passing The Assessment By The Partner Organisation. The Certificate Will Be Digitally Signed By The Authorities
24*7 Helpline Is Available For Your Support So That Your Learning Never Gets Hampered! Alternatively, You Can call at 9809005000 or can Share Your Query By Mail To Contact Us At Emailus@Ncell.Axiata.Com. You Can Expect A Response Within 48 Hours.
Reviews
No Reviews Found
