Microsoft Excel - Excel from Beginner to Advanced – FREE Intro

Excel with this A-Z Microsoft Excel Course, Advanced Excel Formulas & Functions, data analysis & Much More

Beginner 5(1 Ratings) 9 Students enrolled
Created by Online Courses Learn Online, On Your Schedule | Firste Last updated Fri, 18-Jun-2021 English
What will i learn?
  • • Introduction to Microsoft Excel - Excel from Beginner to Advanced Course
  • • After you finish this Intro Course, enroll in the Full Microsoft Excel Course and become an Excel Guru
  • • https://firsteacademy.com/home/course/microsoft-excel-excel-from-beginner-to-advanced/86
  • • You will learn the following:
  • • Master Microsoft Excel from Beginner to Advanced
  • • Build a solid understanding on the Basics of Microsoft Excel
  • • Learn how to THINK like Excel, and write powerful and dynamic Excel formulas from scratch
  • • Learn the most common Excel functions used in the Office
  • • Harness the full power of Microsoft Excel by automating your day to day tasks through Macros and More
  • • Maintain large sets of Excel data in a list or table
  • • Create dynamic reports by mastering one of the most popular tools, PivotTables
  • • Wow your boss by unlocking dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more
  • • Works for all US and International students, wherever you are on this planet

Curriculum for this course
8 Lessons 00:11:58 Hours
1 Introduction
2 Lessons 00:03:34 Hours
  • 1. Introduction 00:01:56
  • 2. Course Outcome 00:01:38
  • 3. Why Excel 00:01:51
  • 4. Excel Menu System 00:01:34
  • 5. Formula Bar 00:01:23
  • 6. Fonts 00:01:19
  • 7. Row Height and Column Width 00:02:17
  • 8. Bonus Lectures. Enjoy the Benefits
Requirements
  • • All Levels. No prior Excel experience is necessary.
  • • You will need a computer, Laptop, Tablet or a smartphone.
  • • All devices work: Mac or PC, iOS or Android
  • • Microsoft Excel 2007 - 2019 or Office 365
  • • All you need is YOU and YOU! Just have an open mind and willingness to learn and implement
+ View more
Description

Introduction to Microsoft Excel - Excel from Beginner to Advanced Course

After you finish this Intro Course, enroll in the Full Microsoft Excel Course and become an Excel Guru

https://firsteacademy.com/home/course/microsoft-excel-excel-from-beginner-to-advanced/86

You will learn the following:

Enroll now to go through a deep dive of the most popular spreadsheet tool on the market, Microsoft Excel. We will guide you step by step through the beginner to advanced level and beyond.

As you participate in each of the 65+ Lectures that will clear away the pain of stumbling through your daily tasks. You will start with the basics, building a solid foundation that will give you further knowledge as you progress into intermediate and advanced level topics.

At completion of this course, you will have mastered the most popular Excel tools and come out with confidence to complete any Excel tasks with efficiency and grace. Below are just a few of the topics that you will master:

<!--[if !supportLists]-->·       <!--[endif]-->Creating effective spreadsheets

<!--[if !supportLists]-->·       <!--[endif]-->Managing large sets of data

<!--[if !supportLists]-->·       <!--[endif]-->Mastering the use of some of Excel's most popular and highly sought after functions (SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH and many more...)

<!--[if !supportLists]-->·       <!--[endif]-->Create dynamic report with Excel PivotTables

<!--[if !supportLists]-->·       <!--[endif]-->Unlock the power and versatility of Microsoft Excel's Add-In, PowerPivot

<!--[if !supportLists]-->·       <!--[endif]-->Audit Excel Worksheet formulas to ensure clean formulas

<!--[if !supportLists]-->·       <!--[endif]-->Automate your day-to-day Excel tasks by mastering the power of Macros and VBA

So, what are you waiting for, enroll now and take the next step in mastering Excel and go from Excel Newbie to Excel Guru!

 

You will Learn by Practice:

By the end of this Unique Course, you will go from #Newbie to #Advanced as an #Excel #Spreadsheet_Expert. Here is what you’ll learn:

 

1 Introduction

<!--[if !supportLists]-->1.       <!--[endif]-->Introduction

<!--[if !supportLists]-->2.       <!--[endif]-->Course Outcome

<!--[if !supportLists]-->3.       <!--[endif]-->Study Skills Required

<!--[if !supportLists]-->4.       <!--[endif]-->How to get most out of the course

 

2 Getting Started With Excel

<!--[if !supportLists]-->5.       <!--[endif]-->Why Excel

<!--[if !supportLists]-->6.       <!--[endif]-->Excel Menu System

<!--[if !supportLists]-->7.       <!--[endif]-->Quick Access Toolbar

<!--[if !supportLists]-->8.       <!--[endif]-->Workbook and Worksheet

<!--[if !supportLists]-->9.       <!--[endif]-->Status Bar

<!--[if !supportLists]-->10.   <!--[endif]-->Navigation

<!--[if !supportLists]-->11.   <!--[endif]-->Shortcut Menus and Mini Toolbar

<!--[if !supportLists]-->12.   <!--[endif]-->New Workbook

<!--[if !supportLists]-->13.   <!--[endif]-->Save and Save As

 

3 Working With Formula

<!--[if !supportLists]-->14.   <!--[endif]-->Formula Bar

<!--[if !supportLists]-->15.   <!--[endif]-->Creating Simple Formula

<!--[if !supportLists]-->16.   <!--[endif]-->Copying a Formula

<!--[if !supportLists]-->17.   <!--[endif]-->Calculating Year To Date Total

<!--[if !supportLists]-->18.   <!--[endif]-->Percentage Change

<!--[if !supportLists]-->19.   <!--[endif]-->Working With Functions under Formula

 

4 Formatting

<!--[if !supportLists]-->20.   <!--[endif]-->Fonts

<!--[if !supportLists]-->21.   <!--[endif]-->Row Height and Column Width

<!--[if !supportLists]-->22.   <!--[endif]-->Font color and toggle button

<!--[if !supportLists]-->23.   <!--[endif]-->Alignment and Text Wrapping

<!--[if !supportLists]-->24.   <!--[endif]-->Borders

<!--[if !supportLists]-->25.   <!--[endif]-->Numeric and Special Formatting

<!--[if !supportLists]-->26.   <!--[endif]-->Formatting Date and Time

<!--[if !supportLists]-->27.   <!--[endif]-->Conditional Formatting

<!--[if !supportLists]-->28.   <!--[endif]-->Inserting Table

<!--[if !supportLists]-->29.   <!--[endif]-->Shapes and Visual Effects

<!--[if !supportLists]-->30.   <!--[endif]-->Smart Art

 

5 Adjusting Worksheet Layout

<!--[if !supportLists]-->31.   <!--[endif]-->Inserting Rows and Columns

<!--[if !supportLists]-->32.   <!--[endif]-->Shifting Rows and Columns

<!--[if !supportLists]-->33.   <!--[endif]-->Hiding and Unhiding Rows and Columns

<!--[if !supportLists]-->34.   <!--[endif]-->Copying and Moving Data

 

6 Printing

<!--[if !supportLists]-->35.   <!--[endif]-->Print Preview

<!--[if !supportLists]-->36.   <!--[endif]-->Page Layout

<!--[if !supportLists]-->37.   <!--[endif]-->Final Print

 

7 Charts

<!--[if !supportLists]-->38.   <!--[endif]-->Creating Charts

<!--[if !supportLists]-->39.   <!--[endif]-->Changing Chart Types

<!--[if !supportLists]-->40.   <!--[endif]-->Formatting Chart

<!--[if !supportLists]-->41.   <!--[endif]-->Chart Design

<!--[if !supportLists]-->42.   <!--[endif]-->Creating Spark lines

 

8 Worksheet Views

<!--[if !supportLists]-->43.   <!--[endif]-->Freezing and Unfreezing Panes

<!--[if !supportLists]-->44.   <!--[endif]-->Splitting Rows and Columns Horizontally and Vertically

 

9 Multiform Workbook and Worksheets

<!--[if !supportLists]-->45.   <!--[endif]-->Renaming Worksheet

<!--[if !supportLists]-->46.   <!--[endif]-->Inserting and Deleting Worksheet

<!--[if !supportLists]-->47.   <!--[endif]-->Moving and Copying Worksheet

 

10 IF Function

<!--[if !supportLists]-->48.   <!--[endif]-->IF Function

 

11 Vlookup

<!--[if !supportLists]-->49.   <!--[endif]-->Vlookup

 

12 Security and Protection

<!--[if !supportLists]-->50.   <!--[endif]-->Locking and Protecting Data

<!--[if !supportLists]-->51.   <!--[endif]-->Protecting Worksheet Part 1

<!--[if !supportLists]-->52.   <!--[endif]-->Protecting Worksheet Part 2

 

13 Sharing

<!--[if !supportLists]-->53.   <!--[endif]-->Sharing Workbooks

 

14 Data Management

<!--[if !supportLists]-->54.   <!--[endif]-->Sorting Data

<!--[if !supportLists]-->55.   <!--[endif]-->Calculating Sub-Total

<!--[if !supportLists]-->56.   <!--[endif]-->Filtering Data

<!--[if !supportLists]-->57.   <!--[endif]-->Splitting Data Into Different Columns

<!--[if !supportLists]-->58.   <!--[endif]-->Removing Duplicates

 

15 Data Analysis

<!--[if !supportLists]-->59.   <!--[endif]-->Goal Seek

<!--[if !supportLists]-->60.   <!--[endif]-->Scenario Manager

<!--[if !supportLists]-->61.   <!--[endif]-->Data Table

 

16 Pivot Table

<!--[if !supportLists]-->62.   <!--[endif]-->Creating A New Pivot Table

<!--[if !supportLists]-->63.   <!--[endif]-->Manipulation of pivot table

<!--[if !supportLists]-->64.   <!--[endif]-->Grouping Data by Date and Time

<!--[if !supportLists]-->65.   <!--[endif]-->Filtering Data

<!--[if !supportLists]-->66.   <!--[endif]-->Slicer

<!--[if !supportLists]-->67.   <!--[endif]-->Pivot Chart

 

17 Macros

<!--[if !supportLists]-->68.   <!--[endif]-->Using Macros

 

18 Conclusion

<!--[if !supportLists]-->69.   <!--[endif]-->Conclusion

 

19 Bonus Material

<!--[if !supportLists]-->70.   <!--[endif]-->Sorting Data

<!--[if !supportLists]-->71.   <!--[endif]-->Sub-total

<!--[if !supportLists]-->72.   <!--[endif]-->Goal Seek

<!--[if !supportLists]-->73.   <!--[endif]-->Scenario manager

<!--[if !supportLists]-->74.   <!--[endif]-->Pivot table

<!--[if !supportLists]-->75.   <!--[endif]-->Macros

 

20 Additional Content: Grand Finale

<!--[if !supportLists]-->76.         <!--[endif]-->Bonus Lectures. Enjoy the Benefits

 

You could also end up using these skills in your work for Your #Clients, and much more.

 

You'll Also Get:

* Lifetime Access to course updates

So wait no more! Learn Excel, increase your knowledge, become an Excel Expert and advance your career all in a fun and practical way!

WE'D LOVE TO SEE YOU INSIDE AND HELP YOU MASTER EXCEL the Right Way!

Pls leave your much-valued Review.

 

+ View more
Other related courses
17:26:01 Hours
4 5 $199 $2
33:50:11 Hours
5 5 $199 $2
14:14:43 Hours
Updated Fri, 15-Jul-2022
5 5 $199 $2
27:28:08 Hours
5 5 $199 $2
22:43:57 Hours
4 5 $199 $2
About the instructor
  • 24 Reviews
  • 33 Students
  • 87 Courses
+ View more
Online Courses - Learn Online, On Your Schedule | Firste

Firste Academy is an online learning platform with online top best online courses taught by the world's best instructors. Personalized, on-demand e-learning in programming, marketing, data science, development and more.

Student feedback
5
Average rating
  • 0%
  • 0%
  • 0%
  • 0%
  • 100%
Reviews
  • Mon, 11-Jul-2022
    This Excel formula and function course can really take you to next level of Excel. All the examples are well explained, easy to follow. and very practical which can used in daily work. Highly recommended.
Free
Includes:
  • 00:11:58 Hours On demand videos
  • 8 Lessons
  • Full lifetime access
  • Access on mobile and tv