Mastering MS Excel for Reporting
-
COURSE DATES AND LOCATIONS
DATE
Duration
LOCATION
FEES
Book Now
-
INTRODUCTION
This course explains how to use Microsoft Excel. You will learn all about formulas and functions in Microsoft Excel. You will learn how to manipulate both numbers and text. You will be able to create charts so you can share the information graphically with your clients and colleagues. After taking the course you will be confident to use the tool in your everyday life. The knowledge of Excel improves efficiency in the workplace you can gain mastery over crucial Microsoft Excel tools and functions that will enhance efficiency and accelerate performance.
-
COURSE OBJECTIVES
By the end of the course, you‘ll be able to:
- Basic Formulas, Sorting, Styles, Filters
- Full Excel Essentials required for everyday
- Formatting, Header Footers, Print, Page Layouts
- Charts, Chart Styles, Chart Elements
- Orientations, Alignements, Fill Handle, Borders
-
COURSE AUDIENCE
This course is made for:
- Students who want a comprehensive, engaging, and highly interactive approach to training
- Anyone who wants to move ahead in life
- Excel users looking to discover new tools to help them do more in less time
- Business professionals looking to become more confident in Excel
- Data analysts hoping to develop advanced data modeling, dashboard design, and business intelligence skills
-
COURSE OUTLINE
Day One:
- Introduction for Microsoft Excel
- Introduction
Day Two:
- Excel Basics / Fundamentals
- Microsoft Excel Basic Functions, Formulas and Calculations
- Formatting in Microsoft Excel
Day Three:
- Data Handling in Microsoft Excel
- Handling Printing, Layouts, Page Views, Print Preview, Margins, Page Breaks
- Making most of the Data in Microsoft Excel
Day Four:
- Tools for Day to Day Work
- Working with Charts in Microsoft Excel
Day Five:
- Extending Data
- Graphics, View Options and Others
Keyword
Training Subject
Training Location