(WITHOUT ANY CODING OR MS EXCEL KNOWLEDGE)
What You'll Learn in this Course
- Master digital marketing from basics to advanced skills.
- See how AI transforms marketing, influencing content and targeting.
- Learn practical website creation using WordPress and AI tools.
- Beginner to Advance Level
- 12 Month Access
- Over 40+ hours of lessons
- Certificate from Microsoft Certified Trainer
Course Fees ₹4899 Now Only in ₹489/-
Course Fees
₹4899
Now Only in ₹489/-
40+ Hrs
Duration
18
Modules
56+
Videos
5+
Live Project
Grab 6-in-1 Benefits
Worth INR 21,000/-
Course Modules
1.1 Advantages of using MS Excel & Various purpose to use Excel
1.2 Understanding of Workbook, Worksheet, columns, rows & Cells
1.3 Ribbon & Tabs
1.4 Quick access bar, Formula bar, Name bar, Status bar
1.5 Keyboard Shortcuts & Navigation while using large data
1.6 Different Use of Mouse
1.7 Insert Comment
2.1 Advantage of Converting data into tables
2.2 Structured formula
2.3 Use of Slicers
2.4 Dynamic Range
3.1 Absolute Reference
3.2 Relative Reference
3.3 Mixed Reference
3.4 3D Reference
4.1 Text to Column
4.2 Flash Fill
4.3 Auto Fill
5.1 In Ascending & Descending Order
5.2 Sort with Text, Numbers & Date
5.3 Sort with formatting (Cell, Color, Font Color)
5.4 In Multiple Order
5.5 In Custom Order
6.1 Applying Filters by text, numbers, or date on the Data
6.2 Advanced Filter: Setting up Criteria to Filter the data
6.3 Applying Complex Criteria
6.4 Clearing the existing criteria
6.5 Use Wildcard characters in Filter Criteria
7.1 Form multiple Sheets
7.2 Form multiple Files
7.3 Understanding Syntax, Intellisense, Suggestion box & optional argument
7.4 Basic Calculations & BODMAS Rule
7.5 Calculate Square, cube & Raise Number to Power
8.1 Simple If
8.2 Combination of If with OR, AND & NOT
8.3 Nested If Function
8.4 LEN, TRIM, LEFT, RIGHT, MID, FIND, SEARCH, CONCATENATE, UPPER, LOWER, PROPER
8.5 REPLACE, SUBSTITUTE, SEARCH, FIND
9.1 Date & Time Formula
9.2 COUNTIF, COUNTIFS, SUMIF, SUMIFS
10.1 Lookup Functions – VLOOKUP. HLOOKUP. LOOKUP
10.2 Disadvantage / Limitations of Vlookup
10.3 Reference Functions – MATCH INDEX
10.4 Simple XLookup
10.5 Exact Match
10.6 Approx Match
10.7 Nested XLookup
10.8 Case Sensitive Xlookup
10.9 Multiple Answer column Xlookup
10.10 Lookup Repeating Value (Using Filter)
11.1 Defining and Using Range Names
11.2 Using Named Ranges in Functions
12.1 By Numbers, Text Length, Date, List (dropdown)
12.2 Input Message and Error Message
12.3 Dependent Data Validation
12.4 Dynamic Dropdown range with Table
13.1 Spilled Ranges & use of #
13.2 Sort
13.3 Sort by
13.4 Unique
13.5 Filter
13.6 Sequence
13.7 Ifs
14.1 Applying Conditional Formatting
14.2 Applying Multiple Rule Sets
14.3 Creating Custom Rule Sets
14.4 Viewing and Managing Rules
14.5 Clearing Custom Rules
15.1 Displaying the Developer Tab
15.2 Review and Purpose of Macros
15.3 Where to Save Macros
15.4 Absolute and relative record
15.5 Running macros: Assigning to Quick Access Toolbar, shapes
15.6 Pictures and keyboard shortcuts
15.7 Macro recording with charts & sorting Data
15.8 Alter the recorded code
15.9 User-Defined Function (UDF)
15.10 Use prebuild VBA code
16.1 Creating Pivot Tables
16.2 Rearranging Pivot Table Data
16.3 Modifying Pivot Table calculations
16.4 Drill-Down
16.5 Filtering the Pivot data
16.6 Summarizing Values by Sum. Count. Average. Max. and Product
16.7 Show Values As % of Grand Total, % of Column Total, % of Row Total
16.8 Grouping Fields
16.9 Creating Calculated Column(s) in Pivot
16.10 Creating Calculated Item(s) in Pivot
16.11 Showing and Hiding the Grand Totals
16.12 Refreshing data in pivot table
16.13 Changing the scope of data source
17.1 Inserting and Using a Slicer
17.2 Renaming the Slicer
17.3 Changing Slicer Settings
17.4 Formatting a Slicer
17.5 Clearing the Slicer
18.1 Enable PowerPivot
18.2 Understand Import Data, Transform data, Data Model to create a report
18.3 Use Load, Load to & Transform Data
18.4 Use of Power query to record steps for all files from a folder
18.5 Add column, Update Column with Text, Numbers, & date
Who is this Course for?
This course is for anyone who wants to maximize their productivity while using Excel. You will be learning how to use 210+ Excel Formulas, Reports, and Visualization that will make you the best employee of your office.
- Students
- Operations & Admin
- Chartered Accountants & Finance Professionals
- Managers
- Sales Professionals
- Marketing Professionals
- Frequent Google Sheet Users
- Data Scientists
- Freelancers
- Frequent Excel User
- Data Analysts & Data Manager
- HR & Recruiters
- Logistics Industry
- Supply Chain Industry
- Frequent PPT Users
- IT Professionals & Software Engineers
- Business Professionals
Upon Successful Completion of the Course, You Will Receive Certification From KOED Learning Renowned Institution That Adds Substantial Credibility to Your Certificate and Strengthens Your Resume
What our Students say
Enrolling in Koed Learning has been a game-changer for my professional development. Their comprehensive courses in data analysis, visualization, deep learning, and advanced Python tools offer flexibility, real-time doubt-solving, and lifetime access. It's the perfect solution for a busy professional like me, and I highly recommend it to anyone looking to upgrade their skills.
It's fantastic to hear that the course provided you with a solid starting point in data science, even with minimal prior experience. While it may have lacked technical depth, its descriptive approach and well-presented videos, coupled with live one-on-one doubt-solving sessions and mentorship, made it a valuable learning experience.
It's wonderful to hear that you took the initiative to learn data science at your own pace with Koed Learning and that it has broadened your outlook on data and opened up new opportunities for you in the field. Switching to a high-paying job with the right skills is a great achievement. Congratulations on your career progress!
4.8 OUT OF 5
(700+ Verified Reviews)
Frequently Asked Questions
Once you have signed up then we will send you an email with a link to access our training dashboard, you can access all of our courses from this dashboard. All courses consist of video lessons that can be viewed on your device of choice and also to truly enhance your learning you will access lots of exercise files relevant to the lessons.
Great question, well frankly we make the best courses because all of our trainers have spent 10+ years using these skills in the real world! True knowledge is passed on from people who have been in the trenches, putting in long hours, solving real problems creatively. Our mission is to empower you with the very best of what works and more importantly, leave out what is unnecessary and thus a waste of your precious time.
Please write to us at info@abricacademy.com and our support team will get back to you as soon as possible.
If you have bought the course please go to the My Courses page and login with details received on email
Yes! It is a Certified Course.
No, there is no age limit. I understand that technology might scare some people especially if you are elder & more experienced, however, the course will cover tricks that you will easily be able to learn, master & use without really being a tech-expert or learning coding.
Automation is the best thing to happen to working professionals and you should be learning it no matter what your age is.
Please write to us at support@abricacademy.com & our awesome support team will get back to you as soon as possible to help you out.
The course is compatible with Microsoft 365 (previously known as Office 365) and Excel for Windows 2019, 2016, 2013, 2010. Also available: Excel for Mac.
Excel’s formula structure hasn’t changed since Excel 95, so the functions and formulas from the course can be used with almost any version of Excel. If you are using an older version than 2010, your interface will differ slightly.
Microsoft Excel is leading the market with over 750 million users worldwide
Excel is used by finance, sales, marketing, HR, and other departments
Deep Excel expertise is a much sought-after skill in any profession around the world
This online course is suitable for anyone who wants to learn Excel. No prior knowledge of Excel is required. Whether you are a business professional, student, teacher, freelancer, or solopreneur, these online Excel classes will help you take your Excel skills to the next level. Excel is the most used spreadsheet software across the globe, and is considered essential in many industries like administration, accounting, construction, real estate, sales and marketing to name a few.
Quick Link
Contact
- +91 8527626233
- info@abricacademy.com