𝐖𝐡𝐨 𝐬𝐡𝐨𝐮𝐥𝐝 𝐚𝐭𝐭𝐞𝐧𝐝?
𝐒𝐭𝐮𝐝𝐞𝐧𝐭𝐬, 𝐑𝐞𝐬𝐞𝐚𝐫𝐜𝐡 𝐒𝐜𝐡𝐨𝐥𝐚𝐫𝐬, 𝐓𝐞𝐚𝐜𝐡𝐞𝐫𝐬 𝐚𝐧𝐝 𝐑𝐞𝐬𝐞𝐚𝐫𝐜𝐡𝐞𝐫𝐬


𝐋𝐚𝐧𝐠𝐮𝐚𝐠𝐞 𝐨𝐟 𝐈𝐧𝐬𝐭𝐫𝐮𝐜𝐭𝐢𝐨𝐧: 𝐄𝐧𝐠𝐥𝐢𝐬𝐡
𝐃𝐮𝐫𝐚𝐭𝐢𝐨𝐧: 𝟏𝟎 𝐇𝐨𝐮𝐫𝐬
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.

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

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

𝙎𝙚𝙨𝙨𝙞𝙤𝙣 𝙊𝙣𝙚: 𝙈𝙞𝙘𝙧𝙤𝙨𝙤𝙛𝙩 𝙀𝙭𝙘𝙚𝙡 𝙁𝙪𝙣𝙙𝙖𝙢𝙚𝙣𝙩𝙖𝙡𝙨

Launching Excel, Microsoft Excel Startup Screen, Introduction to the Excel Interface, Customizing the Excel Quick Access Toolbar, More on the Excel Interface, Understanding the Structure of an Excel Workbook, Saving an Excel Document, Opening an Existing Excel Document, Common Excel Shortcut Keys.

Quiz 1: Session One Quiz

𝙎𝙚𝙨𝙨𝙞𝙤𝙣 𝙏𝙬𝙤: 𝙀𝙣𝙩𝙚𝙧𝙞𝙣𝙜 𝙀𝙙𝙞𝙩𝙞𝙣𝙜 𝙏𝙚𝙭𝙩 𝙖𝙣𝙙 𝙁𝙤𝙧𝙢𝙪𝙡𝙖𝙨

Entering Text to Create Spreadsheet Titles, Working with Numeric Data in Excel, Entering Date Values in Excel, Working with Cell References, Creating Basic Formulas in Excel, Relative Versus Absolute Cell References in Formulas. The structure of an Excel Function, Working with the SUM() Function, Working with the MIN() and MAX() Functions, Working with the AVERAGE() Function, Working with the COUNT() Function, Adjacent Cells Error in Excel Calculations, Using the AutoSum Command, Excel's AutoSum Shortcut Key, Using the AutoFill Command to Copy

Formulas, Quiz 3: Basic Excel Functions Quiz

Quiz 2: Session Two Quiz

𝙎𝙚𝙨𝙨𝙞𝙤𝙣 𝙏𝙝𝙧𝙚𝙚: 𝙈𝙤𝙙𝙞𝙛𝙮𝙞𝙣𝙜 𝙖𝙣𝙙 𝙁𝙤𝙧𝙢𝙖𝙩𝙩𝙞𝙣𝙜 𝙩𝙝𝙚 𝙀𝙭𝙘𝙚𝙡 𝘿𝙖𝙩𝙖

Moving and Copying Data in an Excel Worksheet, Inserting and Deleting Rows and Columns, Changing the Width and Height of Cells, Hiding and Unhiding Excel Rows and Columns, Renaming an Excel Worksheet, Deleting an Excel Worksheet, Moving and Copying an Excel Worksheet, Moving and Copying Data in an Excel Worksheet, Inserting and Deleting Rows and Columns, Changing the Width and Height of Cells, Hiding and Unhiding Excel Rows and Columns, Renaming an Excel Worksheet, Deleting an Excel Worksheet, Moving and Copying an Excel Worksheet, Working with Font Formatting Commands, Changing the Background Color of a Cell, Adding Borders to Cells, Excel Cell Borders Continued, Formatting Data as Currency Values, Formatting Percentages, Using Excel's Format Painter, Creating Styles to Format Data, Merging and Centering Cells, Using Conditional Formatting, Editing Excel Conditional
Formatting,

Quiz 3: Session Three Quiz

𝙎𝙚𝙨𝙨𝙞𝙤𝙣 𝙁𝙤𝙪𝙧: 𝙂𝙧𝙖𝙥𝙝𝙞𝙘𝙖𝙡 𝙍𝙚𝙥𝙧𝙚𝙨𝙚𝙣𝙩𝙖𝙩𝙞𝙤𝙣, 𝙎𝙝𝙖𝙥𝙚𝙨 𝙖𝙣𝙙 𝘼𝙡𝙞𝙜𝙣𝙢𝙚𝙣𝙩

 Inserting Images, Inserting Excel Shapes, Formatting Excel Shapes, Working with Excel SmartArt, Creating an Excel Column Chart, Working with the Excel Chart Ribbon, Adding and Modifying Data on an Excel Chart, Formatting an Excel Chart, Moving a Chart to another Worksheet, Working with Excel Pie Charts, Viewing your Document in Print Preview, Changing the Margins, Scaling and Orientation, Excel Worksheet Margin, Working with Page Layout View, Adding Header and Footer Content, Printing a Specific Range of Cells, Intro to Excel Templates, Opening an Existing Template, Creating a Custom Template

Quiz 4: Session Four Quiz

𝙎𝙚𝙨𝙨𝙞𝙤𝙣 𝙁𝙞𝙫𝙚: 𝘽𝙖𝙨𝙞𝙘 𝙀𝙭𝙘𝙚𝙡 𝙁𝙪𝙣𝙘𝙩𝙞𝙤𝙣𝙨 𝙖𝙣𝙙 𝙑𝙖𝙡𝙞𝙙𝙖𝙩𝙞𝙤𝙣

Understanding Excel List Structure, Sorting a List Using Single Level Sort, Sorting a List Using Multi-Level Sorts, Using Custom Sorts in an Excel List, Filter an Excel List Using the AutoFilter Tool, Creating Subtotals in a List, Format a List as a Table, Using Conditional Formatting to Find Duplicates, Removing Duplicates, Introduction to Excel's Function: DSUM(), Excel DSUM Function Single Criteria Continued, Excel DSUM Function with OR Criteria, Excel DSUM Function with AND Criteria, Excel Function: DAVERAGE(), Excel Function: DCOUNT(), Excel Function: SUBTOTAL(), Understanding the Need for Excel Data Validation, Creating an Excel Data Validation List, Excel Decimal Data Validation, Adding a Custom Excel Data Validation Error, Dynamic Formulas by Using Excel Data Validation Techniques

Quiz 5: Session Five Quiz

𝐒𝐞𝐬𝐬𝐢𝐨𝐧 𝐒𝐢𝐱: 𝐑𝐞𝐩𝐨𝐫𝐭𝐬 𝐚𝐧𝐝 𝐎𝐭𝐡𝐞𝐫 𝐇𝐢𝐠𝐡𝐥𝐢𝐠𝐡𝐭𝐬 𝐏𝐢𝐯𝐨𝐭 𝐭𝐚𝐛𝐥𝐞 𝐠𝐞𝐧𝐞𝐫𝐚𝐭𝐢𝐨𝐧 𝐝𝐢𝐬𝐜𝐮𝐬𝐬𝐢𝐨𝐧, 𝐓𝐢𝐩𝐬 𝐚𝐧𝐝 𝐓𝐫𝐢𝐜𝐤𝐬, 𝐓𝐚𝐤𝐞𝐚𝐰𝐚𝐲𝐬 (𝐑𝐞𝐬𝐨𝐮𝐫𝐜𝐞 𝐒𝐡𝐚𝐫𝐢𝐧𝐠)

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


Are there any course requirements or prerequisites?
● No Prior 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

Who this course is for:
● 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.