Training Summary
Excel is the most powerful tool to manage and analyze various types of Data. This tutorial covers in-depth lessons on how to use various Excel formulas, Tables and Charts for managing small to large scale business process.To Microsoft Excel 2007 the basics in 62 pages pdf Excel 2010 Excel 2010 Free Trial Version Excel 2010 from GCF learning free org Excel 2010 is a multi-part course. Excel 2010 Intro 1: Formulas, Functions and Formatting from Bookboon Excel 2010 Intro 2 - Printing, Names and Sheets from Book boom Excel 2013 Excel 2013 from GCF learning.
![Advanced ms excel 2010 tutorial pdf free download pdf Advanced ms excel 2010 tutorial pdf free download pdf](/uploads/1/2/5/8/125887101/192986646.jpg)
What should I know?
Nothing! This course assumes you are a beginner to Excel.
![Tutorial Tutorial](/uploads/1/2/5/8/125887101/593098637.jpeg)
What will you Learn?
IntroductionTutorial | Introduction to Microsoft Excel |
Tutorial | How to Add, Subtract, Multiply, Divide in Excel |
Tutorial | Excel Data Validation, Filters, Grouping |
Tutorial | Introduction to formulas and functions in Excel |
Tutorial | Logical functions (operators) and conditions in Excel |
Tutorial | Visualizing data using charts in Excel |
Tutorial | Case Study: Managing personal finance using Microsoft Excel |
Advance Stuff
Tutorial | How to Import XML Data into Excel [Example] |
Tutorial | How to Import CSV Data (Text) into Excel [Example] |
Tutorial | How to Import MS Access Data into Excel [Example] |
Tutorial | How to Import SQL Database Data into Excel [Example] |
Tutorial | Pivot Tables in Excel: Beginner’s Guide |
Tutorial | Creating Advanced Charts in Excel |
Tutorial | Excel in the cloud: Office 365 |
Tutorial | CSV vs Excel (.xls) - What's the Difference? |
Tutorial | Excel VLOOKUP Tutorial for Beginners: Learn with Examples |
Tutorial | Excel ISBLANK Function: Learn with Example |
Tutorial | Sparkline in Excel with EXAMPLES |
Tutorial | SUMIF function in Excel: Learn with EXAMPLE |
Tutorial | Top 40 Microsoft Excel Interview Questions & Answers |
Tutorial | 20 Best Excel Courses |
Tutorial | 17 BEST Excel Alternatives |
Tutorial | Excel PDF |
Macros & VBA in Excel
Tutorial | Introduction to Macros in Excel |
Tutorial | Creating your First Visual Basic for Applications (VBA) in Excel |
Tutorial | VBA Data Types, Variables & Constant |
Tutorial | VBA Arrays |
Tutorial | VBA Excel Form Control & Activex Control |
Tutorial | VBA Arithmetic Operators |
Tutorial | VBA String Operators |
Tutorial | VBA Comparison Operators |
Tutorial | VBA Logical Operators |
Tutorial | Excel VBA Call a Subroutine |
Tutorial | Excel VBA Function Tutorial: Return, Call, Examples |
Tutorial | VBA Range Objects |
Microsoft Excel 2010 is the powerful software that has been designed to work with formulas, formatting, tables, accounting, and much more. You can do as many things as you want that come to your mind, you can create calendars using beautiful and professional templates. You may get your own style in every work since you will always have the option to edit colors, fonts, sizes, background, insert shapes, etc. You can track your expenses by creating a budget as well as designing your own business invoices. You may even create simple things as a to-do list. Professionally speaking you may show reports by inserting graphics. There's a wide range of things to do using this program. Download its free trial version here.