Excel Basics to Advanced

ebook Microsoft Excel, #1 · Microsoft Excel

By Chandraish Sinha

cover image of Excel Basics to Advanced

Sign up to save your library

With an OverDrive account, you can save your favorite libraries for at-a-glance information about availability. Find out more about OverDrive accounts.

   Not today

Find this title in Libby, the library reading app by OverDrive.

Download Libby on the App Store Download Libby on Google Play

Search for a digital library with this title

Title found at these libraries:

Library Name Distance
Loading...

Unleash the Full Potential of Microsoft Excel with "Excel Basics to Advanced"!
Enhance your Excel skills and become an Excel pro! "Excel Basics to Advanced" is a comprehensive and practical guide that will take your skills from a beginner to advanced.
Key Features

  • Downloadable practice workbooks with solutions for hands-on learning.
  • Covers advanced functions such as VLOOKUP, LOOKUP, INDEX/MATCH,SUM,SUMIFS,COUNT,COUNTA, and more.
  • Dives deep into Pivot Tables, and Excel Tables.
  • Learn how to automate tasks using Macros and edit VBA code.
  • Step-by-step guide to learning Excel
    The Excel basics to Advanced book contains step-by-step exercises to explain the concepts in Excel.
    The book begins with fundamental concepts in Excel and then takes a deep dive into basic and advanced calculations such as Logical, Text, Lookup and Reference, and DateTime functions.
    The book illustrates how to use PivotTable, and Excel tables to analyze data. Readers also learn how to automate Excel tasks using Macros.
    Who this book for?
    Whether you are a student, professional, or business owner, this comprehensive guide will empower you to become proficient in Excel and make the most of its powerful features for data manipulation, analysis, and visualization.
    Table of contents

  • MS Excel Fundamentals
  • Formatting in Excel
  • Introduction to Formulas
  • Logical Functions
  • Text Functions
  • DateTime Functions
  • Mathematical Functions
  • Lookup And Reference
  • Pivot tables and Charts
  • Excel Table
  • Introduction to Macros
  • Excel Basics to Advanced