FEE: Rs 1500 Inclusive GST

𝐑𝐞𝐬𝐨𝐮𝐫𝐜𝐞 𝐏𝐞𝐫𝐬𝐨𝐧:
𝐃𝐫 GIRISH S R


𝐎𝐫𝐠𝐚𝐧𝐢𝐬𝐞𝐝 𝐛𝐲

𝐍𝐨𝐝𝐚𝐥 𝐎𝐟𝐟𝐢𝐜𝐞,
𝐂𝐇𝐑𝐈𝐒𝐓 ( 𝐃𝐄𝐄𝐌𝐄𝐃 𝐓𝐎 𝐁𝐄 𝐔𝐍𝐈𝐕𝐄𝐑𝐒𝐈𝐓𝐘)
𝐀.𝐈.𝐑 𝐑𝐨𝐚𝐝, 𝐕𝐚𝐳𝐡𝐮𝐭𝐡𝐚𝐤𝐤𝐚𝐝𝐮
𝐓𝐫𝐢𝐯𝐚𝐧𝐝𝐫𝐮𝐦,𝐤𝐞𝐫𝐚𝐥𝐚
𝐭𝐯𝐦@𝐜𝐡𝐫𝐢𝐬𝐭𝐮𝐧𝐢𝐯𝐞𝐫𝐬𝐢𝐭𝐲.𝐢𝐧

𝙊𝙑𝙀𝙍𝙑𝙄𝙀𝙒
Microsoft Excel is the industry, education, reporting, computation leading spreadsheet program, used by millions of people all over the world. Excel and other spreadsheet tools are great for data manipulation, analysis, and visualization – you can sort, filter, format, and chart your data all within one program.

𝙂𝙊𝘼𝙇
. All participants will go through the basics and deep dive of the most popular spreadsheet tool on the market, Microsoft Excel.

𝗧𝗼𝘁𝗮𝗹 𝗡𝘂𝗺𝗯𝗲𝗿 𝗼𝗳 𝗵𝗼𝘂𝗿𝘀: 𝟭𝟬 𝗛𝗼𝘂𝗿𝘀
𝗡𝘂𝗺𝗯𝗲𝗿 𝗼𝗳 𝘀𝗲𝘀𝘀𝗶𝗼𝗻𝘀: 𝟱 𝗱𝗮𝘆𝘀 (𝟮 𝗵𝗼𝘂𝗿𝘀 𝗲𝗮𝗰𝗵)

𝗘𝗮𝗰𝗵 𝘀𝗲𝘀𝘀𝗶𝗼𝗻 𝗯𝗿𝗲𝗮𝗸𝘂𝗽/𝗰𝗼𝗻𝘁𝗲𝗻𝘁:

𝙎𝙚𝙨𝙨𝙞𝙤𝙣 𝙊𝙣𝙚: Excel Pivot Tables

Understanding Pivot tables, creating and modifying pivot tables, grouping and formatting the pivot data, modifying pivot data, drilldown pivot data, creating pivot charts, filtering and slicer tool.


𝙎𝙚𝙨𝙨𝙞𝙤𝙣 𝙏𝙬𝙤: Working with Power Pivot tools

Introduction to Excel Power Pivot, Why PowerPivot?, Activating the Excel PowerPivot AddIn, Creating Data Models with PowerPivot, Excel Power Pivot Data Model Relationships, Creating Pivot Tables based on Data Models, Excel Power Pivot KPIs Working with Large set of data, Using the Freeze Panes Tool, Grouping Data (Columns and/or Rows), Print Options for Large Sets of Data, Linking Worksheets (3D Formulas), Consolidating Data from Multiple Worksheets


𝙎𝙚𝙨𝙨𝙞𝙤𝙣 𝙏𝙝𝙧𝙚𝙚: Working with Conditional Functions

Working with Excel Name Ranges, Advantages and Disadvantages of Excel Name Ranges, Editing an Excel Name Range, Using Excel's IF() Function Excel's IF() Function with a Name Range, Nesting Functions with Excel, Nesting Excels AND() Function within the IF() Function, Using Excel's COUNTIF() Function, Using Excel's
SUMIF() Function, Using Excel's IFERROR() Function. Working with Basic Text Funtions Using Excel's LEFT(), RIGHT() and MID() Functions, Using Excel's LEN() Function, Using Excel's SEARCH() Function, Using Excel's CONCATENATE() Function

𝙎𝙚𝙨𝙨𝙞𝙤𝙣 𝙁𝙤𝙪𝙧: Graphical Representation, Shapes, and Alignments

Auditing an Excel Sheet
Tracing Precedents in Excel Formulas, Tracing Dependents in Excel Formulas, Working with the Watch Window, Showing Formulas.

Protecting Excel Worksheet and workbook
Protecting Specific Cells in a Worksheet, Protecting the Structure of a Workbook, Adding a Workbook Password.

Mastering the excel's Whatif
Working with Excel's Goal Seek Tool, Working with Excel's Solver Tool, Building Effective Data Tables in Excel, Creating Scenarios in Excel


𝙎𝙚𝙨𝙨𝙞𝙤𝙣 𝙁𝙞𝙫𝙚: Doubts, Tips and Tricks

Quiz 5: Session Five Quiz


𝐑𝐞𝐬𝐨𝐮𝐫𝐜𝐞𝐬 𝐰𝐢𝐥𝐥 𝐛𝐞 𝐬𝐡𝐚𝐫𝐞𝐝 𝐰𝐢𝐭𝐡 𝐩𝐚𝐫𝐭𝐢𝐜𝐢𝐩𝐚𝐧𝐭𝐬: 𝐏𝐏𝐓’𝐬, 𝐒𝐨𝐟𝐭 𝐜𝐨𝐩𝐲 𝐏𝐫𝐚𝐜𝐭𝐢𝐜𝐞 𝐌𝐚𝐭𝐞𝐫𝐢𝐚𝐥𝐬.


Are there any course requirements or prerequisites?

● Basic Excel Knowledge Required
● Microsoft Excel 2007, 2010, 2013, 2013, 2019 or Microsoft 365 Excel Loaded on Computer to Follow Along with Instructor Lectures is Recommended

What's is the takeaway for participants:

At the completion of this course, you will have mastered the most popular Excel tools
and come out with the confidence to complete any Excel tasks with efficiency and grace. You can start implementing it in your regular work environment. Below are just a few of the topics that you will master:

● Build a solid understanding on the Basics of Microsoft Excel
● Learn the most common Excel functions used in the Office
● Harness the full power of Microsoft Excel by automating your day to day tasks
through Macros and VBA
● Maintain large sets of Excel data in a list or table
● Create dynamic reports by mastering one of the most popular tools, PivotTables
● Wow your boss by unlocking dynamic

● This Microsoft Excel course is for professionals in domains (Educational, Business, Students, accountants, and list goes on ).
● If you're looking to optimize your working style and make yourself stand apart from the crowd, accomplish all the requests in the spur of the movement then take this course.

● Start your baby steps to excel in the MS Excel basics.