MS Excel; From Basic to Intermediate - Online Session

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…

About SIMFOTIX:

SIMFOTIX is a trusted name in the executive education industry that offers cutting-edge corporate training programs. SIMFOTIX focuses on creating value for both learners and businesses through its varied program offerings. We, at Simfotix, hold unique expertise in developing our programs based on the design-learning concept that focuses on the key challenges of a learner and organization. Engagement, relevance, and effectiveness are the hallmarks of our learning solutions. So far, SIMFOTIX training programs are attended by over 5000 participants from over 1000 organizations operating MENAT region. Our clients regard their training experience with us inspiring and transformative.

On the e-learning front as well, SIMFOTIX offers courses that result in serious learning but in fun way, we adopt efficient gamification approach that is aligned with clear learning goals that L&D teams want to see as the achieved objectives. We also understand the ever-shifting corporate world challenges and even in online programs, we carry our legacy of quality, relevance, and impact that’s why our programs are conducted by learned faculty comprised of global thought-leaders and top industry practitioners.

We also provide bespoke training solutions that are tailored and delivered in a way that it surpasses your expectations.

  • Soft Skills
  • Finance & Banking
  • Information Technology
  • Gamification

 

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