MS Excel; From Basic to Intermediate

February 24, 20210MS Excel; From Basic to Intermediate

  • Overview
  • Course Outline
  • Workshop Instructions
  • Who Should Attend
  • Testimonials

Overview

Looking for an Excel course online to improve your skills and save you a great  amount of time?

This MS Excel course can quickly get you up to speed with Excel, taking you from  novice to a good user. By the end of the course, you will be equipped with the  real-world Excel knowledge you need to accomplish your daily tasks with ease  MS Excel.

Course Objectives:

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 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 Adding security layers in your Excel files
  • Among many others…

 

Course Outline

Quick Rundown of Excel Environment :
  • What is new in the MS Excel version Short cuts of daily use to optimize your work
  • Overview of standard MS Excel spreadsheet
  • Merge cells, symbols, currency and number formats)
Formatting your Spreadsheet:
  • Freezing row and column titles
  • Using auto-format
  • Custom number formats Using
  • Paste Special
  • Formatting and editing a series
Summarizing & Consolidating Data:
  • Working with Data Tables
  • Grouping & Creating Sub Totals
  • Formatting the Subtotal Rows
  • Adding and Copying with Subtotals
Filter & Sorting:
  • Extracting Unique Values with Filtering
  • Advance Filter on more than 1 Criteria
  • Sorting Data on different cell formats
  • Data extraction by Sorting & Filter
Formulas & Powerful Functions:
  • Relative & Absolute Cell Reference Text Functions (Left, Upper, Concatenate, truncate and others)
  • Date Functions (Today, Now, sorting on dates, extracting Date & Time)
  • Conditional & Logical Functions (If, And, Or, and Not)
  • Using Count IF, SUMIF, Count, CountA
  • Vlookup Function: Data Extraction from Multiple sheets through
  • Using Hlookup function
  • Using MATCH and INDEX
Charts, Graphs & Techniques:
  • Recommended Charts
  • Trend lines
  • Sparkline’s charts
  • Saving Custom Chart as Template
  • Formatting and Editing a series
Conditional Formatting – CF (Quick Overview):
  • Analyzing Data with CF
  • Create, Edit & Delete a CF rule
  • Use databars as a visual guide
  • Find duplicate values
Data Analysis Using Pivots:
  • Creating Pivot table & Analyzing data
  • Grouping data in pivot tables
  • Selecting elements of a pivot table
  • Making use of multiple data fields
  • Using grand totals and subtotal

 

Workshop Instructions

  • 22 November 2021 – 09:00 am – 01:00 pm (KSA) / 10:00 am - 02:00 pm (UAE)
  • Regular Fee: AED 900 Per Participant (Exclusive of VAT)
  • Team Offer: Pay for 2 and register 3rd for free
  • Includes: Courseware, and SIMFOTIX Certificate
  • For registration (s) send us your Name, Designation, Organization, and Mobile Number to register@simfotix.com
  • For More Information please contact: Qazi Waqas Ahmed Mobile: +971 56 309 0819; Email: waqas@simfotix.com

Who Should Attend

  • Financial
  • Advisor
  • Accountant
  • Financial Manager
  • Market Research Analyst
  • Entrepreneurs Sales Representative
  • Banker Business Operations Manager
  • Business Analyst
  • Anyone who has to deal with numbers, and data management, and visualization

Testimonials

Share