As many books as you want!
Add this book to bookshelf
Grey
Write a new comment Default profile 50px
Grey
Read online the first chapters of this book!
All characters reduced
Excel 2016: Up To Speed - cover

Excel 2016: Up To Speed

R.M. Hyttinen

Publisher: Roger Hyttinen

  • 0
  • 1
  • 0

Summary

The Excel 2016: Up To Speed guide helps you to get up and running  quickly with the world's most popular spreadsheet application.  
This handy step-by-step guide is written from scratch, starting with basic Excel topics and moving on to more advanced features of application, designed to help you to become more productive more quickly.  Though comprehensive, the information in this book is presented in a clear, consise manner with screenshots providing helpful visual guidance all along the way. 
      In no time at all you're be importing and exporting data, creating formulas, modifying and formatting spreadsheets, setting up and formatting data in tables, creating beautiful charts, adding and subtracting dates, creating impressive PivotTables,  and much more. 
Topics include: 
Opening an Existing Workbook 
Navigating a Worksheet 
Creating a New Workbook 
Saving a New Workbook 
Moving Between Workbooks 
Setting Excel Options 
Switching between Views 
Using Tell Me to Obtain Help 
Entering Text and Numbers 
Entering Numbers as Text 
Entering Simple Formulas 
Choosing Formula Cell References 
Using AutoSum 
Total rows and columns at the same time using AutoSum 
Changing & Deleting Data 
Using Undo/Redo 
Using Find and Replace 
Using the Go To Command 
Spell Checking Your Worksheet 
Inserting Symbols 
Using Smart Lookup 
Working with Ranges 
Copying and Pasting Data 
Using the Office Clipboard 
Cutting and Pasting Data 
Copying and Moving Cells using Drag-And-Drop 
Inserting and Removing Rows and Columns 
Copying Data and Formulas with AutoFill 
Using AutoFill to Create a Series 
Filling in Cells using Flash Fill 
Using the Format Cells Dialog Box 
Formatting Values from the Ribbon 
Formatting Numbers 
Formatting Cells 
Hiding and Freezing Rows and Columns 
Inserting Headers and Footers 
Working with Formulas & Functions 
Using a Formula to Join the Contents of Multiple Cells 
Combine Cells using the Ampersand 
Combine cells using the CONCATENATE Function 
Combine cells using the CONCAT Function 
Joining Text with the TEXTJOIN Function 
Pasting as Values 
Adding, Copying and Deleting Worksheets 
Renaming Worksheets 
Repositioning & Grouping Worksheets 
Changing Worksheet Tab Colors 
Using 3-D Formulas & References 
Creating a Table 
Enter Data into a Table 
Deleting Rows and Columns 
Formatting a Table 
Totaling Data in a Table 
Sorting Data in a Table 
Sorting Multiple Columns 
Filtering Data using AutoFilter 
Creating Custom Filters 
Creating a Chart 
Moving a Chart 
Resizing a Chart 
Changing the Layout and Style 
Labeling Chart Elements 
Formatting Chart Text 
Formatting Chart Elements 
Changing the Chart Type 
Showing or Hiding Gridlines 
Customizing Axes 
Creating a Pie Chart 
Changing a Chart’s Source Data 
Moving a Chart to a Different Worksheet 
Saving a Chart Template 
Filtering Chart Data 
Using Sparklines 
Customizing Sparklines 
Adding Pictures 
Inserting Online Images 
Adding Shapes 
Formatting Drawing Objects 
Inserting WordArt & SmartArt 
Inserting & Modifying an Organization 
Chart 
Taking a Screenshot 
Using the IF Function 
Using Nested Functions 
The COUNTIF Function 
Using the PMT Function 
Using the FV Function 
Using AutoCalculate 
Understanding Date/Time Functions 
And much more.... 
   

Other books that might interest you

  • Radical Botany - Plants and Speculative Fiction - cover

    Radical Botany - Plants and...

    Natania Meeker, Antónia Szabari

    • 0
    • 1
    • 0
    Radical Botany uncovers a speculative tradition that conjures new languages to grasp the life of plants in all its specificity and vigor. Plants complement and challenge notions of human life. The book traces the implications of the speculative mobilization of plants within literature and art for feminism, queer studies, and posthumanist thought.
    Show book
  • Theory of Thought - Symbolism - cover

    Theory of Thought - Symbolism

    Jason Shaw

    • 0
    • 2
    • 0
    Theory of Thought presents a simplified way of understanding the impact of symbolism upon society. It employs a new methodology of using basic shapes and concepts to reveal a unique theory of symbols helping to explain human philosophy, religion, and mathematics. 
     
    It explains how all things and ideas are created and governed by some basic patterns. Discover the simple architecture of the 'hyperdimensional' symbols that rule the world and their forces of attraction that pull directly on the minds of all people.
    Show book
  • Think Little - Essays - cover

    Think Little - Essays

    Wendell Berry

    • 0
    • 1
    • 0
    The first in the new Counterpoints series, Think Little is an evergreen, ever-urgent, and now pocket-sized argument for focused and inclusive climate change activism
    Designed and priced for point-of-sale, the Counterpoints series will feature essays, poems, and stories from Wendell Berry, Gary Snyder, Mary Robison, Betty Fussell, MFK Fisher, and many more
    Berry argues that environmental activism and policy change cannot only be a public, large-scale, corporate- and organization-led; instead, changes must happen at the person, individual, and community levels in order for our attempts to slow climate change to be successful. Just as the Civil Rights movement had to become personal, had to be adopted in homes and communities across the country in order to gain momentum and critical mass, so too does environmental activism
    Berry also reminds us that the forces that would exploit people based on their race, gender, and socioeconomic status are the same forces that are content to exploit the earth for its natural resources
    Show book
  • Imagining the Future of Climate Change - World-Making through Science Fiction and Activism - cover

    Imagining the Future of Climate...

    Shelley Streeby

    • 0
    • 2
    • 0
    From the 1960s to the present, activists, artists, and science fiction writers have imagined the consequences of climate change and its impacts on our future. Authors such as Octavia Butler and Leslie Marmon Silko, movie directors such as Bong Joon-Ho, and creators of digital media such as the makers of the Maori web series Anamata Future News have all envisioned future worlds during and after environmental collapse, engaging audiences to think about the earth’s sustainability. As public awareness of climate change has grown, so has the popularity of works of climate fiction that connect science with activism. Today, real-world social movements helmed by Indigenous people and people of color are leading the way against the greatest threat to our environment: the fossil fuel industry. Their stories and movements—in the real world and through science fiction—help us all better understand the relationship between activism and culture, and how both can be valuable tools in creating our future. Imagining the Future of Climate Change introduces readers to the history and most significant flashpoints in climate justice through speculative fictions and social movements, exploring post-disaster possibilities and the art of world-making.
    Show book
  • Listening to the Bees - cover

    Listening to the Bees

    Mark Winston, Renée Sarojini...

    • 0
    • 1
    • 0
    Listening to the Bees is a collaborative exploration by two writers to illuminate the most profound human questions: Who are we? Who do we want to be in the world?
     
    Through the distinct but complementary lenses of science and poetry, Mark Winston and Renée Saklikar reflect on the tension of being an individual living in a society, and about the devastation wrought by overly intensive management of agricultural and urban habitats.
     
    Listening to the Bees takes readers into the laboratory and out to the field, into the worlds of scientists and beekeepers, and to meetings where the research community intersects with government policy and business. The result is an insiders’ view of the way research is conducted—its brilliant potential and its flaws—along with the personal insights and remarkable personalities experienced over a forty-year career that parallels the rise of industrial agriculture.
    Show book
  • Honour Restored - The Battle of Britain Dowding and the Fight for Freedom - cover

    Honour Restored - The Battle of...

    Peter Brown AFC

    • 0
    • 1
    • 0
    At the outbreak of the second World War, Air Chief Marshall Dowding was Commander-in-Chief of RAF Fighter Command, which had been set up three years earlier to protect Britain against attacks from the air and the threat of invasion.  London was subjected to extensive night bombing for several months.  However, our fighter squadrons and defence systems enabled us to maintain master of the air.  The Battle of Britain ended in 1940 and our island was never again under the threat of invasion.
    
    Peter Brown, former Battle of Britain Spitfire pilot, presents a vivid account of Britain under the threat of invasion, reminding us of the bravery of our fighter pilots and the courage of the people of Britain who endured the hardships of war and terror bombing from the air.  Through personal experience and years of meticulous research Peter offers a careful analysis of the battle and the tactics involved, vigorously defending Dowding's command and exposing the conspiracy of senior officers that saw him removed from office without due recognition for his achievement.
    
    PETER BROWN joined the RAF in 1938 and was a Spitfire pilot in both 11 and 12 Groups during the Battle of Britain.  He was awarded the Air Force Cross for his service.
    Show book