Aura AI

Learn with Divya Batheja

Explore a wide range of courses tailored to your interests and goals.

Comprehensive Courses

Learn from industry professionals and experienced educators who are passionate about sharing their knowledge.

Expert Instructors

Engage in interactive lessons, discussions and activities that foster a dynamic and immersive learning environment.

Interactive Learning Experience

Access course materials anytime, anywhere and learn at your own pace to fit your busy schedule.

Flexible Learning Options

Gain practical skills and knowledge that can be directly applied in real-world scenarios, enhancing your professional growth.

Practical Skills Application

Join a vibrant community of learners, collaborate with peers and receive guidance from instructors throughout your learning journey.

Supportive Community

8 DAYS BASIC TO ADVANCED COURSE

Divya Batheja

Excelpert.in helps professionals and students master Excel through expert-led training, practical projects, automation techniques, and real-world analytics skills. Learn faster, work smarter, and turn spreadsheets into powerful decision tools with structured, hands on Excel learning.

Excelpert

<p><strong>LEARN 20 BASIC AND INTERESTING CONCEPTS IN EXCEL - In this class, you will learn the following&nbsp;</strong></p>

<ol>
	<li>Excel Interface - What does an Excel sheet consists of?</li>
	<li>How to add/remove rows and columns</li>
	<li>How to change colors, fonts, sizes etc</li>
	<li>How to add formulas - IF, COUNT, COUNTA, Average, MAX, MIN</li>
	<li>Different types of formats</li>
	<li>Round function</li>
	<li>How to freeze panes</li>
	<li>Paste special - Effective way of working in Excel</li>
	<li>Icon Sets</li>
	<li>How to remove duplicate values?</li>
	<li>Create Hyperlinks</li>
	<li>Use of upper, lower and proper function</li>
	<li>Using Excel as google</li>
	<li>Freeze and unfreeze panes</li>
	<li>Protect sheet</li>
	<li>Fast Scroll</li>
	<li>Pivot tables</li>
	<li>Aggregate function</li>
	<li>Date functions</li>
	<li>EDATE, NETWORK DAYS</li>
</ol>
