Email: vkymalikofficial@gmail.com

 | Phone: +918383909294

Follow us on: 

MS Excel

Microsoft Excel Basic to Advance

Microsoft Excel is a software program produced by Microsoft that allows users to organize, format and calculate data with formulas using a spreadsheet system. This software is part of the Microsoft Office suite and is compatible with other applications in the Office suite.

Excel Crash Course Description

In this Excel tutorial, you will learn all the tips, tricks, shortcuts, functions and formulas you need to be an Excel power user. This free Excel course is designed specifically for spreadsheet users who are already performing professional financial analysis and financial modeling or are looking to prep for a wall street career. Take this Excel Crash Course now to advance your career!

Excel tutorial & training details

This excel training course starts with the Excel basics and quickly progresses to a more advanced level where even experts will learn something new. We believe it is important to start at the bottom and build a solid base, which is why we review all the foundational skills you need before building more advanced spreadsheets. In this Excel tutorial, you will learn to leave behind the mouse and use keyboard shortcuts to dramatically improve and speed up your spreadsheet building skills.

What you will learn in this MS Excel training

In this course, you will learn:

  • How to be a better, faster, stronger Excel user
  • How to save yourself hours of time and boost your productivity in Excel
  • How to navigate the Excel interface
  • How to use math, statistical, logic and text functions
  • How to find a value with VLOOKUP, HLOOKUP, INDEX, MATCH
  • How to sort and filter your data to find exactly what you are looking for
  • How to work with charts to present clear insights from your data
  • How to create and format Pivot Tables
  • How to record a basic Macro to automate repetitive tasks
  • How to use data validation to restrict data entry
  • How to customize your page setup options for printing
  • How to impress your boss and colleagues with your super sharp Excel skills
  • How to create effective spreadsheets
  • How to create professional and good looking advanced charts

What we offer:

  • Well-designed and easy-to-understand materials
  • Detailed explanations with comprehensible case studies based on real situations
  • Downloadable course materials
  • Regular course updates
  • NEW! Includes professional chart examples that are
  • Unlimited access to all course materials
  • Certificate After Completion of Training

Are there any course requirements or prerequisites?

  • Basic accounting knowledge
  • Be able to operate a PC. That’s all.

Who this course is for:?

  • Excel users who have basic skills but want to get really, REALLY good
  • This online course is suitable for anyone who wants to learn Excel. No prior knowledge of Excel is required.
  • Anyone hoping to expand their analytics skill set, work more efficiently with data, and take their career to a new level
  • Students looking for an engaging, hands-on, and highly interactive approach to Excel analytics training
  • Whether you are a business professional, student, teacher, freelancer, or solopreneur, this training can benefit you and help you take your Excel skills to the next level
  • Excel users looking to build strong analytical thinking and business intelligence skills
  • Anyone looking to pursue a career in data analysis or business intelligence

Excel Formula and Function

  • SUM FORMULA
  • AVERAGE FORMULA
  • PRODUCT FORMULA
  • DIVISION FORMULA
  • SUBTRATION FORMULA
  • FREEZ PANES IN EXCEL
  • PRINITNG COMFIGURATION
  • CONDITIONAL FORMATTING
  • DATA VALIDATION
  • IF FORMULA
  • NESTED IF FORMULA
  • AND FORMULA
  • OR FORMUL
  • IF with AND FORMULA
  • SUMIF FORMULA
  • MAX & MIN FORMULA
  • MAX with INDIRECT FORMULA
  • MIN with INDIRECT FORMULA
  • RIGHT & LEFT FORMULA
  • MID FORMULA 
  • ROW & ROWS FORMULA
  • CONCATENATE FORMULA

  • COLUMN & COLUMNS FORMULA
  • DATE, DAY, MONTH, YEAR FORMULA
  • TIME, HOUR, MINUTE, SECOND FORMULA
  • NOW & DAY360 FORMULA
  • HYPERLINK IN EXCEL DSUM FORMULA
  • DGET FORMULA
  • DMAX FORMULA
  • DMIN FORMULA
  • DMAX FORMULA
  • COUNT, COUNTA, COUNTBLANK, COUNTIF
  • REPLACE FORMULA
  • FIND FORMULA
  • CHOOSE FORMULA
  • LEN FORMULA
  • ISODD FORMULA
  • ISEVEN FORMULA
  • ISTEXT FORMULA
  • ISNUMBER FORMULA
  • TRIM FORMULA
  •  CONVERT FORMULA

  • SUBSTITUTE FORMULA
  • MATCH FORMULA
  • INDEX FORMULA
  • INDEX with MATCH FORMULA
  • ISERR FORMULA
  • IFERROR FORMULA
  • LOOKUP FORMULA
  • VLOOKUP FORMULA
  • HLOOKUP FORMULA