Or Login with
Enter OTP
Please enter the OTP you have recieved on your Mobile No.
Want to recieve OTP on Email or on the Phone No?
OR
Sign Up
Please enter your registered email address to get the link to reset your new password.
Thank you for purchasing this course.
by Super Admin
Estimated Time
On demand video
Enrolled By
Students & professionals
Total
Resources
Full
Access
What is PowerPivot?
Activating the Excel PowerPivot Add-In
Creating Relationships between Data Tables
Using Data Models to Create PivotTables
How to Create PowerPivot KPI’s
Creating an Excel Resume
Getting Started with Freelancing
How to Become an Excel Freelancer
Top Freelance Sites
How to Get Your First Client
Personal Branding
Networking Do’s and Don’ts
Importance of Website
Creating an Excel UserForm
Adding Controls to UserForms
How to Show an UserForm
Passing TextBox Values to Desired Cells
Passing Option Buttons Values to Desired Cells
UserForm ComboBoxes
Clearing Values from UserForm Controls
How to Close an UserForm
UserForms and Protected Sheets
Assigning Macros to Shapes
Form Controls vs ActiveX Controls
Worksheet Events
Workbook Events
Fun with VBA Events
For Next Loop
Do Until Loop
For Each Loop
Find Last Row of Data
Find Last Column of Data
With Statement
Debugging and Error Handling
Debugging and Error Handling Cont
Referencing a Range
InputBox and MsgBox
Using Variables in VBA Code
If Then Else Statement
Worksheet Functions inside VBA
Creating User Defined Functions
User Defined Functions within VBA Scripts
Modules and Procedures
Object Methods and Properties
Excel VBA Variables
The Power Behind Excel VBA
A Look Inside the Visual Basic Editor
Recording a Macro
Saving and Opening a Macro Enabled Workbook
Excels Scenario Manager Tool
Goal Seek in Excel
Compare Results with Excel Data Tables
Solver Tool
Tracing Precedents and Dependents in Formulas
Showing Formulas
Grouping Data
3D Referencing in Formulas
Utilizing the Watch Window in Excel
How to Freeze Panes in Excel
LEFT(), RIGHT() and MID() Function
Extracting Specific Text using LEN() and SEARCH()
Combining Text with CONCATENATE()
Quick Tips and Other Text Based Functions
VLOOKUP() Function
The Beauty of Excel’s IFERROR() Function
HLOOKUP() Function
INDEX() Function
MATCH() Function
INDEX() and MATCH() Combined
Two-Way Lookup with INDEX() and MATCH()
Excel’s IF() Function
IF() Function with AND() Criteria
IF() Function with OR() Criteria
Nesting Multiple IF() Functions
The COUNTIF() Function
Key Benefits of Using Named Ranges
Excel from A-Z Course Section Overview
What is Microsoft Excel?
Who is This Course For
Microsoft Excel Marketplace
Excel Job Opportunities
Excel Job Types
Creating an Excel Pivot Table
Modifying Excel Pivot Tables
Grouping and Filtering PivotTable Data
Drilling Down into PivotTable Data
Creating PivotCharts and Utilizing Slicers
What is Excel Data Validation?
Creating a Drop Down List with Data Validation
Different Types of Data Validation
Adding Custom Alerts to Data Validation
Creating a Dynamic Drop Down List
Complex Validation - Dependent Drop Down List
The SUMIF() Function
The DSUM() Function
DSUM() Function Cont
The SUBTOTAL() Function
How to Prepare Data for Analysis
How to Sort Data in Excel
Multi Level Sorting
Custom Sorting Datasets in Excel
Applying Filters to Datasets
Creating Subtotals within a Dataset
Converting Datasets into Tables
Finding and Removing Duplicate Values
Why Create an Excel Template
How to Create an Excel Template
Print Preview Options
Excels Page Layout View
Printing a Specific Range of Cells
Converting Spreadsheets to PDF Files
The Commonly Used Column Chart
Changing the Chart Design
Formatting Elements of a Chart
Modifying the Data Type and Location of a Chart
Little Slice of Pie Charts
Grab Users Attention using Illustrations
Customizing Icons
Create Compelling Graphics with SmartArt
Adding Cell Borders
Formatting Data Appropriately
The Magic Behind Excel's Format Painter
Creating Styles for Formatting Efficiency
Merging Cells for a Cleaner Look
The Power of Conditional Formatting
Formatting Fonts and Cell Background Color
Moving and Copying Data
Insert and Delete Rows/Columns
Adjusting the Width and Height of Cells
Hiding and Unhiding Excel Rows and Columns
Renaming Moving and Deleting Excel Worksheets
Adding Protection to Specific Cells
Protecting the Structure of a Workbook
Adding a Workbook Password to Open File
Excel Functions Explained
The SUM() Function
The MIN() and MAX() Function
The AVERAGE() Function
COUNT() Functions
Creating Excel Labels
Entering Numeric Data in Excel
Formatting Date Values in Excel
Building Basic Formulas in Excel
Order of Operation
Relative vs Absolute Cell References
Finding and Opening Microsoft Excel
Excel's Start Screen
Explaining the Excel Interface
Excel Interface Continued
Excel Workbook vs Excel Worksheet
Saving and Opening Excel Documents
Customizing the Quick Access Toolbar
Customizing the Excel Ribbon
Excel Shortcut Keys
To purchase your course online just follow the link. Online purchases can either be paid for immediately by credit/debit card, you can nominate somebody else to pay on your behalf, or an invoice can be requested.
On completing the online purchase process you will have immediate access to your course.
You have access to the courses you have purchased indefinitely. Once the payment is made, the confirmation notice will be sent to the client via email within 24 hours of receipt of payment.
No, you can visit it at any time, wherever you are. Each course is made up of a number of individual modules which enables you to complete it in your own time and at times convenient to you. If you wish to return to the course at the point, you last left it at, please ensure you use the same device to access the course and do not clear your cache in between visits.
Please contact the QH social media or by calling +97150209580.
The software that we use for our eLearning does not have a download or print function, so there is no easy way to obtain this. For this reason, once you have purchased individual eLearning courses with us you have indefinite access to them so that you may return to the information and review it at any time.
Refunds will be made onto the original mode of payment and will be processed within 10 to 45 days depending on the issuing bank of the credit card used.
Any learner can withdraw from the programme and receive a refund based on the following Criteria:1- Online courses 24 hours Before the course starts: No refund.2- more than 24 hours before the course starts: Full refund.3- Products Full refunds within 14 days of purchase.Services As per terms and conditions in the service delivery contract.4. Payment confirmation
Customer can cancel their order/requested services within 24 hours; refunds will be made back to the payment solution used initially by the customer. Please allow for up to 45 days for the refund transfer to be completed.
If you did not pass the course with the grade required to earn the certificate, you can enroll in a future session.
There are 2 options:Option 1: purchase the program bundle:One-click bundle purchase to add all the program courses at once.Option 2: Upgrade Course by CourseYou can also purchase the program courses one by one.
SEP currently offers two types of certificates:- Certificates for single courses- Program certificates for programs (series of courses)
SEP courses do not award free certificates. Certificates are awarded only to passing students registered in the paid certificate track. The enrollment fee for this track varies by course.
SEP cannot send individual printed copies of certificates. However, you can save the certificate by downloading it as a PDF file.
Yes. With the exception of professional education courses.
You can save your certificate on your computer by downloading it as a PDF using either the Chrome or Safari browser.
To add your SEP certificate directly to your LinkedIn profileLog in to your LinkedIn account, then go to your profile.On the right, in the Add profile section dropdown, choose Background and then select the drop-down triangle next to Licenses & Certifications.In Name, enter the name of the course or program.In Issuing Organization, enter "SEP".(Optional) In Issue Date, enter the time period during which you earned the certification.(Optional) Select the checkbox This certification does not expire.You can leave the Credential ID field empty.In Certification URL, enter the URL for your certificate.
More questions? Visit the Learner Help Center.