CALL US TODAY ! 9354437773 | info@firstskool.org

Why Take This Course?

If you are not learning technology of today then you can’t be part of a successful workforce of tomorrow. With our online certification courses you just don’t master the technology, you also get recognition. We are sure that this will get you the dream job and a shining that you want to have. Our online courses will provide you a personalized learning experience giving you enough flexibility of schedule/time and saving a lot of money and time for you.

One of the most used operating systems in companies, with this course, you will learn features like Microsoft Word, Excel, Powerpoint and other programs that are on offer.

Why Join Us ?

null

Expert Team

Our courses are developed by team of experts who have
real expertise in the same domain. They know what is
best for you and how to deliver it to you. Courses are
finalized after proper scruiting, minimising chances
of any error.
null

Consistent Guidance & Doubt Resolution

Our expert team would always be there for you to
clear any doubt regarding subject matter or providing
you guidance regarding the course you are taking.
null

Personalized Learning

You can watch our videos in your laptop/tablet at your
homes whenever you want. Saving lot of time and money
that you would be spending at coaching centres in megacities.
null

One Stop Solution

We will be providing everything that you need to
develop relevant skills and lead a path to success
in corporate world.

Advance your Career

This program was built to ensure that you learn the right skills which are necessary to succeed.

Be Right On Target

With our accurate and guidance scientific teaching methods you can acquire skills and knowledge which is essential for making you what you want to be.

Learn with Ease

You don’t have to go through tons of coaching materials and lots of stress analyzing what to study from where to study. Learn with us sitting at your homes in comfort what is essential.

Learning Community

By joining groups you can have peers to learn and compete with. It certainly helps in assessing yourself and eases the path to success.


Course Curriculum

Basic course for Microsoft Excel
Introduction: Welcome to the Ultimate Microsoft Excel 00:00:00
Excel Fundamentals 00:00:00
Launching Excel 00:00:00
Introduction to the Excel Interface 00:00:00
Customizing the Excel Quick Access Toolbar 00:00:00
Understanding the Structure of an Excel Workbook 00:00:00
Saving an Excel Document 00:00:00
Opening an Existing Excel Document 00:00:00
Common Excel Shortcut Keys 00:00:00
Excel Fundamentals Quiz 00:00:00
Entering and Editing Text and Formulas 00:00:00
Entering Text to Create Spreadsheet Titles 00:00:00
Working with Numeric Data in Excel 00:00:00
Entering Date Values in Excel 00:00:00
Working with Cell References 00:00:00
Creating Basic Formulas in Excel 00:00:00
Relative Versus Absolute Cell References in Formulas 00:00:00
Understanding the Order of Operation Entering and Editing Text and Formulas Quiz 00:00:00
Working with Basic Excel Functions 00:00:00
The structure of an Excel Function 00:00:00
Working with the SUM() Function 00:00:00
Working with the MIN() and MAX() Functions 00:00:00
Working with the AVERAGE() Function 00:00:00
Working with the COUNT() Function 00:00:00
Using the AutoSum Command 00:00:00
Using the AutoFill Command to Copy Formulas 00:00:00
Basic Excel Functions Quiz 00:00:00
Modifying an Excel Worksheet 00:00:00
Moving and Copying Data in an Excel Worksheet 00:00:00
Inserting and Deleting Rows and Columns 00:00:00
Changing the Width and Height of Cells 00:00:00
Hiding and Unhiding Excel Rows and Columns 00:00:00
Deleting an Excel Worksheet 00:00:00
Renaming an Excel Worksheet 00:00:00
Moving and Copying and Excel Worksheet 00:00:00
Modifying Worksheets Quiz 00:00:00
Formatting Data in an Excel Worksheet 00:00:00
Working with Font Formatting Commands 00:00:00
Changing the Background Color of a Cell Adding Borders to Cells 00:00:00
Formatting Data as Currency Values 00:00:00
Formatting Percentages 00:00:00
Using Excel’s Format Painter 00:00:00
Creating Styles to Format Data 00:00:00
Merging and Centering Cells 00:00:00
Merging and Centering Cells 00:00:00
Using Conditional Formatting 00:00:00
Formatting Data Quiz 00:00:00
Inserting Images and Shapes into an EXCEL SHEET 00:00:00
Inserting Images 00:00:00
Inserting Excel Shapes 00:00:00
Formatting Excel Shapes 00:00:00
Working with Excel SmartArt 00:00:00
Creating Basic Charts in Excel 00:00:00
Creating an Excel Column Chart 00:00:00
Working with the Excel Chart Ribbon 00:00:00
Adding and Modifying Data on an Excel Chart 00:00:00
Formatting an Excel Chart 00:00:00
Moving a Chart to another Worksheet 00:00:00
Working with Excel Pie Charts 00:00:00
Working with Excel Charts Quiz 00:00:00
Printing an Excel Worksheet 00:00:00
Viewing your Document in Print Preview 00:00:00
Intermediate course for excel
Changing the Margins, Scaling and Orientation 00:00:00
Working with Page Layout View 00:00:00
Adding Header and Footer Content 00:00:00
Printing a Specific Range of Cells 00:00:00
Printing and Excel Worksheet Quiz 00:00:00
Working with Excel Templates 00:00:00
Intro to Excel Templates 00:00:00
Opening an Existing Template 00:00:00
Creating a Custom Template 00:00:00
Microsoft Excel Foundation 00:00:00
Course Exercise Files – Download these First 00:00:00
Working with an Excel List 00:00:00
Understanding Excel List Structure 00:00:00
Sorting a List Using Single Level Sort 00:00:00
Sorting a List Using Multi-Level Sorts 00:00:00
Using Custom Sorts in an Excel List 00:00:00
Filter an Excel List Using the AutoFilter Tool 00:00:00
Creating Subtotals in a List Format a List as a Table 00:00:00
Using Conditional Formatting to Find Duplicates 00:00:00
Removing Duplicates 00:00:00
Excel List Functions Excel Function: DSUM() Excel Function: DAVERAGE() Excel Function: DCOUNT() Excel Function: SUBTOTAL() Excel Data Validation 00:00:00
Understanding the Need for Data Validation 00:00:00
Creating a Validation List 00:00:00
Adding a Custom Validation Error 00:00:00
Dynamic Formulas by Using Validation Techniques 00:00:00
Importing and Exporting Data 00:00:00
Importing Data from Text Files 00:00:00
Importing Data from Microsoft Access 00:00:00
Exporting Data to a Text File 00:00:00
Excel PivotTables 00:00:00
Understanding Excel PivotTables 00:00:00
Creating an Excel PivotTable 00:00:00
Modifying Excel PivotTable Calculations 00:00:00
Grouping PivotTable Data 00:00:00
Formatting PivotTable Data 00:00:00
Drilling Down into PivotTable Data 00:00:00
Creating PivotCharts 00:00:00
Filtering PivotTable Data 00:00:00
Filtering with the Slicer Tool 00:00:00
Working with Excel’s PowerPivot Tools 00:00:00
Why PowerPivot? 00:00:00
Activating the Excel PowerPivot AddIn 00:00:00
Creating Data Models with PowerPivot 00:00:00
Creating PivotTables based on Data Models 00:00:00
PowerPivot Calculated Fields 00:00:00
PowerPivot KPIs 00:00:00
Working with Large Sets of Excel Data 00:00:00
Using the Freeze Panes Tool 00:00:00
Grouping Data (Columns and/or Rows) 00:00:00
Print Options for Large Sets of Data 00:00:00
Print Options for Large Sets of Data 00:00:00
Consolidating Data from Multiple Worksheets 00:00:00
Advanced course in excel
Microsoft Excel 103 Course Introduction Course Exercise Files – Download this Excel File First! 00:00:00
Working with Excel’s Conditional Functions 00:00:00
Working with Excel Name Ranges 00:00:00
Using Excel’s IF() Function 00:00:00
Nesting Functions 00:00:00
Using Excel’s COUNTIF() Function 00:00:00
Using Excel’s SUMIF() Function 00:00:00
Using Excel’s IFERROR() Function 00:00:00
Working with Excel’s Lookup Functions 00:00:00
Excel’s VLOOKUP() Function 00:00:00
Excel’s HLOOKUP() Function 00:00:00
Using Excel’s INDEX() and MATCH() Functions 00:00:00
Working with Excel’s Text Based Functions 00:00:00
Using Excel’s LEFT(), RIGHT() and MID() Functions 00:00:00
Using Excel’s LEN() Function 00:00:00
Using Excel’s SEARCH() Function 00:00:00
Excel’s CONCATENATE() Function 00:00:00
Auditing an Excel Worksheet 00:00:00
Tracing Precedents in Excel Formulas 00:00:00
Tracing Dependents in Excel Formula 00:00:00
Working with the Watch Window Showing Formulas 00:00:00
Protecting Excel Worksheets and Workbooks 00:00:00
Protecting Specific Cells in a Worksheet 00:00:00
Protecting the Structure of a Workbook 00:00:00
Adding a Workbook Password 00:00:00
Mastering Excel’s “What If?” Tools 00:00:00
Working with Excel’s Goal Seek Tool 00:00:00
Working with Excel’s Solver Tool 00:00:00
Building Effective Data Tables in Excel 00:00:00
Creating Scenarios in Excel 00:00:00
Automating Repetitive Tasks in Excel with Macros 00:00:00
Understanding Excel Macros 00:00:00
Activating the Developer Tab in Excel 00:00:00
Creating a Macro with the Macro 00:00:00
Recorder 00:00:00
Editing a Macro with VBA 00:00:00
Creating Buttons to Run Macros 00:00:00
Introduction – Welcome to the Course Understanding the Why and How Behind Excel Macros 00:00:00
Advanced course on Pivot tables
Why PivotTables? 00:00:00
Structuring Your Source Data 00:00:00
Inserting Your First PivotTable 00:00:00
IMPORTANT: “Add to Data Model” 00:00:00
Navigating the Field List 00:00:00
KNOWLEDGE CHECK: Manipulating Pivot Table Views 00:00:00
PivotTable Options: “Analyze” & “Design” Selecting, Clearing, Moving & Copying Pivots 00:00:00
Refreshing & Updating Pivots 00:00:00
PRO TIP: Dealing with Growing Source Data 00:00:00
How PivotTables ACTUALLY Work 00:00:00
PivotTable Formatting 00:00:00
Number Formatting 00:00:00
PRO TIP: Automatically Formatting Empty Cells 00:00:00
Table Layouts & Styles PRO TIP: Using Tabular Tables to Create New Source Data 00:00:00
Customizing Headers & Labels 00:00:00
Conditional Formatting PRO TIP: Data Bars with Invisible Text 00:00:00
Sorting, Filtering & Grouping 00:00:00
Sorting Options PRO TIP: Why is my Alphabetical Sorting Wrong? 00:00:00
Label Filters & Manual Selections PRO TIP: Using Label Filters with 00:00:00
Wildcards Value Filters PRO TIP: Enabling Multiple Filters Grouping Data PRO TIP: Automatic Date GroupiNG 00:00:00
Using Slicers & Timelines to Filter Data Breaking Out Report Filter Pages 00:00:00
Calculated Values, Fields & Items “Summarize Values By” Options PRO TIP: Avoiding the “Count Of” Trap 00:00:00
“Show Values As” Calculations Show Values As: % of Column/Row Show Values As: % of Parent Show Values As: Difference From Show Values As: Running Total Show Values As: Rank Show Values As: Index 00:00:00
KNOWLEDGE CHECK: Show Values As Inserting Calculated Fields 00:00:00
Calculations in Pivots vs. Raw Data 00:00:00
PRO TIP: Calculating Using Counts PRO TIP: Calculating Using Counts (part 2) 00:00:00
Inserting a Calculated Item (not recommended!) 00:00:00
Intro to PivotCharts 00:00:00
PivotChart Demo: Column Chart PivotChart Demo: Pie/Donut Chart PivotChart Demo: Clustered Bar Chart PRO TIP: Prevent Charts from Resizing with Cells 00:00:00
Changing Chart Types on the Fly 00:00:00
PivotChart Demo: Stacked Area Chart 00:00:00
PivotChart Layouts & Styles 00:00:00
Moving PivotCharts to New Sheets 00:00:00
Applying Slicers & Timelines to Multiple Charts 00:00:00
Building a Dynamic Dashboard 00:00:00
Data Visualization Best Practices 00:00:00
Key Data Viz Principles & The 10-Second Rule 00:00:00
The Good, The Bad, and The Ugly 00:00:00
The 3 Key Questions 00:00:00
Customizing Charts in Excel 00:00:00
Setting Expectations 00:00:00
Chart Elements, Layouts, Colors & Styles 00:00:00
Chart Formatting Options 00:00:00
Changing Chart Types & Adding a Secondary Axis 00:00:00
Creating, Modifying & Applying Custom Templates 00:00:00
Chart Customization 00:00:00
Mastering Basic Charts & Graphs 00:00:00
Next-Level Data Visualization Exercises Setting Expectations 00:00:00
Custom Image Overlay Charts 00:00:00
Adding Binary Values to Highlight Date Ranges 00:00:00
Automation with OFFSET, COUNTA & Named Ranges 00:00:00
Adding Scroll & Zoom Functionality with Form Controls 00:00:00
Animating Changes Over Time 00:00:00
Building a Dynamic Dashboard (Part 1) 00:00:00
Building a Dynamic Dashboard (Part 2) 00:00:00
Value-Based Dynamic Formatting 00:00:00
Dynamically Highlighting a Data Series 00:00:00
Building a Custom Pacing Chart 00:00:00
Designing a Custom Gauge Chart 00:00:00
Visualizing a Percentage Using Array Functions 00:00:00
Advanced Data Visualization Techniques 00:00:00
How to Create Custom Shortcut Menus for Individual Form Controls 00:00:00
Overview of Shortcut Menus – A Demo of the Finished Form 00:00:00
Download the Shortcut Database 00:00:00
Create the Shortcut Menu Program 00:00:00
Start Building Shortcut Menu Subroutine 00:00:00
Finish the Shortcut Menu Subroutine 00:00:00
Add Menu Groups and More Commands 00:00:00
Modify Menus and Add a Call to a VBA Subroutine 00:00:00
Modify Menus and Add a Call to a VBA Subroutine 00:00:00
Build a Searchable List Box 00:00:00
Overview of Finished Form 00:00:00
Download the ListBox Database 00:00:00
Start Modifying the Customer Form 00:00:00
Start Customizing the Listbox 00:00:00
Expand the Listbox Keydown Routine 00:00:00
Continue Building the ListFind Function 00:00:00
Add Backspace Functionality 00:00:00
Add the Location of Customer Records Functionality 00:00:00
Design Challenge – Create Running Balances in a Subform & Update Main Form 00:00:00
Advanced courses in PowerPoint
Introduction (brief welcome) 00:00:00
Essential Knowledge (hints before you start) 00:00:00
Slide Design (14 slides to create) 00:00:00
Slide Master (creating & setting up templates) 00:00:00
Slide Design #2 (14 more slide ideas) 00:00:00
Slide Design #3 00:00:00
Polishing Presentations (important touches) 00:00:00
Introduction to Azure 00:00:00
Deploying Virtual Machines 00:00:00
Azure Active Directory 00:00:00
Deploying Websites 00:00:00
Azure SQL 00:00:00
Azure Storage 00:00:00
Azure Containers 00:00:00
Azure Networking 00:00:00
Automation and Log Analytics 00:00:00
Deploying Virtual Machines Active Directory 00:00:00
Deploying Web Sites 00:00:00
Azure – SQL 00:00:00
Azure Storage and Azure Containers 00:00:00
Networking 00:00:00
Automation and Log Analytics 00:00:00

Pricing

FAQ

How can I get this course?

Click over “BUY NOW” Button given below the course, you will be redirected to online payments page. Payment can be done online via different modes of payment like Credit Cards, Debit Cards, Net Banking, E-wallets etc.

What do I get?

Depends upon what you choose. You can either enroll for live classes or purchase a tablet/SD card course.

How are live classes different from SD card/tablet courses?

Live classes will be streamed online through our platform on scheduled time. You can watch the streaming session along with other learners, ask your doubts immediately and get them resolved. While tablet/SD card courses are pre-recorded which you can watch whenever you want. Although live streamed videos will remain available to watch-re watch upto a certain time period.

How do I get my doubts resolved?

In live classes you can ask your doubts immediately where it will be resolved by our experts immediately. In case of tablet/SD card courses you can mail your doubts/questions to the mail id provided. Your doubts will be resolved within 24 hours by our experts.

How many number of times can I watch the videos?

You can watch video courses as many times as you want, during the validity duration of the course. However, after the validity period videos will get vanished from SD card/tablet. Although SD card/tablet will be yours to use onwards.

What will be the validity duration of courses?

It will be mentioned for each course. You’ll have the options to choose any of the mentioned plans.

What if I miss my scheduled live class?

No worries at all. Each and every video will be available after each live session. You can watch that when you get time. You can also watch them any number of time during the course duration.

Do I need some software or special tool to play lecture videos?

No. You can play our videos on regular video players. Also our live courses will be streamed on our website so you don’t need any special software or tool for that.

© FirstSkool  All rights reserved.

X