Overview

This course is designed for all whether they are studying in schools or working in corporates. This course will add a highly valuable asset to your professional portfolio. The course starts from scratch where you will start with basic spreadsheet skills and at the end of this course, you will be excellent in Excel where you will be able to do complex calculations, plot graphs, charts, and analyze data for problem-solving. You will learn 360 degree of Learning of Microsoft Excel. This course is divided into 6 Sessions where you will cover 45 Topics. Session 1:1. Introduction2. Starting Excel3. Screen4. Templates5. Ribbon and Backstage View6. Quick Access Toolbar7. Smart Lookup8. Interface ElementsSession 2:1. Navigation2. Keyboard Shortcuts3. Entering Text4. Number Format5. Deleting & Formatting6. AutoSum7. Simple Formulas8. Simple FunctionsSession 3:1. Absolute Referencing2. Moving & Copying Data3. Inserting Rows & Columns4. AutoFill5. Cell Styles6. Worksheet Themes7. Create Templates8. Freeze PanesSession 4:1. Grouping Worksheets2. Page Layout View3. Custom Views4. Spell Check5. PrintingSession 5:1. Introduction to Table2. Overview of List Design3. Formatting Lists as Tables4. Filtering Records from Lists or Tables5. Removing Duplicates from Lists or Tables6. Flash Fill7. Single & Multi-Level Sorting8. Inserting Automatic Subtotals in ListsSession 6:1. Introduction to chart2. Inserting Data Charts Using Recommended Charts3. Formatting & Editing Chart Elements4. Creating & Applying Custom Chart Templates5. Adding & Removing Data from Charts6. Inserting Sparklines7. Printing Charts

Skills

Reviews