Category: Microsoft Excel Course

Why Learn Microsoft Excel? Here’s 6 Reasons to know the importance of excel!

6 reasons why you should Learn Microsoft Excel

In this modern day and age most of us greatly relies on our computers, tablets, smart phones and the Internet. Businesses can run with a just a laptop! Many great programmers authored useful applications that mankind greatly appreciates and use. One of this is from the family of Microsoft Office. We call it the mighty MS Excel! Just Kidding it’s just MS Excel. It’s probably something you are familiar with but if you’re not, stop reading and take the Microsoft excel courses now! Or maybe you can continue reading to see what you’re missing out. Now, if you are familiar on how to use excel then you probably know the why but did you know there’s a lot you can do with it more than meets the eye? Okay now here comes the whys.

  • Excellent excel skills makes your market value higher

  • Yes! Just like how a new hair style can make you more handsome/pretty, Expertise in MS Excel will automatically earn your resume/CV a gold star! Writing “Advance MS Excel” along with the functions you are well acquainted with in the skills just does not make your resume brighter. It can become the holy grail in the hands of an employer who greatly uses the program. Including functions such as VBA, Macros, Conditional Formatting, Pivot Table, VLOOKUP, Charting, Formulas, and Filtering can automatically give you the lead with your rivals. This also relatively help you achieve you dream job, dream salary, and dream company!

  • Excel has established its dominance

  • I know you know it’s not perfect (according to its competitors) but Excel has great brand recall. I have not met anyone in my business contact that is oblivious to it. Possibilities are endless and most companies use it, that means you have just signed up for a larger labor market and job opportunities. So yes, it’s not going anywhere.

  • Excel makes the world a better place

  • I guess you’re wondering why I said that. Well, if you must know Excel makes those pesky complicated formula calculations easier. It’s also a good basic reporting tool. Understanding excel can really make your life a little bit easy.

  • Excel can help you achieve a healthy work-life balance

  • How can a computer program do that you ask? If you study excel and apply it appropriately to your work, you’ll find it doing time management for you. Things you manually do vs thing excel analytically doing it for you. With the right programming and formula Excel can just shorten the time you must a lot in a specific task. Thus, giving you more time to do other things in your to do list helping you to accomplish the job on time.

  • Excel is not just a spreadsheet

  • If Spreadsheet is the only thing that comes into mind when you hear Excel, then you gravely need to take a course in Microsoft Excel! Excel training just doesn’t help you get things done quicker and more efficient it also expands the possibilities of what you can do using excel. It can increase the effectivity of the reports and analysis that you do which gives you better data that will later support important decisions.

  • If you think you’re an expert think again.

  • You can be a VBA God and really be the expert in Excel, then you can be the trainer! But otherwise, you might still have a lot to learn from a formal training. Tips and Tricks on how to use excel to your advantage will be provided. Training in a formal environment will give you the platform to ask and explore possibilities with the experts so that one day you may also become the expert.

In Conclusion, there are a lot of things you can learn from taking Microsoft Excel Courses. How to use Microsoft Excel is not something you just learn it must mirror what you need it for so you can fully grasp the importance of Microsoft Excel. I hope you learned something today! See you in the classroom!

Learn how to manage project using Microsoft Project

MICROSOFT PROJECT – It is a project management software product and developed and designed and sold by Microsoft. Microsoft project designed to assist a project manager in developing a plan, assigning resources to tasks, tracking tasks, managing the budget, and analyzing workloads.

Learning through Microsoft Project Training is quite helpful for engineers, planners, and even entrepreneurs since this helps them in achieving realistic goals, getting insight about aspects of different projects, and most significant of all is it helps them in controlling every aspect of the project.

HOW TO USE MICROSOFT PROJECT

Microsoft Project has a lot of features for setting up projects and running automated reports formed on progress, budget, time tracking, and more. We’ll take you through the steps required to set-up a timeline, add & schedule tasks, add resources, setup dependencies, generate reports, track progress.

CREATE A TIMELINE IN MICROSOFT PROJECT

Microsoft Project doesn’t have any Timeline template, so we need to enter data manually to build a Microsoft Project Timeline.

HOW TO CREATE A TASK LIST

  • Add Start and Finish Dates to Each Task
  • Add Tasks to the Timeline (You can select all tasks in the list, right-click on the mouse and select Add to Timeline to add all the tasks simultaneously.)

SET UP RESOURCES IN MICROSOFT PROJECT

Now that we have the basic structure for our project. The term Resources typically refers to people, but can also mean documentation type of work that will be needed to complete the project.

  • Open the Resource Sheet
  • Add Resources
  • Once your resources are added to the project list, you can easily view who is available to take on the task based on their workload and manage how much time each team member will spend on project tasks in the Resource Management view.

ASSIGN TASKS IN MS PROJECT

Once you have a list of resources for your project the you can assign tasks. This will help you better manage the project and get work complete in a specific time period. One of the benefits of Microsoft Project is that it can calculate how long it will take a person to complete the task based on their availability. If it’s a particularly important part of the project that needs to be complete quickly, you can assign multiple people to it and Microsoft Project will decrease the time it takes to done the task based on how many resources are assigned.

  • Switch to the Gantt chart
  • Open the Task Form
  • Select a Task to Assign (You can add another person to the same task by clicking the area under Resource Name and choosing the name you want assign. Click OK. As you assign project tasks, the amount of time will be added to the Gantt chart.)
  • Repeat steps to assign all the tasks. 

HOW TO SCHEDULE TASKS AUTOMATICALLY OR MANUALLY

  • Access Microsoft Project Settings
  • Change Schedule Options
  • under Scheduling Options for this Project section, click the drop-down menu forNew Tasks Created. The default is set to Manually Scheduled. Select and click Auto Scheduled then click the OK 

CREATE TASK DEPENDENCIES

Dependencies happens when one task can’t move on to the next phase until a particular task is completed before it. Creating dependencies includes linking tasks in the Gantt chart view. In Microsoft Project, you can link any two tasks with each other

  • Switch to Gantt Chart View
  • Select Tasks to Link (Click the Task tab in the menu section. Identify any two tasks in the list that you want to link. Click the first task and press and hold the Ctrl key then select the second task. Click the chain icon in the ribbon to link the task. You’ll see an arrow appear on the Gantt chart that connects the tasks.)

GENERATE A COST REPORT IN MICROSOFT PROJECT

Once you’ve entered time and resources description to the best of your ability, you can use Project to run a Cost Overview report. Follow these steps to create a Resource Cost Overview report:

  • Select the Report Tab
  • Choose a Cost Report to Run
  • Click the arrow below Costs in the ribbon and click Resource Cost Overview.

TRACK THE PROGRESS OF PROJECT

With Microsoft Project, you can keep an eye on your tasks to see if things are running on time or behind schedule. This will be easy to view and analyze as long as you keep the status of tasks updated during the length of your project.

  • Mark Tasks That Are on Track
  • Use Predetermined Percentages to Track Tasks
  • Update Tasks
  • A dialogue box will appear where you can update task status, change start and end dates. Make any changes and click OK.

Introduction to Excel VBA and Basic Features

How to Create a Macro in Excel

VBA stands for Visual Basic for Applications. VBA enables you to automate different activities in Excel like generating reports, preparing charts & graphs, doing calculations, etc. This automation activity is also often called as Macro. it supports for users to save their time spent behind running the repetitive steps.

Accessing VBA Editor

If you are using Excel version 2007 (or a higher version), click on File > Options > Customize the Ribbon and then check “Developer” and click ok.

A new tab will be added :

Now you can access the Visual Basic Editor in the Developer Ribbon:

In Visual Basic Editor, you will find the Project Window. This window contains number of the “modules” for all workbooks. Modules are where the code is stored. 

To insert a module in sheet and go to the Insert Menu (ALT > I).

You can rename Modules in the Properties Window. Renaming modules make it easier and helpful to organize your code. If your VBA project contains more than one module then you should rename the modules.

MS Excel VBA Features

Macro

Macro is one of the most popular features in Excel 2003 and Excel 2016 VBA. Macros in Excel VBA allow you to convert tasks in Excel by writing.

Macros allow users to automatically create customized charts, reports and perform other functions. In addition, Macros automate tasks and merge program functions that enable developers to build customized solutions using Visual Basic.

CHOOSE function

The CHOOSE function is a built-in function in Excel that is classified as a Lookup/Reference Function. It can be used as a worksheet and VBA function in Excel. As a worksheet function, the CHOOSE function can be entered as piece of a formula in a cell of a worksheet. we can also use this function in macro code that is entered through the Microsoft Visual Basic Editor.