Microsoft Excel Course

Uplatz offers complete course on Microsoft Excel. This is video-based online course (self-paced training). You will be awarded Course Completion Certificate at the end of the course.

Become MS Excel guru today with our super course that integrates the beginner, intermediate, and expert courses bundled into a star course!

Microsoft Excel is the leading spreadsheet software across the globe. Due to its versatile applicability, Excel is widely used in every industry, office and home across all domains and functions such as Finance, Operations, Marketing, and so on. Excel can used to record transactions, budgeting, timesheets, expenses, sales, and perform comprehensive data analysis, calculations, and visualization in the form of charts and graphs.

It is a self-paced course and consists of short-to-long pre-recorded videos catering to each of the topics. The course can be accessed from any device - mobile, laptop, desktop, tab - 24*7.

The unique feature of this course is that if you believe that any topic is not covered fully or is not covered at all, then just let us know and we'll provide you an additional full detailed video covering that topic absolutely free of cost!

Uplatz's Microsoft Excel course combines the power of beginner, intermediate, and expert courses.
This training will teach you everything from the world of Excel so as to provide you complete knowledge, skills, and confidence.

After learning this course you can start applying for relevant jobs in the market and crack the interviews.

Uplatz Certificate of Completion

Digital certificate - Included

Microsoft Excel Course Curriculum

Key highlights of our course are:

-- Overview of Excel
-- Understanding the menu options
-- Formatting such as creating borders, wrap text, changing fonts, etc.
-- Merging cells
-- Calculating sums, averages, and totals
-- Counting cells
-- Learning formulas, such as IF, COUNTIF, SUMIF, VLOOKUP, HLOOKUP, and AVERAGEIF
-- Filters
-- Pivot tables
-- Inserting, editing, and deleting comments
-- Pasting, sorting, transpose, paste special
-- Creating graphs and charts
-- Using hyperlinks
-- Functions such as ABS, SUMIF, HLOOKUP, VLOOKUP, COUNTIF, AVERAGEIF, AVERAGEIFS, and AVERAGEA
-- Data validation with date, list, time, and numbers
-- Functions such as RANK, MIN, MAX, CHAR, MODE, MEDIAN, CODE, CLEAN, and EXACT
-- How to remove duplicates in Excel
-- Creating random numbers
-- Changing text case
-- Adding passwords
-- Sending emails from Excel
-- Adding custom backgrounds
-- How to auto fill data
-- Adding special characters
-- VLOOKUP Advanced formula options and manipulations
-- Other advanced functions including OR, AND, CHOOSE, INDIRECT, REPLACE, LEN, LEFT, FIND
-- Functions including CEILING, CORREL, DATEDIF, DATEVALUE, DAVERAGE and EDATE
-- Colouring a column and row with a formula
-- Highlighting a cell with a formula
-- Functions including ISODD, ISNUMBER, ISTEXT, ISLOGICAL, ISNONTEXT, ISERR and ISBLANK
-- Functions including DGET, DMAX, DPRODUCT, DCOUNTA, DCOUNT and DSUM
-- Financial analysis: calculating loan IPMT and EMI
-- Functions including DATEDIF, DATEVALUE, EDATE, EOMONTH, MATCH and INDEX
-- Full explanation of the INDEX and MATCH functions, covering several modules
-- Looking up data
-- Selecting only cells containing comments
-- Hiding formulas
-- Easily build dynamic tools & Excel dashboards to filter, display and analyse your data
-- Design your own formula-based formatting rules
-- Join datasets from multiple sources in seconds with lookup, index & match functions
-- Pull real-time data from APIs directly into Excel (weather, stock quotes, directions, etc.)
-- Manipulate dates, time, text, and arrays
-- Automate tedious and time-consuming analytics tasks using cell formulas and functions in Excel
-- Lookup/Reference functions
-- Statistical functions
-- Formula based formatting
-- Date & Time functions
-- Logical operators
-- Array formulas
-- Text functions
-- Powerful analytics tools and formulas like INDIRECT, HYPERLINK, WEBSERVICE & FILTERXML
-- Filtering & Sorting
-- Conditional Formatting
-- Charts and Graphs
-- VBA (Visual Basic for Applications) basics – let’s get started
-- Excel Shortcuts – for everyday use. Make yourself super-efficient and fast
-- Excel Tips & Tricks
-- Commonly used formatting techniques, fonts, designs, and best practices
-- Handling huge data sets
-- Introduction to G Suite and Google Sheets
-- Difference between Google Sheets and MS Excel

Everyone

Passion and determination to achieve your goals!

• Data Analyst
• Reporting Analyst
• Data Consultant
• Business Analyst
• Project Manager
• System Analyst
• Marketing/Finance Analyst
• Web Analyst
• Data Scientist
• Product Manager
• BI Consultant

Currently there are no Q&As for this course. Be the first to ask a question.